# st: RE: counting number of children in a household

 From Friedrich Huebler To statalist@hsphsun2.harvard.edu Subject st: RE: counting number of children in a household Date Wed, 1 Mar 2006 08:44:31 -0800 (PST)

Zamira,

your code with other Stata users is a good way to become more
proficient in Stata. Your message stimulated an interesting
discussion and I am sure no one intended any malice.

That said, in addition to the criticism provided by other list
members I would like to mention that there is a fundamental problem
with your "relationship" variable. Take the household below, with one
male and three female members. A couple has one daughter who is 16
years old. This daughter in turn has a child who is 2 year old. The
16-year-old girl is therefore both a mother and a child, in the legal
and biological sense. The "relationship" variable with its simple
"father", "mother", "child" structure fails in this case. The
situation would be further complicated if one or more of the couple's
parents also lived in the household.

hhid  lineno  age  sex
1     1       42   1
1     2       40   2
1     3       16   2
1     4       2    2

Friedrich Huebler

--- Zamira Simkins <zs9814a@american.edu> wrote:
> The same trick can be used if you want to create variables with
> parents' education: let's say you need to create mom_ed and dad_ed,
> but your data only allows you to identify parents via a variable
> called relationship. Say, relationship 1=dad, 2=mom, 3=children and
> you have one variable called educ. Then:
>
> sort hhid
> egen mom_ed=educ if relationship==2
> /*at this point hhid does not matter, as the above variables will
> take a missing value if the "if" condition is not satisfied*/
> egen mom_educ=max(mom_ed), by(hhid)
> /*this assigns mom's and dad's education levels to all members of
> the household*/

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
*
*   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/