Hi there
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) ;
run;
quit;
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.
Cheers,
M
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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.