topic Re: Old MSA names? in SAS Programming

Old MSA names?

tbellmer3 — Sat, 28 Aug 2021 15:02:19 GMT

There is a column named MSA in the sashelp.zipcode data set. MSA has apparently been replaced by CBSA. What I need is to translate MSA such as 3760 to a city such as Kansas City.

Can someone point me to say a CSV file that contains the MSA code and associated city name or even a MSA to CBSA file?

Re: Old MSA names?

ballardw — Sat, 28 Aug 2021 16:45:21 GMT

Search the Census.gov website. Somewhere it will have the documentation, and possibly by different years. I can't point to a specific link because 1) the census reorganizes their website constantly and saved links often don't work and 2) the last time I looked at this was over 10 years ago so things would have moved.

Re: Old MSA names?

tbellmer3 — Mon, 30 Aug 2021 15:32:20 GMT

I contacted SAS support and got this reply: MSAs were retired by Census Bureau in 2003. MSA data was from zipcodedownload.com. MSAs are replaced by Core Based Statistical Area (CBSA). There are no plans to add CBSA to SASHELP.ZIPCODE. Check with Census bureau to see if they have a table.

I did search the census site and no luck so sent them an email requesting assistance.