Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: merging datasets
From
Neil Shephard <[email protected]>
To
[email protected]
Subject
Re: st: merging datasets
Date
Tue, 9 Nov 2010 07:34:03 +0000
On Tue, Nov 9, 2010 at 4:50 AM, Michael Eisenberg
<[email protected]> wrote:
> Colleagues,
>
> I have a database of about 20K men that I'd like to merge with another
> database. I have names (first, middle, and last) as well as date of
> birth and social security number for most men. Unfortunately, the
> original database has some missing data on birthdate and social
> security numbers. The new database has most of the birthdate info as
> well as the geographic information that I need.
>
> Some men do have the same name.
>
> Is there anyway to merge based on name if it doesn't uniquely identify
> men?
You could investigate the utility of -nearmrg- by Michael Blasnik &
Katherine Smith available from the SSC archives..
ssc describe nearmrg
ssc install nearmrg
To read about it and then install it.
Neil
--
"Our civilization would be pitifully immature without the intellectual
revolution led by Darwin" - Motoo Kimura, The Neutral Theory of
Molecular Evolution
Email - [email protected]
Website - http://kimura-no-ip.org/
Photos - http://www.flickr.com/photos/slackline/
*
* 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/