BookmarkSubscribeRSS Feed
Lightning
Calcite | Level 5

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

 

 

2 REPLIES 2
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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.

Lightning
Calcite | Level 5
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.

sas-innovate-2024.png

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.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 636 views
  • 0 likes
  • 2 in conversation