Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: RE: Question about match merge on name

From   "Steven Stillman (LMPG)" <>
To   "''" <>
Subject   st: RE: Question about match merge on name
Date   Fri, 29 Aug 2003 12:36:40 +1200

Statistics New Zealand uses a commercial product call Integrity made by
Ascential software to match administrative databases with similar issues.
More information is available at  I have no idea if this
approach is practical for smaller scale merges or if the product itself is
any good.


> -----Original Message-----
> From:	Scott Talkington []
> Sent:	Wednesday, August 20, 2003 9:26 AM
> 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
> *
> *   For searches and help try:
> *
> *
> *

The information contained in this document is intended only for the
 addressee and is not necessarily the views nor the official 
communication of the Department of Labour.  All final/official papers 
which are sent from the Department will be sent by non-electronic
means, on appropriate letterhead, signed by authorised personnel.
*   For searches and help try:

© Copyright 1996–2017 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index