Re: st: Linking information from other family members

[Friedrich Huebler <fhuebler@gmail.com>]

Quang,

If I understand your question correctly, you want to know the age of
each child in the year of migration. There are several problems with
your post. The excerpt from your data has line breaks and is difficult
to read. The relationship codes are not explained. The meaning of the
variables Y1, Y2 and Y3 is not clear. Most importantly, there don't
seem to be variables with a person's age or year of birth. Without
this information it is not be possible to calculate a child's age in
any given year.

Friedrich

On Wed, Feb 9, 2011 at 8:33 AM, Quang Nguyen <quangdata@gmail.com> wrote:
> We have a data that have information on migration status and year of
> migration for each member. The migration took place in different
> years. The member we're interested in the child's age of the household
> when each migration occured. Example of the data as follows:
>
> Family_id    Relationship    Migration     Year_migration     Y1     Y2    Y3
> 1                        1                 1                   1998
> 1                        2                 1                   2001
> 1                        3                 1                   2008
> 1                        4                 0
>           1998   2001   2008
> 1                        5                 0
>           1998   2001   2008
>
>
> How can we generate variables Y1, Y2 , Y3 as above?

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