topic Re: GKPI in Excel in ODS and Base Reporting

GKPI in Excel

Lightning — Wed, 07 Jun 2017 09:35:33 GMT

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,

Re: GKPI in Excel

RW9 — Wed, 07 Jun 2017 09:56:53 GMT

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.

Re: GKPI in Excel

Lightning — Wed, 07 Jun 2017 10:08:28 GMT

Thanks RW9.

GKPI does produce a png file (at least with ods html used). This works:
ods html
path="/wgd/Modelling/Analyses/2017/Excel staff/" (URL=none)
file="test gkpi temp.html"

options(graph_width="300" graph_height="300"
panelcols="4" panel_space="0")
style=listing;
proc gkpi mode=raised;
dial actual=.70 bounds=(0 .25 .46 .65 .80 1) / target=.9 nolowbound
format="percent." label="North Sales";
run;
quit;

ods html close;

But, I want it in Excel as I am creating an Excel report.

##- Please type your reply above this line. Simple formatting, no
attachments. -##

This message has been sent by ABN AMRO Bank N.V., which has its seat at Gustav Mahlerlaan 10 (1082 PP) Amsterdam, the Netherlands, and is registered in the Commercial Register of Amsterdam under number 34334259.