<>
http://www.stata.com/statalist/archive/2009-03/msg00674.html
HTH
Martin
-------- Original-Nachricht --------
> Datum: 14 Mar 2009 18:04:47 -0500
> Von: [email protected]
> An: [email protected]
> Betreff: st: Creating variables describing parents\' characteristics with parents\' ID
> Hello Stata Users,
>
> I'm sorry if you already got this email. I'm resending it because I am not
> sure if it went out correctly.
> It is the first time I send a question to statalist serv.
> Please execuse me if I made some mistakes or violated common rules.
>
> I would like to generate a new variable which contains the information of
> parents, e.g. dad's education.
> My data looks like below.
>
> FID PID Var1 Edu Var3 Dad's FID Dad's PID Dad's Edu
> 1001 10 1 3 5 . .
> 1001 20 3 3 2 . .
> 1001 30 4 2 3 1001 10 3
> 1001 31 8 5 5 1001 10 3
> 1002 1 2 4 3 . . .
> 1002 10 4 2 1 1002 1 4
> 1002 20 5 4 2 . . .
> 1002 30 9 3 2 1002 10 2
> 1002 31 6 1 4 1002 10 2
> 1002 32 4 2 5 1002 10 2
>
> Note: FID = Family ID; PID = Person ID; Edu = Educational attainment
> (Values are randomly assigned, but data structure is similar to the
> above.)
>
> What I want to do is to have the last (far left) column, which is not
> included in the dataset. (I want to do this kind of works for other
> variables, e.g. Var1 and Var3.)
> What is the best & simplist way to do this in stata?
>
> I think I can do this like the following.
> 1) Split the data set into two files so that one file contains Dad's FID
> and Dad's PID, and the other has all others.
> 2) Then, rename FID and PID in the second file as Dad's FID and Dad's PID.
> 3) Rename Edu (and/or other variables I want to have at Dad's level) as
> Dad's Edu
> 4) Merge two files by matching Dad's FID and Dad's PID.
>
> However, I think there might be easier way to do this.
> Please let me know if you know anything that makes the work easier.
>
> Thanks much, in advance.
>
>
>
> Eunsu Ju
>
> Ph.D. Candidate, Research Specialist
> School of Social Work, University of Minnesota
>
>
> *
> * 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/
--
Martin Weiss
Hackersteigle 3
72076 Tübingen
00497071/793535
00491784597218
Psssst! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger01
*
* 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/
