# st: Creating a new variable using household level data

 From Ali Murat Berker To statalist@hsphsun2.harvard.edu Subject st: Creating a new variable using household level data Date Sun, 13 Feb 2005 23:40:19 +0200

```Hello all,
I am working on several Demographic and Health Surveys. I converted
the data from wide to long form by using reshape command. I  obtained
the data presented below.
* Label list for relhd: relation to head
2 wife or husband
3 son/daughter
4 son/daughter-in-law
5 grandchild
6 parent
7 parent-in-law
8 brother/sister
9 co-spouse
10 other relative
12 not related
98 dk;
* Label list for gender:
1 male
2 female;
Table 1
hhid   linenumber   Relhd        age       gender   Father's line
number  Mother' s line
11	1	1	42	1	.                       .
11	2	2	37	2	.                       .
11	3	3	16	2	.                       .
11	4	3	10	2	2                       1
11	5	3	5	1	2                       1
16	1	1	53	1	.                        .
16	2	2	53	2	.                        .
16	3	3	31	1	.                        .
16	4	4	30	2	.                        .
16	5	5	6	1	4                       3
16	6	3	25	1	.                        .
34	1	1	52	1	.                        .
34	2	2	48	2	.                        .
34	3	3	24	1	.                        .
34	4	3	16	1	.                        .
34	5	3	13	1	2                       1
34	6	4	29	2	.                        .
34	7	5	3	2	6                       3

Using the data in Table 1, I want to create four new variables: a
dummy variable for a being father, a dummy variable for  being a
mother, father's age, mother's age.
I just can't figure out how to use father's and mother' s line number
to obtain these varaibles.  If there were only a mother and a father,
and children in the household, it would be very easy to create dummy
variables for being a father and mother. One simply needs to do:
* Create a dummy variable for the presence of the father in a household;
gen father=0;
replace father=(gender==1 & relhd==1) | (gender==1 & hmemrelhdw==2);
Howewer, the data suggest that more than one famliles may live in the
same houesehold. Then, two command lines stated above are not able to
produce  the desired outcomes.
How can I do this task? Any help are more than welcome.
Best Regards.
Ali M Berker
*
*   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/
```