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

Innovate_SAS_Blue.png

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. 

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.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

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

View all other training opportunities.

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