Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at

[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.


"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 -
Photos -
*   For searches and help try:

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