topic Re: Help getting a list of cities and zip codes in New SAS User

Help getting a list of cities and zip codes

SASDatesKillMe — Wed, 16 Oct 2019 20:19:16 GMT

I have a list of individuals and their cities. I'd like to create a heat map showing the density of individuals in the USA using Tableau. Except Tableau can't include places on the map for which I have missing data. For example, if there aren't any individuals in Chicago, IL it'd show that area as missing.

My request is for help in generating in SAS a list of all the cities in the USA. I'd be grateful if I could also have the zip code at the center of each city (in case we do the heat map using zip codes instead of cities). Thanks!

Re: Help getting a list of cities and zip codes

WarrenKuhfeld — Wed, 16 Oct 2019 20:43:53 GMT

https://support.sas.com/documentation/tools/sashelpug.pdf

You might find the sashelp data set on zip codes to be helpful.

Re: Help getting a list of cities and zip codes

ballardw — Wed, 16 Oct 2019 20:46:32 GMT

You may have a data set name SASHELP.ZIPCODE in your install.

Unfortunately I don't think there is any way to determine which Zip code may be at the "center" of a city.

Zip code boundary files are pretty flaky for most of western states in areas with low population density so I suspect you won't actually use a by Zip code head map. A more likely approach would be by COUNTY, which you can get from Zip code values.

Some Zip codes do represent single buildings or in the case of sufficient mail traffic may only represent part of a building.

If not you can navigate to http://support.sas.com/rnd/datavisualization/mapsonline/html/misc.html and download the latest version.

Re: Help getting a list of cities and zip codes

Reeza — Wed, 16 Oct 2019 21:32:17 GMT

Tableau includes the US census data available for free in it's edition. You could use that data if you're just trying to show population directly.

Assuming you have a custom list of individuals, how would having the zip code help here?

@SASDatesKillMe wrote:

I have a list of individuals and their cities. I'd like to create a heat map showing the density of individuals in the USA using Tableau. Except Tableau can't include places on the map for which I have missing data. For example, if there aren't any individuals in Chicago, IL it'd show that area as missing.

My request is for help in generating in SAS a list of all the cities in the USA. I'd be grateful if I could also have the zip code at the center of each city (in case we do the heat map using zip codes instead of cities). Thanks!