Hello, I don't know how is it possible to include graphics from Stored Process output to excel. I know that tagset msoffice2k might be key for this problem, but I don't know how to use it either. I think I have tried all what I know (including stream / package -option in Stored Process, content-type etc. ). I have obtained that webpage prompts me the window and asks what I want to do with my excel (open or save). After that in gives warning concerning xml-file named as xls-file. Finally there is a graph in excel and I can click and point those bars but there is a warning sign on that graph that says something like "Graph isn't available now". I would appreciate If somebody can help me with this problem. Thank you in advance for your comments and activity! I have this kind of code: ---------------------------------- %macro stylemacro(); data _null_; %if &printoutput eq HTML %then %do; %let cssstyle = minimal; %end; %if &tulostus eq XLS %then %do; %let cssstyle = minimal; %let old = %sysfunc(stpsrv_header(Content-type, application/vnd.ms-excel)); *rc = stpsrv_header('Content-type','application/vnd.ms-excel'); /* rc = stpsrv_header('Content-disposition','attachment; filename=test.xls');*/ %end; %if &printoutput eq PDF or &printoutput eq RTF %then %do; %let cssstyle = RTF; %end; run; %mend; %macro handleParms(); %let _ODSDEST= &printoutput; %if &printoutput eq XLS %then %let _ODSDEST=HTML; *%if &printoutput eq XLS %then %let _ODSDEST=TAGSETS.MSOFFICE2K; %mend; %macro chooseOutput; ods &_ODSDEST file=_WEBOUT Style=&cssstyle; *ods html file=_webout; options center nodate; %if &outputOut=table %then %do; proc tabulate data=sashelp.class ; class sex ; table sex ; run; %end; %if &outputOut=graphic %then %do; proc sort data=sashelp.class out=class; by sex age; run; proc gchart data=class; vbar3d age / group=sex discrete nozero shape=cylinder patternid=group; run; %end; %mend outputOut; %stylemacro(); %handleParms(); %stpbegin; %outputOut; %stpend;
... View more