If you would manually match a child to a mother, what variables would
you use?
--- Ana Gabriela Guerrero Serdan <[email protected]> wrote:
> Dear Maarten,
>
> Yes, ofcourse. The problem is that if I merge by using
> hhnumber and mothers number there is a mismatch
> because it means i merge the children dataset with its
> own number as it is indicated in the mothersnumber. I
> cant use roster number neither.
>
> I have created an additional identifier for each of
> them. So i can merge child rosternumb 12 with mother
> rosternum 9. Here is waht I have tried generating an
> additional id to be used for both datasets.
>
> In childrens dataset:
> gen id= Mothernum
>
> In other dataset:
> gen id=rosternum
>
>
> sort Hhnum id
>
> merge Hhnum id using " dta"
>
> but i somehow dont get the mothers variables
> adequately into the children's dataset.
>
>
> txs,
> Gaby
>
> --- Maarten buis <[email protected]> wrote:
>
> > 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
>
=== message truncated ===
-----------------------------------------
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/
-----------------------------------------
___________________________________________________________
Support the World Aids Awareness campaign this month with Yahoo! For Good http://uk.promotions.yahoo.com/forgood/
*
* 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/
