Data visualization with SAS programming

need to anchor map with table.

Reply
Occasional Contributor
Posts: 10

need to anchor map with table.

How do I create a html anchor ? I have a map on the top and a table on the bottom. The map is a ZIP code level map which contains hospital visit rate and the table below contains the same ZIP code and the visit rate. Is there a way of anchoring the map with the content of the table and not the table? I mean when I click on a x ZIP code on map, it should anchor with x ZIP code on the table too. Also does the variable has to be same? The PROC GMAP uses numeric variables for data=option and the PROC REPORT uses character variables for data=option.

SAS Employee
Posts: 982

Re: need to anchor map with table.

Here's the simple case for html anchors ... When you're creating "ods html" output, you can insert an html anchor before any proc by using a line of code like this right before the proc you want to have the anchor to:

 

ods html anchor="witch";

Then you can go to the anchors using urls like:

 

http://robslink.com/SAS/democd82/halloween_polygons.htm#witch

http://robslink.com/SAS/democd82/halloween_polygons.htm#cat

 

 

I'm not 100% sure about your question, but it sounds like you want to click zip codes in your map, and have it drill/scroll to that specific row in a table(?) That's a little trickier, and you have to embed the html anchor tags as invisible/non-printing code in the table. Here's an example I have, which does that sort of thing...

 

In this map, if you click on a county that has blue dots, then you will drill/scroll to the beginning of that county's data in the table below (via an html anchor). Be sure to click on the county, not the blue dots (the blue dots have a different drilldown).

 

http://robslink.com/SAS/democd80/nc_business_incentives_map.htm

 

For example, if you click on 'Raldolph' county, it will go to the following url+anchor (which should put you on the first line of Raldolph county's data in the table)...

 

http://robslink.com/SAS/democd80/nc_business_incentives_map.htm#Randolph

 

 

Here's the full SAS code used to create the above example:

http://robslink.com/SAS/democd80/nc_business_incentives_map.sas

 

 

 

Ask a Question
Discussion stats
  • 1 reply
  • 335 views
  • 0 likes
  • 2 in conversation