Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | "Mills, Michael" <mmills@rti.org> |
To | <statalist@hsphsun2.harvard.edu> |
Subject | st: ODBC misreading or not reading numbers with allstring option |
Date | Thu, 10 May 2012 11:18:04 -0400 |
I'm importing data from Excel to Stata with ODBC (to which I'm rather new) and several observations have some variables being read in as "E-2" rather than the number that exists in the Excel files. It appears the numbers in Excel appearing as "E-2" are almost always <0.1 and are repeating (e.g. 0.08333333333333 or 0.066666666666667). I often have multiple, duplicate, observations and generally this issue will occur for the same variable within a set of duplicates. However, there are occasionally observations for which the data has been read in (0.83333333333). Any thoughts on why this is occurring and what could be done to read in the data? Could this be a length of number/string issue? And can I resolve this without altering the original Excel files (given the number of files, this would be quite time-consuming)? Code and sample data are below. Local macro rawpath is defined previously, as are site, center2, and wkst2, which are looped over to read in multiple files: local source "Excel Files;DBQ=`rawpath'\\`site'\\`center2'.xls" clear disp _newline(2) "`center2'" _newline(2) "`wkst2'" odbc load, dsn("`source'") table("`wkst2'$") clear lowercase allstring date var1 var2 var3 01jan2009 0.354 0.8 0.384 01jan2009 0.354 0.8 0.384 01jan2009 0.354 0.8 0.384 01jan2010 0.18123380952381 0.855712345605472 E-2 01jan2010 0.18123380952381 0.855712345605472 E-2 01jan2010 0.18123380952381 0.855712345605472 E-2 01jan2011 0.1945662721893 0.849710789659 0.13844646461538 01jan2011 0.1945662721893 0.849710789659 0.13844646461538 01jan2011 0.1945662721893 0.849710789659 0.13844646461538 Thanks, - Mike Mills * * 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/