Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: st: Missing values and listing IDs


From   "Nick Cox" <n.j.cox@durham.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   RE: st: Missing values and listing IDs
Date   Thu, 13 Nov 2008 13:04:07 -0000

Note that what you must type, or otherwise get Stata to see, is 

missing(x1,x2,x3,x4,x5,x6)

That is, Stata will not replace an ellipsis ... with what you intend or
imply. 

That said, you can go 

list id if missing(x1,x2,x3,x4,x5,x6)

The new variable is not essential for this purpose. 

Nick 
n.j.cox@durham.ac.uk 

Johannes Geyer

gen miss0 = missing(x1,x2,x3,...,x6)
list id if miss0 == 1

Sham 

> I wish to list the ID numbers of those individuals in my dataset 
> that have at least one missing value out any six variables (x1-x6). 
> At the moment I have used the following logic: 
> 
> list responder_status ID if  x1==. | x2==. | ///
> x3==. | x4==. | x5==. | x6==.

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



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