I am trying to create a drill down and a tip to display with a stored process and proc gplot , in particular. The thing is, the drill down should output differently depending on the which bar selected.
I was using the samples but I got lost when it was using a macro.
2) next, you make a copy of your data which will contain a NEW variable to hold the correct drilldown URL (using hardcoded web sites). This is generally a DATA step program where you create a variable to be used in your SAS/GRAPH program. Your assignment statement would look something like this:
if region = 'Asia' then do;
Note that the variable shown above is DRILL, but it could have been named FRED or WOMBAT or MYHTML.
3) Now, you use the variable created in #2, in an HTML= option in your SAS/GRAPH procedure
proc gwhatever data=mydata;
action statement /
HTML=DRILL or HTML=FRED or HTML=WOMBAT or HTML=MYHTML
4) You may or may not need to create the files that will be drilled down to. For example, if your drilldown was to Asia.HTML, you'd need to create that file. But, if you were going to a hardcoded web site or you were going to dynamically execute a program when they clicked, then you would not need step 4.
The key is using the HTML= syntax, which tells SAS/GRAPH which dataset variable contains the drill-down information. In the links below, you will find some non-Stored Process examples that do not use macro variables or macro programs.
The place where folks use macro variables and macro programs in this process is when they need to generate differing URLs or use differing formats or execute differing programs based on some criteria in the data.