Re: st: matching children and parents

[Andrea Smurra <andrea.smurra@gmail.com>]

Thanks Nick,

I have tried the multi-dataset approach before: works, but it very time consuming.
Unfortunately, I have many households which comprehend 3 or more generations, hence I cannot apply your second approach
Finally, I have not been able to open your link.

Andrea

On 12 Jun 2013, at 14:56, Nick Cox wrote:

> This is an FAQ:
> 
> http://www.stata.com/support/faqs/data/members.html
> 
> is an out-of-date URL, but you should be re-directed. (As I write the
> Stata site seems to be temporarily inaccessible.)
> 
> Another approach is schematically
> 
> egen mother_education = total(education / (person == mother)), by(household_id)
> 
> which assumes that education is a numeric variable and there is at
> most one mother in each household. This is likely to be too simple, so
> see the FAQ above.
> 
> Another approach is to reduce your dataset to a dataset of mothers and
> a dataset of children and then -merge-.
> 
> 
> Nick
> njcoxstata@gmail.com
> 
> 
> On 12 June 2013 08:45, Andrea Smurra <andrea.smurra@gmail.com> wrote:
>> Hello everyone.
>> I am dealing with a big household survey.
>> I am interested in child labor and education and my objective is to create variables for each children representing parents or household' characteristics.
>> In particular, for each children I created two variables specifying the IDs of mother and father. Now I would like to create a  variable that, for each children, specifies parents' education in the following way
>> 
>> motheredu_i=education[motherID_i]
>> 
>> where education is a variable already in the dataset
>> 
>> I know a way to do this, but it is extremely time consuming and I was wondering what would be the syntax to create the above "function".
>> 
>> Thanks.
>> *
>> *   For searches and help try:
>> *   http://www.stata.com/help.cgi?search
>> *   http://www.stata.com/support/faqs/resources/statalist-faq/
>> *   http://www.ats.ucla.edu/stat/stata/
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/faqs/resources/statalist-faq/
> *   http://www.ats.ucla.edu/stat/stata/


*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/