Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: Loading long string variables (from SQL) into Stata
From
Nick Cox <[email protected]>
To
[email protected]
Subject
Re: st: Loading long string variables (from SQL) into Stata
Date
Tue, 4 Sep 2012 15:53:19 +0100
-compress- can do nothing to help and not just for the reason you
mention, that the variables in Stata were truncated on input.
-compress- will only compress variables from one storage type to a
more compact storage type when that is possible without loss of
information. But the longer strings could not be variables to start
with and in any case there would be loss of information.
Nick
On Tue, Sep 4, 2012 at 2:41 PM, tashi lama <[email protected]> wrote:
> I would also like to find the answer. There is _compress but I am not sure it will be any help since the columns are already truncated before it loads. _compress seems to be helpful once the columns are successfully loaded and you want to save the memory.
By the way, if you are running stata in unix, did you have any problem
loading sql columns with type varchar? I am having an issue while
loading columns with type varchar.
From: [email protected]
>> I`m loading some variables from an SQL database into Stata using the 2
>> lines of code given below.
>> One of them is a very long string variable that gets cut off when
>> loaded into Stata. Is there a way to either increase the maximum
>> length of string variables allowed in Stata, or to automatically split
>> each string at whatever is the maximum number of symbols and put the
>> rest into further string variables?
>> Thanks so much and best regards,
>> JZ
>>
>> local sql "SELECT var1, var2, var3 FROM database WHERE var1>5"
>> odbc load, exec("`sql'") conn("`db'")
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/