IDEAS home Printed from https://ideas.repec.org/c/boc/bocode/s456931.html
 

ADDINBY: Stata module to add in data from a disk dataset using a foreign key

Author

Listed:
  • Roger Newson

    (King's College London)

Programming Language

Stata

Abstract

addinby is a "cleaner" alternative version of merge, designed to reduce the lines of code in Stata do-files. It adds variables and/or values to existing observations in the dataset currently in memory (the master dataset) from a Stata-format dataset stored in the file filename (the using dataset), using a foreign key of variables specified by the keyvarlist to identify observations in the using dataset. The using dataset must be sorted by the variables in the keyvarlist, and these variables must identify observations in the using dataset uniquely. Unlike -merge-, -addinby- always preserves the master dataset in its original sorting order, and does not add any merge-status variables or additional observations. However, addinby checks that the foreign key uniquely identifies observations in the using dataset, and may optionally check that there are no unmatched observations in the master dataset, and/or check that there are no missing values in the foreign key variables in the master dataset.

Suggested Citation

  • Roger Newson, 2008. "ADDINBY: Stata module to add in data from a disk dataset using a foreign key," Statistical Software Components S456931, Boston College Department of Economics, revised 14 Apr 2020.
    • Handle: RePEc:boc:bocode:s456931
    Note: This module should be installed from within Stata by typing "ssc install addinby". The module is made available under terms of the GPL v3 (https://www.gnu.org/licenses/gpl-3.0.txt). Windows users should not attempt to download these files with a web browser.
    as

    Download full text from publisher

    File URL: http://fmwww.bc.edu/repec/bocode/a/addinby.ado
    File Function: program code
    Download Restriction: no
    File URL: http://fmwww.bc.edu/repec/bocode/a/addinby.sthlp
    File Function: help file
    Download Restriction: no
    File URL: http://fmwww.bc.edu/repec/bocode/f/fraddinby.ado
    File Function: program code
    Download Restriction: no
    File URL: http://fmwww.bc.edu/repec/bocode/f/fraddinby.sthlp
    File Function: help file
    Download Restriction: no
    ---><---

    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:boc:bocode:s456931. 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 (email available below). General contact details of provider: https://edirc.repec.org/data/debocus.html .

    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.