COMBINEALL: Stata module to combine (append, merge, or joinby) or convert every file in a directory
Eric Booth and
Elizabeth Teas ()
Additional contact information
Elizabeth Teas: Far Harbor, LLC
Statistical Software Components from Boston College Department of Economics
Abstract:
combineall sweeps a directory and combines every file of one type (.dta, CSV and other delimited text, Excel, or XML) into a single dataset by append, merge, or joinby, or converts the files to .dta and stops (convertonly). The engine dates to 2011 (v1.0.0). v2.0.0 adds a harmonization layer under cmethod(append) for stacking yearly file releases whose element names mutate across vintages: map(renames.csv) applies only the renames whose [firstyear,lastyear] window covers the 4-digit year extracted from each filename, generates int year, records provenance in char varname[source], and prints a variable-by-year harmonization table. strict turns absent-oldname reports into errors. Replaces the panelstack package. combineall using "built/panel", cmethod(append) map(renames.csv)
Language: Stata
Requires: Stata version 16
Keywords: append; merge; joinby; import; convert; panel; harmonize; rename; vintage (search for similar items in EconPapers)
Date: 2026-07-30
Note: This module should be installed from within Stata by typing "ssc install combineall". The module is made available under terms of the MIT license (https://opensource.org/licenses/MIT).
References: Add references at CitEc
Citations:
Downloads: (external link)
http://fmwww.bc.edu/repec/bocode/c/combineall.ado program code (text/plain)
http://fmwww.bc.edu/repec/bocode/c/combineall.sthlp 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: https://EconPapers.repec.org/RePEc:boc:bocode:s459843
Ordering information: This software item can be ordered from
http://repec.org/docs/ssc.php
Access Statistics for this software item
More software in Statistical Software Components from Boston College Department of Economics Boston College, 140 Commonwealth Avenue, Chestnut Hill MA 02467 USA. Contact information at EDIRC.
Bibliographic data for series maintained by Christopher F Baum ().