Statalist


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

Re: st: Missing values and listing IDs


From   Svend Juul <SJ@SOCI.AU.DK>
To   <statalist@hsphsun2.harvard.edu>
Subject   Re: st: Missing values and listing IDs
Date   Thu, 13 Nov 2008 16:27:39 +0100

Sham wrote:
 
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?
 
=======================================================
 
   egen miss = rowmiss(x1-x6)
 
Note that in this -egen- function, x1-x6 is a variable list, as 
opposed the rule for an expression where it means a difference.
It does not necessarily mean x1,x2,x3,x4,x5,x6; that depends on
what variables come between x1 and x6 in the dataset.
 
Hope this helps
Svend

________________________________________________________ 
 
Svend Juul
Institut for Folkesundhed, Afdeling for Epidemiologi
(Institute of Public Health, Department of Epidemiology)
Vennelyst Boulevard 6 
DK-8000 Aarhus C,  Denmark 
Phone, work:   +45 8942 6090 
Phone, home:   +45 8693 7796 
Fax:           +45 8613 1580 
E-mail:        sj@soci.au.dk 
_________________________________________________________ 

*
*   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