Many thanks Nick I had already done it from www.stata.com your answer
May 2001 updated April 2005, Martin sent me the link.
The detail of age <. is also very important.
On 7/1/09, Nick Cox <[email protected]> wrote:
> This sounds like
>
> egen nadults = total(age >= 18 & age < .), by(IDhousehold)
>
> -egen- as I recall is not even mentioned in [U], but there's a help
> page.
>
> The Data Management FAQs on www.stata.com are fairly dense with nearby
> examples.
>
> Nick
> [email protected]
>
> Joana Estata
>
> I matched 2 files, one of households and other of individuals of each
> household.
> Now I have a file where the characteristics of each household are
> associated with each individuals.
> I want:
> (a) to create a variable which count how many adults (18+) exist in
> each household . Observations are individuals, so it means how many
> times the same IDhousehold appears associated with an individual with
> 18 years old or upper.
> (b) add the variable obtained in (a) to the household characteristics
> (number of adults per household will be add to other characteristics
> as size or income).
> I have User Guide STATA Release 9, junt send me to a page.
>
> *
> * 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/
