Prakash wrote:
I am working on cleaning up a big dataset. So, I don't want to drop any
of
the missing values. I am using list if command to list 30 variables for
all
the observations that have a missing value for any one or more of these
30
variables. So, I am looking for a big table with variables in the
columns
and observations in the row. The problem that I am facing is that the
output
gets messy and I have to either break these commands with 6-8 variables
being shown at a time. I am curious to find out if there is a way to get
an
excel readable output from the following command
list var1 var2 var3 ....var30 ///
if missing(var1, var2, var3, ...., var30) , ///
table compress noobs string(12)sep(0)clean
listblck module doesn't seem to work either because about 3 variables
that I
want repeated in every block are string variables;
-------------------------------------------------------------
A flexible alternative to -listblck- is -slist-. It may do what you
need. Get it by:
ssc install slist
If you want to use Excel, you can use -outsheet- to create a
tab-separated ascii-file to be imported by Excel:
egen x=rowmiss(var1-var30)
outsheet var1-var30 if x>0 using somename.txt , replace
Hope this helps
Svend
__________________________________________
Svend Juul
Institut for Folkesundhed, Afdeling for Epidemiologi
(Institute of Public Health, Department of Epidemiology)
Vennelyst Boulevard 6
DK-8000 Aarhus C, Denmark
Phone: +45 8942 6090
Home: +45 8693 7796
Email: [email protected]
__________________________________________
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
