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: Reading txt file with missing value
From 
 
Kay Walker <[email protected]> 
To 
 
[email protected] 
Subject 
 
st: Reading txt file with missing value 
Date 
 
Fri, 19 Nov 2010 18:29:04 +1030 
Kim
You need to edit the text file using an editor program like emacs or 
UUedit before importing into Stata. Choose a suitable value for the 
"Missing" category- a value that would never be a part of the data that 
is valid, eg. 9 when all valid data is in the range 1 to 5. Then you 
need to label the values in the variables, including a label "missing" 
for the 9s. You don't say whether you have a case or column delimiter 
like a space, comma or tab- this would slightly change how  you import 
your data and would make it easier to edit- you could change all the 
instances where there is a double delimiter (like ,,) to ,9, in one 
operation.
This is the simplest method I can think of- programmers may have 
something easier.
Kay
*
*   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/