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
Michael Blasnik <[email protected]>
To
[email protected]
Subject
Re: st: merging datasets
Date
Tue, 9 Nov 2010 17:29:41 -0500
Rather than -nearmrg-, I think you'd be better off using joinby and
then using a set of logical conditions to identify the "good" matches.
It may be tricky if you have people with the same names and missing
data on the auxiliary variables.
Michael
On Mon, Nov 8, 2010 at 11:50 PM, 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? I'd like to somehow match all men and then let me manually
> compare based on visit dates to decide if it's likely the match is
> correct. If not, any suggestions?
>
> Thanks for you help.
>
> Mike
> *
> * 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/