what about this:
local varlist "`r(varlist)'"
local varlist : subinstr varlist " " ", ", all
list if mi(`varlist')
Hope this helps,
Maarten
--- Ronnie Babigumira <[email protected]> wrote:
> Hello,
>
> I have a quarterly data set and I am trying to identify missing cases
>
> houscode qtr wage_ld biz_lead
> 72 1 0 0
> 81 1 0 1
> 81 2 . 1
> 11 3 0 1
> 10 4 . .
> 9 1 1 0
>
> I started by using Nick Cox's very useful -nmissing- (ssc install
> nmissing)
>
> Which gave me
>
> wage_ld 2
> biz_lead 1
>
>
> Knowing which variables have missing cases, I
>
> list if mi(wage_ld, biz_lead)
>
> However, to generalize it (I will be doing it by quarter) I used
>
> nmissing
> tokenize `r(varlist)'
> list if mi(`1' `2')
>
> This works for the data as it is, however, you will notice that the
> missing cases are in qtr2. So, if I did this
> analysis by quarter and I
>
> keep if qtr == 1
> nmissing
> tokenize `r(varlist)'
> list if mi(`1', `2')
>
> I get ........invalid syntax...............
>
> I reckon this is coming from the fact that indeed for qtr == 1, I do
> not have two variables with missing data. So, is
> there a way I can tweak this to allow it to proceed?
>
> Ronnie
> *
> * 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/
>
-----------------------------------------
Maarten L. Buis
Department of Social Research Methodology
Vrije Universiteit Amsterdam
Boelelaan 1081
1081 HV Amsterdam
The Netherlands
visiting address:
Buitenveldertselaan 3 (Metropolitan), room Z434
+31 20 5986715
http://home.fsw.vu.nl/m.buis/
-----------------------------------------
__________________________________________________________
Sent from Yahoo! Mail - a smarter inbox http://uk.mail.yahoo.com
*
* 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/
