Automate Proc GKPI

[carlzack]

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.

[DanH_sas]

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