Data visualization with SAS programming

Automate Proc GKPI

Reply
N/A
Posts: 1

Automate Proc GKPI

Is there any way to automate populating the actual value in proc gkpi code. For example:

proc gkpi mode=raised;
speedometer actual=74 bounds=(0 69 73 100) /
colors=(red yellow green)
label="LDL Control";
run;

Instead of having to manually enter the actual value of 74, I would automatically like to populate this value which could be read in from a SAS dataset.
SAS Super FREQ
Posts: 888

Re: Automate Proc GKPI

This proc does not currently take datasets; however you can use some dataset/macro techniques to get your data from a data set to N number of KPI's. It involves pushing your data set values into a macro array from the data step, then using a macro loop across the array to set individual values on the proc. I would also recommend using the HTMLPANEL tagset to simplify your dashboard creation.

Hope this helps,
Dan
Ask a Question
Discussion stats
  • 1 reply
  • 136 views
  • 0 likes
  • 2 in conversation