This file is part of IDEAS, which uses RePEc data


[ Papers | Articles | Software | Books | Chapters | Authors | Institutions | JEL Classification | NEP reports | Search | New papers by email | Author registration | Rankings | Volunteers | FAQ | Blog | Help! ]

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

Author info | Abstract | Publisher info | Download info | Related research | Statistics
Author Info
Roger Newson () (National Heart and Lung Institute at Imperial College London)

Additional information is available for the following registered author(s):

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.

Download Info
To download:

If you experience problems downloading a file, check if you have the proper application to view it first. Information about this may be contained in the File-Format links below. In case of further problems read the IDEAS help file. Note that these files are not on the IDEAS site. Please be patient as the files may be large.

File URL: http://fmwww.bc.edu/repec/bocode/a/addinby.ado
File Format: text/plain
File Function: program code
Download Restriction: no
File URL: http://fmwww.bc.edu/repec/bocode/a/addinby.sthlp
File Format: text/plain
File Function: help file
Download Restriction: no

Publisher Info
Software component provided by Boston College Department of Economics in its series Statistical Software Components with number S456931.

Download reference. The following formats are available: HTML, plain text, BibTeX, RIS (EndNote), ReDIF
Size:
Programming language: Stata
Requires: Stata version 10.0
Date of creation: 15 Apr 2008
Date of revision: 06 May 2008
Handle: RePEc:boc:bocode:s456931

Note: This module may be installed from within Stata by typing "ssc install addinby". Windows users should not attempt to download these files with a web browser.
Contact details of provider:
Postal: Boston College, 140 Commonwealth Avenue, Chestnut Hill MA 02467 USA
Phone: 617-552-3670
Fax: +1-617-552-2308
Email:
Web page: http://fmwww.bc.edu/EC/
More information through EDIRC

Order Information:
Web: http://repec.org/docs/ssc.php

For technical questions regarding this item, or to correct its listing, contact: (Christopher F Baum).

Related research
Keywords: data manipulation key foreign key merge

Statistics
Access and download statistics

Did you know? All top Economics journals are listed on RePEc.

This page was last updated on 2008-7-24.


This information is provided to you by IDEAS at the Department of Economics, College of Liberal Arts and Sciences, University of Connecticut using RePEc data on a server sponsored by the Society for Economic Dynamics.