Hi,
Does anyone know how to put a graph into an Excel-file created with a stored process? For instance a KPI-speedometer:
*ProcessBody;
data _null_;
rc = stpsrv_header('Content-type',"application/vnd.ms-excel");
rc = stpsrv_header('Content-disposition',"attachment; filename=ex1.xls");
run;
%let _odsdest = tagsets.msoffice2k;
%let _odsstyle = sasweb;
%stpbegin;
%LET bol_webout="%sysfunc(pathname(work))\bol.html" BASE="%sysfunc(pathname(work))";
PROC SQL NOPRINT;
SELECT '_webout'
INTO :bol_webout
FROM dictionary.extfiles
WHERE Upcase(fileref) EQ '_WEBOUT';
QUIT;
ODS HTML FILE=&bol_webout STYLE=bol_style;
proc gkpi mode=raised;
goptions vsize= 2.50 in hsize= 2.50 in CBACK=white;
speedometer actual=&mac_actual_1 bounds=(-100 -25 50 100) /
lfont=( h= 20 PT c= cx005aa1)
colors=(cxD06959 cxF1DC63 cx84AF5B )
bfont=( c= cx005aa1)
afont=( h= 30 PT c= cx005aa1);
RUN;QUIT;
%stpend;
... View more