http://www.uni-konstanz.de/FuF/Verwiss/Schnell/recordli.html It is in alpha status and the code has not been released to the public yet. Does anyone know of any other packages? Best wishes. Daniel R. Sabath ____________________________________________ Daniel R. Sabath M.Sc. Research Consultant Dept. of Surgery 325 Ninth Ave Harborview Injury Prevention Box 359960 and Research Center Seattle, WA 98104 sabathd@u.washington.edu (206) 521-1549 -----Original Message----- From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Scott Talkington Sent: Tuesday, August 19, 2003 1:26 PM To: Statalist Subject: st: Question about match merge on name I wonder if anyone on the list has advice about matching two databases on first, last and middle name and birth date (as well as gender and race). The size of the two files is around 400,000 observations (although they aren't matched 1 to 1) so correction of misspellings, transpositions, etc. by inspection is sort of ruled out. I have done some editing by searching for breaks or spaces in the name field that might be name extensions like "JR." etc, and have also transformed the name fields in both files to upper case. I then did a match on the 3 initials plus birth date, and have identified the subset of matches where at least the last name and birth date are identical. However, I suspect there are quite a few more matches to be gleaned. Are there utilities that can facilitate this process? Any tricks and tips? -Scott talkings@gmu.edu * * For searches and help try: * http://www.stata.com/support/faqs/res/findit.html * http://www.stata.com/support/statalist/faq * http://www.ats.ucla.edu/stat/stata/ * * For searches and help try: * http://www.stata.com/support/faqs/res/findit.html * http://www.stata.com/support/statalist/faq * http://www.ats.ucla.edu/stat/stata/