Dear statalist,
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==.
But I'm not sure if this is correct, so I did the following which I think is.
gen miss=0
recode miss 0=1 if x1==.
recode miss 0=1 if x2==.
recode miss 0=1 if x3==.
recode miss 0=1 if x4==.
recode miss 0=1 if x5==.
recode miss 0=1 if x6==.
However is there a more succinct way to write this code, instead of 7 lines?
Thanks in advance
Sham
*
* 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/