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]
st: Loading long string variables (from SQL) into Stata
From
Jen Zhen <[email protected]>
To
[email protected]
Subject
st: Loading long string variables (from SQL) into Stata
Date
Tue, 4 Sep 2012 15:14:43 +0200
Dear listers,
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/