thanks a lot Nick. it looks actually better (easier to read) if i don't
use the _continue option with -display-
-radu
On Tue, 6 May 2003, Nick Winter wrote:
> This will be slow, but:
>
> local n=_N
> forval obs=1/`n' {
> di
> di id[`obs']
> foreach var of varlist * {
> if `var'[`obs']>=. {
> di "`var' " _c
> }
> }
> }
>
> Nick Winter
>
>
> -----------------------------------------------------------
> Nicholas Winter, Ph.D. P 202.939.5343
> Policy Studies Associates F 202.939.5732
> 1718 Connecticut Avenue, NW [email protected]
> Washington, DC 20009-1148 www.policystudies.com
> -----------------------------------------------------------
>
> > -----Original Message-----
> > From: Radu Ban [mailto:[email protected]]
> > Sent: Tuesday, May 06, 2003 2:31 PM
> > To: [email protected]
> > Subject: st: displaying variable names for which obs are
> > missing, by row
> >
> >
> > dear all,
> >
> > i want to obtain a listing of the variables that have missing
> > observations, by row. more explicitly, the dataset looks like
> > (on a much
> > larger scale)
> >
> > id var1 var2 var3
> > a1 x . .
> > a2 y z .
> > a3 . t u
> >
> > so i want to obtain an output of the form:
> >
> > a1
> > var2
> > var3
> >
> > a2
> > var3
> >
> > a3
> > var1
> >
> > i tried with the following piece of code:
> >
> > local N = _N
> > forvalues i = 1/`N' {
> > l accid in `i', noobs
> > foreach j of local vlist {
> > l `j' if `j' == . in `i', noobs
> > }
> > }
> >
> >
> > but the problem is that this code lists all the variables for each id,
> > even if they are not missing. the only difference is that when the
> > variable is missing the actual "." is listed, while when it's
> > not missing
> > only the name is listed. thus it is hard to pick up the
> > desired variables
> > just by looking at the log file.
> >
> > does anyone have any suggestions?
> >
> > thanks in advance,
> >
> > radu ban
> >
> >
> >
> > *
> > * 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/
> >
>
> *
> * 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/
>
>
*
* 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/
