st: generating parent variable in child level data

[Shikha Sinha <shikha.sinha414@gmail.com>]

Dear  all,

I have a household level data set in which each household has father,
mother, and child level data as row, something as the following:

hhid   relation    age    education
1        father      40        8
1        mother    38        3
1        son         18       4
1        son         15       2
1        daughter   12      2

I wish to generate parent level variable (age, education)  for every
children in the same household. Please suggest.

Thanks,
Shikha
*
*   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/