Perfect! ... View more

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       ... View more

Since you don't appear to be requesting a statistic from the value I would try setting the missing to a value way outside your other data (-1e8 or similar) and include that value in your format. With out seeing a map its hard to tell but I think your comment "missing values color changes to other colors" indicates that missing may be treated differently that an actual value. ... View more