Yeah, depends how you want it formatted.
This will die if there are string variables, but could be modified to
test for that first...
Nick
-----------------------------------------------------------
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:53 PM
> To: [email protected]
> Subject: Re: st: RE: displaying variable names for which obs
> are missing, by row
>
>
> 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/
>
*
* 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/
