Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: Displaying list command output with large number of variable


From   "Prakash Kashwan" <[email protected]>
To   <[email protected]>
Subject   st: Displaying list command output with large number of variable
Date   Wed, 18 Apr 2007 23:41:48 -0400

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/



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