topic Re: Create drill down on a KPI via Proc GKPI in SAS Procedures

Create drill down on a KPI via Proc GKPI

ANLYNG — Mon, 07 Mar 2016 18:49:14 GMT

Hi,

I am trying to create a simple drill-down (to another report) but I can not get it to work. Do you have any ideas how to create it? thanks in advance.

proc gkpi mode=raised;

trafficlight actual=&maal100. bounds=(100 97 85 0) /colors=(green yellow red) noavalue
lfont=(h=16pt) bfont=(h=16pt) afont=(h=20pt) label="100% XXXXX" ;

run;

Re: Create drill down on a KPI via Proc GKPI

ballardw — Mon, 07 Mar 2016 21:37:40 GMT

Which version of SAS are you running?

In 9.4 this may help: http://support.sas.com/documentation/cdl/en/graphref/67881/HTML/default/viewer.htm#n002em2j8o13vin1la8z49qcxi5a.htm

Basically add a Link="url" to the options.

Re: Create drill down on a KPI via Proc GKPI

ANLYNG — Wed, 09 Mar 2016 06:48:07 GMT

Great advice- thanks. I did the job perfectly.

Re: Create drill down on a KPI via Proc GKPI

ANLYNG — Wed, 09 Mar 2016 17:15:35 GMT

By the way - do you know if it is possible to put an option to the link which force to open the link in a new window something as target=_blank??? but this syntaks is not valid in this proc??? thanks.