BookmarkSubscribeRSS Feed
SASDatesKillMe
Obsidian | Level 7

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!

3 REPLIES 3
WarrenKuhfeld
Ammonite | Level 13

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

 

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

ballardw
Super User

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.

 

 

Reeza
Super User

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!


 

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 1527 views
  • 0 likes
  • 4 in conversation