IDEAS home Printed from https://ideas.repec.org/a/tsj/stataj/v15y2015i3p672-697.html
   My bibliography  Save this article

Record linkage using Stata: Preprocessing, linking, and reviewing utilities

Author

Listed:
  • Nada Wasi

    (Institute for Social Research, University of Michigan)

  • Aaron Flaaen

    (Division of Research and Statistics, Federal Reserve Board of Governors)

Abstract

In this article, we describe Stata utilities that facilitate probabilistic record linkage—the technique typically used for merging two datasets with no common record identifier. While the preprocessing tools are developed specifically for linking two company databases, the other tools can be used for many different types of linkage. Specifically, the stnd compname and stnd address commands parse and standardize company names and addresses to improve the match quality when linking. The reclink2 command is a generalized version of Blasnik’s reclink (2010, Statistical Software Components S456876, Department of Economics, Boston College) that allows for many-to-one matching. Finally, clrevmatch is an interactive tool that allows the user to review matched results in an efficient and seamless manner. Rather than exporting results to another file format (for example, Excel), inputting clerical reviews, and importing back into Stata, one can use the clrevmatch tool to conduct all of these steps within Stata. This helps improve the speed and flexibility of matching, which often involves multiple runs. Copyright 2015 by StataCorp LP.

Suggested Citation

  • Nada Wasi & Aaron Flaaen, 2015. "Record linkage using Stata: Preprocessing, linking, and reviewing utilities," Stata Journal, StataCorp LP, vol. 15(3), pages 672-697, September.
    • Handle: RePEc:tsj:stataj:v:15:y:2015:i:3:p:672-697
    Note: to access software from within Stata, net describe http://www.stata-journal.com/software/sj15-3/dm0082/
    as

    Download full text from publisher

    File URL: http://www.stata-journal.com/article.html?article=dm0082
    File Function: link to article purchase
    Download Restriction: no
    ---><---

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Xu, Dafeng, 2020. "The effects of immigration restriction laws on immigrant segregation in the early twentieth century U.S," Journal of Comparative Economics, Elsevier, vol. 48(2), pages 422-447.
    2. Parag Mahajan, 2021. "Immigration and Local Business Dynamics: Evidence from U.S. Firms," Working Papers 21-18, Center for Economic Studies, U.S. Census Bureau.
    3. Mihaela Tofan & Mihaela Onofrei & Anca-Florentina Vatamanu, 2020. "Fiscal Responsibility Legal Framework—New Paradigm for Fiscal Discipline in the EU," Risks, MDPI, vol. 8(3), pages 1-18, July.
    4. Emmanuel Chavez, 2020. "The Effects of Public R&D Subsidies on Private R&D Activities in Mexico," PSE Working Papers halshs-02355106, HAL.
    5. Becker, Sascha O. & Francisco J. Pino & Vidal-Robert, Jordi, 2021. "Freedom of the Press? Catholic Censorship during the Counter-Reformation," The Warwick Economics Research Paper Series (TWERPS) 1356, University of Warwick, Department of Economics.
    6. Joseph Raffiee & Daniel Fehder & Florenta Teodoridis, 2022. "Revealing the revealed preferences of public firm CEOs and top executives: A new database from credit card spending," Strategic Management Journal, Wiley Blackwell, vol. 43(10), pages 2042-2065, October.
    7. Philip S. Brenner, 2021. "Effects of Nonresponse, Measurement, and Coverage Bias in Survey Estimates of Voting," Social Science Quarterly, Southwestern Social Science Association, vol. 102(2), pages 939-954, March.
    8. Amuedo-Dorantes, Catalina & Arenas-Arroyo, Esther & Mahajan, Parag & Schmidpeter, Bernhard, 2023. "Low-Wage Jobs, Foreign-Born Workers, and Firm Performance," IZA Discussion Papers 16438, Institute of Labor Economics (IZA).
    9. Emmanuel Chavez, 2020. "The Effects of R&D Tax Credits and Subsidies onPrivate R&D in Mexico (Chapter 2)," Working Papers halshs-02652063, HAL.
    10. Daniel Lois & Oliver Arránz Becker, 2023. "Parental status homogeneity in social networks: The role of homophilous tie selection in Germany," Demographic Research, Max Planck Institute for Demographic Research, Rostock, Germany, vol. 48(2), pages 19-42.
    11. Thor, Andreas & Marx, Werner & Leydesdorff, Loet & Bornmann, Lutz, 2016. "Introducing CitedReferencesExplorer (CRExplorer): A program for reference publication year spectroscopy with cited references standardization," Journal of Informetrics, Elsevier, vol. 10(2), pages 503-515.
    12. Fariha Kamal & Ryan Monarch, 2018. "Identifying foreign suppliers in U.S. import data," Review of International Economics, Wiley Blackwell, vol. 26(1), pages 117-139, February.
    13. Rhys Bidder & John Krainer & Adam Shapiro, 2021. "De-leveraging or de-risking? How banks cope with loss," Review of Economic Dynamics, Elsevier for the Society for Economic Dynamics, vol. 39, pages 100-127, January.
    14. Bryan A. Stuart, 2022. "The Long-Run Effects of Recessions on Education and Income," American Economic Journal: Applied Economics, American Economic Association, vol. 14(1), pages 42-74, January.
    15. Ghaly, Mohamed & Kostakis, Alexandros & Stathopoulos, Konstantinos, 2021. "The (non-) effect of labor unionization on firm risk: Evidence from the options market," Journal of Corporate Finance, Elsevier, vol. 66(C).
    16. Daniel H. Weinberg & John M. Abowd & Robert F. Belli & Noel Cressie & David C. Folch & Scott H. Holan & Margaret C. Levenstein & Kristen M. Olson & Jerome P. Reiter & Matthew D. Shapiro & Jolene Smyth, 2017. "Effects of a Government-Academic Partnership: Has the NSF-Census Bureau Research Network Helped Improve the U.S. Statistical System?," Working Papers 17-59r, Center for Economic Studies, U.S. Census Bureau.
    17. Hassan Afrouzi & Andres Drenik & Ryan Kim, 2020. "Growing by the Masses - Revisiting the Link between Firm Size and Market Power," CESifo Working Paper Series 8633, CESifo.
    18. Matthew Knepper, 2020. "From the Fringe to the Fore: Labor Unions and Employee Compensation," The Review of Economics and Statistics, MIT Press, vol. 102(1), pages 98-112, March.
    19. Cassidy, Michael T., 2020. "Short Moves and Long Stays: Homeless Family Responses to Exogenous Shelter Assignments in New York City," IZA Discussion Papers 13559, Institute of Labor Economics (IZA).
    20. Glennon, Britta & Lane, Julia & Sodhi, Ridhima, 2018. "Money for Something: The Links between Research Funding and Innovation," IZA Discussion Papers 11711, Institute of Labor Economics (IZA).
    21. Jaeho Kim & Andy Wu, 2019. "Extending the role of headquarters beyond the firm boundary: entrepreneurial alliance innovation," Journal of Organization Design, Springer;Organizational Design Community, vol. 8(1), pages 1-35, December.
    22. Wenhua Di & Nathaniel Pattison, 2020. "Distant Lending, Specialization, and Access to Credit," Working Papers 2003, Federal Reserve Bank of Dallas.
    23. Alica Daly & Giulia Valacchi & Julio Raffo, 2019. "Measuring Innovation in the Mining Industry with Patents," WIPO Economic Research Working Papers 56, World Intellectual Property Organization - Economics and Statistics Division.
    24. Gianluca Orsatti & Valerio Sterzi, 2018. "Do Patent Assertion Entities Harm Innovation? Evidence from Patent Transfers in Europe," Cahiers du GREThA (2007-2019) 2018-08, Groupe de Recherche en Economie Théorique et Appliquée (GREThA).
    25. Michael J. Andrews, 2023. "How Do Institutions of Higher Education Affect Local Invention? Evidence from the Establishment of US Colleges," American Economic Journal: Economic Policy, American Economic Association, vol. 15(2), pages 1-41, May.

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:tsj:stataj:v:15:y:2015:i:3:p:672-697. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    We have no bibliographic references for this item. You can help adding them by using this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Christopher F. Baum or Lisa Gilmore (email available below). General contact details of provider: http://www.stata-journal.com/ .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.