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! Your suggestion works!
Dear Maarten and Eric thank you very much for your earlier suggestions! 
In the end I used the way suggested by Martin as it seemed to work best 
with my data, but looking into alternative possibilities was very useful!
warm regards,
Ekaterina

Weiss wrote:
> <>
>
> Just change the "fammem" vars to missing based on your condition before you use -egen-, then:
>
> ***
> forv i=1/10{
> 	replace fammem`i'=. if fammem`i'_liv==30
> }
> ***
>
> HTH
> Martin
>
> -------- Original-Nachricht --------
>   
> > Datum: Mon, 28 Dec 2009 18:31:42 +0100
> > Von: Ekaterina Hertog <ekaterina.hertog@sociology.ox.ac.uk>
> > An: "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
> > Betreff: Re: st: counting the number of nonmissing values in varlist for each observation
> >     
>
>   
> > 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/
> >     
>
>   

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