Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | Michael Eisenberg <meisenberg713@gmail.com> |
To | statalist@hsphsun2.harvard.edu |
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/