Record Linkage in Stata

Michael Blasnik ()
Additional contact information
Michael Blasnik: M. Blasnik & Associates

North American Stata Users' Group Meetings 2007 from Stata Users Group

Abstract: Record linkage involves attempting match records from two different data files that do not share a unique and reliable key field. It can be a tedious and challenging task when working with multiple administrative databases where one wants to match subjects using names, addresses and other identifiers that may have spelling and formatting variations. Formal record linkage methods often employ a combination of approximate string comparators and probabilistic matching algorithms to identify the best matches and assess their reliability. Some stand-alone software is available for this task. This presentation will introduce -reclink-, a rudimentary probabilistic record matching program for Stata. -reclink- employs a modified bigram string comparator and allows user-specified match and non-match weights. The algorithm also provides for blocking (both "or" and "and") to help improve speed for this otherwise slow procedure.

New Economics Papers: this item is included in nep-cmp
Date: 2007-08-15, Revised 2007-09-25

Downloads: (external link)
http://repec.org/nasug2007/RecordLinkageinStata.ppt presentation slides (application/x-mspowerpoint)
http://repec.org/nasug2007/RecordLinkageinStata.pdf presentation slides (application/pdf)
http://repec.org/nasug2007/reclink.ado program code (text/plain)
http://repec.org/nasug2007/reclink.hlp help file (text/plain)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: http://EconPapers.repec.org/RePEc:boc:asug07:5

Access Statistics for this paper

More papers in North American Stata Users' Group Meetings 2007 from Stata Users Group
Contact information at EDIRC.
Series data maintained by Christopher F Baum ().