Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: RE: insheet numeric variables as strings


From   "Nick Cox" <n.j.cox@durham.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: insheet numeric variables as strings
Date   Wed, 20 May 2009 14:01:11 +0100

Roy Wada detailed a strategy to ensure that those variables are read in
as you want. 

An alternative downstream fix is to -tostring- the mis-read integer
variables with a leading zero format. That's a single line. 

Nick 
n.j.cox@durham.ac.uk 

Xia Jing
 
I am reading a comma delimited file (.txt) to STATA with "insheet", but
I'd like to make sure some variables are read in as strings, as I do not
want to lose leading zeros in these variables (ICD-9 procedure codes). 
 
Stata currently reads them in as integers.
 
I know I can manually change the first line values of these variables to
some artificial characters.  But with large files and large number of
variables, this approach becomes quite inconvenient. I'm writing to ask
whether there is a better way to do this.

*
*   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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index