Click here to see the SAS code.
Click here to see the example.

---------------------------------------------------------------

The drilldown in this example is *not* done in the traditional sas way,
and this technique only works with the dev=activex and dev=java 
SAS graphs that are rendered on the "client side" (ie, drawn on the 
fly, in the user's web browser).

Basically, you specify in the ODS statement which variables to plug
into the 'drilldown pattern'.  These variables *must* be variables
that are used in the actual graph (in plots & charts, that's basically
category, response, and group variables - in maps that's id and 
response variables).  This is somewhat limiting ... for example, if
you have numeric state fips code as the id of your census population
map, then you can use the numeric fips code (for example 37 is 
north carolina's numeric fips code) in the drilldown pattern
but you can't use the state abbreviation 'NC'.

Another limitation is that you don't have control over the upper/lower-
casing of text variables.  For example, in this case since my data 
values are upper-case state abbreviations, the drilldown pattern
url that gets generated is something like http://www.state.NC.us,
but luckily these pages are on a "lenient" web server that 
conveniently allows upper- or lower-case (not all web pages will
be this luckily lenient!)

And, one final limitation is that you don't get charttip text
using this type of drilldown.

Here is the syntax of the ODS drillpattern used in this example.
(In this bar chart, the variable 'ST' contains the 2-character
state abbreviation - so for 'nc', the url will be ...
http://www.state.nc.us )

   ODS HTML path=odsout body="&name..htm"
    parameters=(
     "DRILLDOWNMODE"="HTML"
     "DRILLPATTERN"='http://www.state.{&st}.us'
     )
    ;

Back to Samples Index