Jean's solution is good. More Stataish yet is
gen age_hh = AGE if PARENT == "HH"
bysort id (age_hh): replace age_hh = age_hh[1]
Nick
[email protected]
Salvati, Jean
> You can do the following:
>
> gen age_hh_tmp = AGE if PARENT == "HH"
> bysort id: egen age_hh = mean(age_hh_tmp)
Scott Cunningham
> > I have the following:
> >
> > ID Name PARENT AGE
> > 1 Bryan HH
> > 45
> > 1 WIll son
> > 10
> > 1 Lucy mom 30
> > 2 Scott HH
> > 30
> > 2 Paige mom 31
> > 2 Miles son
> > 4
> >
> > I need to create a variable ("age_HH") which will equal the
> > age of the head of household ("HH"). I then need to make
> > everyone of the same family ("ID") have that value. Is it
> > sufficient to do the
> > following:
> >
> > . bysort id: gen age_hh=age if parent==hh
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
