I've tried to use ODS and EXCEL in the Stored Process Web Application (SAS 9.4 M2). Unfortunately this code: %global _ODSDEST _ODSOPTIONS _ODSSTYLE;
*ProcessBody;
data _null_;
rc = appsrv_header('Content-type','application/vnd.ms-excel');
rc = stpsrv_header('Content-disposition','attachment; filename=test.xlsx');
run;
%let _ODSDEST=EXCEL;
%let _ODSSTYLE=Plateau;
%macro EXPORT;
%stpbegin;
proc print noobs label data=sashelp.TOURISM; run;
%stpend;
%mend;
%EXPORT; produce error: - 66 STYLE=Plateau nogtitle nogfootnote body=_WEBOUT path=APSWORK.TCAT0000
- ____ ___
- 22 22
- 202 76
- 66 ! (url="/SASStoredProcess/do?_sessionid=00000000-0000-0000-0000-000000000000&_program=replay&_entry=APSWORK.TCAT0000.") CHARSET=' '
- ERROR 22-322: Syntax error, expecting one of the following: ;, AUTHOR, BOX_SIZING, CATEGORY, CLOSE, COMMENTS, CSSSTYLE, DOM, DPI, FILE, GFOOTNOTE, GTITLE, IMAGE_DPI, KEYWORDS, NOGFOOTNOTE,
- NOGTITLE, OPTIONS, SASDATE, STATUS, STYLE, TITLE, WORK.
-
- ERROR 202-322: The option or parameter is not recognized and will be ignored.
- ERROR 76-322: Syntax error, statement will be ignored.
-
- WARNING: No output destinations active. Problem is that there's no BODY in statement ODS EXCEL. Is it possible use ODS EXCEL in Web Store Process? Any suggestions?
... View more