Bookmark and Share

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]

st: merging datasets


From   Michael Eisenberg <[email protected]>
To   [email protected]
Subject   st: merging datasets
Date   Mon, 8 Nov 2010 22:50:17 -0600

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/


© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index