Statalist


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

st: reading data with missing obs


From   Glen Waddell <[email protected]>
To   [email protected]
Subject   st: reading data with missing obs
Date   Sun, 08 Feb 2009 00:14:17 -0800

All,
I am trying to read in data from multiple xml files (although this issue is not specific to this format, I believe) in which some of the sheets within some of the files have variable names in the first row and nothing else. That is, all variables are missing in some of the sheets within some of the files.

In reading in these files, Stata only appears to read in the first variable... not continuing to subsequent columns. If I had but a few files I would brute force this by filling the empty cells with some unique character, read them in and then drop the obs accordingly. However, I have many of these sheets to be read in, so automating it would be quite valuable.

Many thanks,
Glen



*
*   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–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index