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
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
References: Add references at CitEc
Citations Track citations by RSS feed
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)
This item may be available elsewhere in EconPapers: Search for items with the same title.
Export reference: BibTeX
RIS (EndNote, ProCite, RefMan)
Persistent link: https://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 ().