Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: matching children and parents


From   Nick Cox <njcoxstata@gmail.com>
To   "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
Subject   Re: st: matching children and parents
Date   Wed, 12 Jun 2013 10:27:26 +0100

The link is now accessible and redirects to

http://www.stata.com/support/faqs/data-management/creating-variables-recording-properties/
Nick
njcoxstata@gmail.com


On 12 June 2013 09:52, Andrea Smurra <andrea.smurra@gmail.com> wrote:
> 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/
*
*   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/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index