I am trying to create a block or riser map that shows the total cost of each site shown by location. The riser block height is determined by the cost and it's location on the map should be determined by the Lat/Long. I have the Lat/Long data, cost and site id... I tried using MAPS.USCITY since it appears to have both LAT LONG and X Y (projected Lat/Long in radians). My dataset has both Lat/long and I calculated X Y in radians as well. But when I assign USCITY for the Map Data source and my table for Response data source, the only ID Variable(s) Role that shows up are the STATECODE and LAT/LONG.
At first I thought that would be ok, because it would just use the lat/long, but all I ended up with is a blank result report - no map - nothing! I have read a number of documents concerning the mapping but haven't seen anything that indicates that this is possible. I find that hard to believe, so i must be missing something.
Any pointers to the appropriate documentation would be appreciated.
If you have a hundred or more sites, the graph might be more readable if you use circles (like a bubble plot) instead of 3-D blocks. You could make the area of each circle proportional to the quantity.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.