creating variable for "any sibling"

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

creating variable for "any sibling"

This post has NOT been accepted by the mailing list yet.

I have a household survey data and would like to construct a variable for "any siblings" and "number of siblings". I have data for each household member. In columns, I have relation to young adult 1 (YA1), relationship to YA2, and relationship to YA3. For example, under relationship to YA1 column, I have "self" and under relationship to YA1 (for the same household) I have "brother/sister". I hope to create a variable that indicates "1" for the young adult individual that reported "self" and "1" for the individual who is the "brother/sister" of that young adult1.

sort hhid
gen w1h_anysib=0
by hhid: replace w1h_anysib=1 if w1h_reltoya1 == 7

I get "1"s for the individuals who are brother or sister of YA1 however, the YA1 him/herself does not have the "1" indicator.

Any help would be greatly appreciated.
Thank you!