<>
Generally speaking, you may want to browse the FAQ at
http://www.stata.com/support/faqs/data/#manip . Most of the time, you will
end up not using -duplicates-, but -bysort- to conduct such operations. See
Nick`s http://www.stata-journal.com/sjpdf.html?articlenum=pr0004.
If you provide an excerpt of your data, further help may be forthcoming.
HTH
Martin
-----Ursprüngliche Nachricht-----
Von: [email protected]
[mailto:[email protected]] Im Auftrag von Nathan Hutto
Gesendet: Montag, 25. Januar 2010 04:47
An: [email protected]
Betreff: st: Methods for linking inter-generational observations
Hi all,
I have a dataset containing birth records in a particular region over
10 years. Many of the records are siblings or half-siblings. I need to
match siblings and half-siblings using a number of identifiers. I have
a unique maternal ID number for some of the sample; for the remainder
of the sample I'll have to match on name, geocode, blood type, etc.
Having never done this before, I'm not sure if I'm on the right track
or using the most accurate/efficient approach.
Here is the command I'm using to match on the maternal id:
duplicates tag maternal_id, gen(id_match)
gen parity = id_match if id_match<=10
For other match variables, this is the commands I'm using:
egen dobmaidfirst = group( dateofbirth maidenname firstname)
duplicates tag dobmaidfirst, gen(dobmaidfirstmatch)
replace parity = dobmaidfirstmatch if dobmaidfirstmatch<=4 &
[parity==0|parity==.]
Does anyone know if this is a common approach to matching individuals
existing within the same dataset. I know there are also probabilistic
methods, which I may try later. But first I need to use this approach.
Thank you,
Nathan
--
Doctoral Student ? Columbia University School of Social Work
Fellow ? Columbia Population Research Center
*
* 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/
*
* 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/
