Did you take a look at -merge- ?
-- Maarten
--- Ana Gabriela Guerrero Serdan <[email protected]> wrote:
> Dear Stata users,
>
> Im trying to match children information with that of
> their mothers. I have two datasets, one includes some
> information for all members of the household and the
> second includes child specific information. I want to
> be able to create a variable in the children's dataset
> about the mothers education levels, age, etc..
>
> My first dataset looks like this:
>
> list HHnum Rosternum Mothernum age HR07 schooling
>
> +--------------------------------------------------------------+
> HHnum Rosternum Mothernum sex age HR32 schooling
> --------------------------------------------------------------
> 1 1 . Male 62 Not elig Has
> atte
> 1 2 . Female 62 Not elig Has
> atte
> 1 3 . Male 41 Not elig Has
> atte
> 1 4 . Female 28 Whole qu Has
> atte
> 1 5 . Male 10 . Has
> atte
> --------------------------------------------------------------
> 1 6 . Male 6 . Has
> atte
> 1 7 . Male 5 . Has
> not
> 1 8 . Male 40 Not elig Has
> atte
> 1 9 . Female 30 Whole qu Has
> atte
> 1 10 . Male 7 . Has
> atte
> --------------------------------------------------------------
> 1 11 . Female 6 . Has
> atte
> 1 12 9 Male 0 . Has
> not
> 1 13 . Male 38 Not elig Has
> atte
> 1 14 . Female 32 Whole qu Has
> atte
> 1 17 . Male 35 Not elig Has
> atte
> 1 18 . Female 29 Whole qu Has
> atte
> 1 19 . Male 8 . Has
> atte
> 1 20 . Female 6 . Has
> not
> --------------------------------------------------------------
> 1 21 18 Female 3 . Has
> not
> 1 22 18 Female 0 . Has
> not
>
>
> So, for household 1, child 12, the mother is 9, for
> household 1, children 21 & 22 mother is 18.
>
> My second dataset is basically a subset of the first
> one but with additional children's information.
>
> list Hhnum Rosternum age sex Mothersnum ,
> etc...
>
> +----------------------------------------+
> Hhnum Rosternum age sex Mothersnum
> ----------------------------------------
> 1. 1 12 Male 0 9
> 2. 1 22 Female 0 18
> 3. 1 21 Female 3 18
> 4. 2 7 Female 1 4
> 5. 2 6 Female 1 4
> ----------------------------------------
> 6. 2 5 Male 3 4
> 7. 3 8 Female 0 .
> 8. 3 7 Male 3 2
> 9. 8 5 Male 2 2
> 10. 19 6 Female 4 2
>
> i have tried a few things like generating new
> variables for mother's var but havent come up with a
> way to do so.
>
> can you suggest anyways to best do the matches?
>
> thanks,
> gaby
>
>
> Gaby Guerrero Serdan
>
> Deparment of Economics
> Royal Holloway, University of London
> TW20 OEX
> Egham, Surrey
> England, UK
> http://www.rhul.ac.uk/economics/About-Us/postgrads.html
> http://www.flickr.com/photos/49939890@N00/
>
> Tel: +44 7912657259
>
>
>
>
____________________________________________________________________________________
> Be a better friend, newshound, and
> know-it-all with Yahoo! Mobile. Try it now.
> http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
>
> *
> * For searches and help try:
> * http://www.stata.com/support/faqs/res/findit.html
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
-----------------------------------------
Maarten L. Buis
Department of Social Research Methodology
Vrije Universiteit Amsterdam
Boelelaan 1081
1081 HV Amsterdam
The Netherlands
visiting address:
Buitenveldertselaan 3 (Metropolitan), room Z434
+31 20 5986715
http://home.fsw.vu.nl/m.buis/
-----------------------------------------
__________________________________________________________
Sent from Yahoo! Mail - a smarter inbox http://uk.mail.yahoo.com
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
