06-07-2017 05:35 AM
I work in SAS EG 7.13 with SAS version 9.4, on Linux.
My problem is that I do not get results from PROC GKPI in Excel.
This is the code that I use to test:
ods excel file="/data/sasnormal/modelling/Analyses/2017/Excel staff/test gkpi.xlsx";
goptions reset=all device=javaimg ;
proc gkpi ;
dial actual=.46 bounds=(0 .23 .46 .65 .79 1) /
target=.9 nolowbound format="percent8.0"
afont=(f="Albany AMT" height=.5cm)
bfont=(f="Albany AMT" height=.4cm) ;
ods excel close;
I tried different devices (png, gif) but it does not work.
I can see the result in the Results - SAS Report, but my Excel shows an empty sheet.
PROC tabulate does show results, as well as SGPLOT, it is only GKPI that gives problems.
06-07-2017 05:56 AM
Not heard of this procedure, however looking at the examples in the SAS document, this procedure produces HTML output (i.e. it contains sliders and such like), this is not an embedable format for Excel - i.e. text/numbers/pictures.
I would imagine, if you want the same sort of thing in Excel, you would need to build it in Excel using Excel functionality, and then dump your data out to that and let Excel do it.
06-07-2017 06:08 AM