Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.

# Re: st: generating parent variable in child level data

 From Eric Booth To "" Subject Re: st: generating parent variable in child level data Date Mon, 8 Nov 2010 18:22:14 +0000

```<>

One issue would be if you've got multiple fathers or mothers listed for a child/HHID (both my post and Nick's post mention this potential issue...plus, Nick shows you how to count the parents to check for this).
The problem is that -egen, total()- will add up the ages for the two fathers, so using earlier example,  you'll get the value of 62 for HHID 2 (see below).

*****!

clear
inp hhid   str10(relation)    age    education
1   father      40        8
1   mother    38        3
1   son         18       4
1   son         15       2
1   daughter   12      2
2   father  30  9
2   son     5   2
2   father  32  12
end

g fage=age if relation=="father"
bys hhid: egen fage1=total(fage)
li
*****!

- Eric

__
Eric A. Booth
Public Policy Research Institute
Texas A&M University
ebooth@ppri.tamu.edu

On Nov 8, 2010, at 12:09 PM, Shikha Sinha wrote:

> Thanks everyone for your advice. I tried the following and it worked.
> Do you see any probelm in the follwoing approach:
>
> g fage=age if relation=="father"
> bys hhid: egen fage1=total(fage)
>
> Thanks,
> Shikha
>
> On Mon, Nov 8, 2010 at 7:15 AM, Nick Cox <n.j.cox@durham.ac.uk> wrote:
>> This crossed with Eric Booth's solution, which in a way is about half-way between mine and Mitch Abdon's.
>>
>> In my solution, the age for the mother, for example, is recorded for the mother herself and also for the father. Values in such observations can be ignored if of no interest or set to missing afterwards.
>>
>> For more on -cond()- if desired, see
>>
>> SJ-5-3  pr0016  . . Depending on conditions: a tutorial on the cond() function
>>        . . . . . . . . . . . . . . . . . . . . . . .  D. Kantor and N. J. Cox
>>        Q3/05   SJ 5(3):413--420                                 (no commands)
>>        tutorial on the cond() function
>>
>> Nick
>> n.j.cox@durham.ac.uk
>
<snip>

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