Hi All,
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;
Please help as soon as possible if you can,
Thanks,
Prakash
--
Prakash Kashwan
School of Public & Environmental Affairs (SPEA)
Workshop in Political Theory and Policy Analysis; Indiana University,
Bloomington
*
* 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/
