msacrosswalk is a simple Stata crosswalk program for adding 2013, 2015, or 2017 vintage CBSA/CSA codes, CBSA/CSA names, metropolitan/micropolitan, and central/outlying indicators that may be missing from your dataset.
msacrosswalk is compatible with Stata version 12.1+. It may be compatible with previous versions, but it has not been tested in those environments.
Github (for Stata v13.1+): Run the following via the Stata command line.
net install msacrosswalk, from(https://raw.github.com/cbgoodman/msacrosswalk/master/) replace
Github (for Stata v12.1+): Download the zipped file of this repository. Unzip on your local computer. Run the following code via the Stata command line replacing with the location of the unzipped repository on your computer.
net install msacrosswalk, from(<local source>) replace
msacrosswalk offers three methods of merging using either five-digit county FIPS codes, the combination of two-digit state FIPS and three-digit county FIPS codes, or the combination of two-digit state Census codes and three-digit county Census codes. Vintage must be specified and determines which delineation file to be used. See here for more information.
. msacrosswalk, fips(county) vintage(year)
. msacrosswalk, statefips(stfips) countyfips(cofips) vintage(year)
. msacrosswalk, statecode(stcode) countycode(cocode) vintage(year)
msacrosswalk will generate a new variable,
_merge, to indicate the merged results. If you do not want to create this variable, specify
This will keep matched observations and unmatched master observations.
. msacrosswalk, fips(county) vintage(year) nogenerate
- FIPS codes are available for U.S counties, county equivalents, and territories. Census codes are only available for counties or county equivalents (such as independent cities).
msacrosswalkuses the more recent FIPS code for Miami-Dade county (12086) rather than the FIPS code for Dade county (12025). The Census state (10) and county (13) codes remain unchanged.
- Add historical delineation files
Please report any bugs here.