Re: st: counting the number of nonmissing values in varlist for each observation

[Ekaterina Hertog <ekaterina.hertog@sociology.ox.ac.uk>]

Dear Martin,
Thank you very much for the advice! Sorry I should have looked at -help 
varlist-, I only thought of -help egen-.
I have got an additional question, I just realised that a couple of 
hundred of individuals in my dataset named family members who have 
passed away. For these people fammem1_liv etc has a particular value 
(30). Is it possible to specify the varlist for rownonmiss in a way that 
it will presume fammem1 to be missing if fammem1_live==30, fammem2 
missing if fammem2_live==30 etc.?
sincerely yours,
Ekaterina

> <>
>
> See the rules at -help varlist-: "?" stands for one character...
>
>
> ***
> clear*
> set obs 10
> forv i=1/10{
> gen fammem`i'=cond(runiform()<.1,.,1)
> gen fammem`i'_liv=.
> }
> egen nmbfammem= rownonmiss(fammem? fammem??)
> su nmbfammem
> ***
>
>
> HTH
> Martin
> -------- Original-Nachricht --------
>   
> > Datum: Mon, 28 Dec 2009 17:13:40 +0100
> > Von: Ekaterina Hertog <ekaterina.hertog@sociology.ox.ac.uk>
> > An: "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
> > Betreff: st: counting the number of nonmissing values in varlist for each observation
> >     
>
>   
> > Dear all,
> > I need to create a variable which will contain the count the number of 
> > nonmissing values in varlist for each observation for the variables 
> > called fammem1, fammem2 etc.
> >
> > I came up with the following command:
> > egen nmbfammem= rownonmiss (fammem*)
> >
> > The problem is I have two types of variables starting with fammem:
> > fammem1, fammem2 etc. until fammem10 (which note one's family members)
> > and
> > fammem1_liv, fammem2_liv etc. (which notes whether one lives with the 
> > given family member in the same household or not)
> >
> > and I only want to create the count of one's family members.
> >
> > Is it possible in Stata 11 to specify varlist as all variables the name 
> > of which start with fammem followed by a number between 1 and 10?
> > I will be very grateful for advice,
> > Sincerely yours,
> > Ekaterina
> > *
> > *   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/
> >     
>
>   

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