SAS/GRAPH Dashboard Samples

Data Tips and Drill-Down Functionality in the SAS/GRAPH Dashboard Samples

The SAS/GRAPH dashboard samples implement data tips and drill-down functionality by doing the following:

Defining a variable that contains the data tips and a URL. This variable defines a string that assigns the data tips to the HTML title tag and the URL to the HTML href tag. Its value is assigned with a statement similar to the following:
```
    html='title='||quote(data_tips)||' '||'href="'||"URL"||'"';
```
Including this variable in the SAS data set that is used in the SAS/GRAPH procedure and specifying it with the HTML= option on the action statement of the SAS/GRAPH procedure.

OR

Including this variable in the Annotate data set and naming the variable HTML. When a variable that defines URLs is included in an Annotate data set, it must be named HTML.

The default URL is specified in the hardcoded_drilldown macro variable as follows:

    %let hardcoded_drilldown=http://support.sas.com/rnd/datavisualization/dashboards/generic_drilldown.htm;

You can modify the URL in this macro variable to drill down to any page. Usually, you will want to build a URL that links to detailed graphs or reports generated by your SAS application. For more information, see the following sources:

Adding Data Tips with the HTML= Option in the SAS/GRAPH Reference
Adding Links with the HTML= and HTML_LEGEND= Options in the SAS/GRAPH Reference
FAQ #3038, which uses PROC GMAP to create a map with data tips and drill-down functionality
FAQ #3067, which uses PROC GCHART to create a bar chart with data tips and drill-down functionality

You can also drill down to a stored process. For information about stored processes, see SAS Integration Technologies: Developer's Guide. For specific information on defining the URL for a stored process, see Web Application Input.