Re: st: AW: RE: count in matched family-individuals file

["Martin Weiss" <martin.weiss1@gmx.de>]

<>

It is described in the Data Management Reference Manual [D].


HTH
Martin
_______________________
----- Original Message ----- 
From: "Joana Estata" <estata@gmail.com>
To: <martin.weiss1@gmx.de>
Sent: Wednesday, July 01, 2009 6:48 PM
Subject: Re: st: AW: RE: count in matched family-individuals file


Dear Martin,
Your information was fine. It worked perfect.
In fact I was not able to find egen in [U].
Best regards,
Joana

On 7/1/09, Martin Weiss <martin.weiss1@gmx.de> wrote:
> <>
>
> Joana should replace my earlier line
>
> *************
> bys fam: egen over18=/*
>  */ total(memberage>=18)
> *************
>
> by
>
> *************
> bys fam: egen over18=/*
>  */ total(memberage>=18 & memberage<.)
> *************
>
>
> I sought refuge in the statement in the help that missing values count as
> zero for this -egen- function, but the -expression- in the parantheses is
> never missing although the -memberage- being compared may be... So I have 
> to
> check explicitly...
>
> HTH
> Martin
>
>
> -----Ursprüngliche Nachricht-----
> Von: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Nick Cox
> Gesendet: Mittwoch, 1. Juli 2009 12:38
> An: statalist@hsphsun2.harvard.edu
> Betreff: st: RE: count in matched family-individuals file
>
> 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
> n.j.cox@durham.ac.uk
>
> 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/

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