Statalist


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

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


From   "Martin Weiss" <Martin.Weiss1@gmx.de>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: counting the number of nonmissing values in varlist for each observation
Date   Mon, 28 Dec 2009 18:52:46 +0100

<>

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/

-- 
Jetzt kostenlos herunterladen: Internet Explorer 8 und Mozilla Firefox 3.5 -
sicherer, schneller und einfacher! http://portal.gmx.net/de/go/atbrowser
*
*   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