BookmarkSubscribeRSS Feed
FredGIII
Quartz | Level 8

Hi everyone,

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.

Regards,

Fred

2 REPLIES 2
GraphGuy
Meteorite | Level 14

What you're looking for is the trick used in Example 10 of the (now out-of-print) book "SAS/Graph Examples".

http://robslink.com/SAS/democd44/ex_10.htm  <- output

http://robslink.com/SAS/democd44/ex_10_info.htm  <- code

ex_10.png

Rick_SAS
SAS Super FREQ

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.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 926 views
  • 0 likes
  • 3 in conversation