I understand that ODS EXCEL is still "experimental", but does it work at all on z/OS (mainframe)? When I try to use it, I get an "Invalid physical name" upon executing ODS EXCEL close. This happens when the destination file is either specified as a unix system services file, or an old fashioned data set allocated as either RECFM=U or RECFM=VB. I do not get such a message when trying to do something similar when using PC SAS 9.4 TS1M1, and am able to use it to produce an .xlsx file with the contents of SASHELP.CLASS. 1 filename te1 '/tmp/tstx1.xlsx';
2 ods excel file=te1;
3 proc print data=sashelp.class;
4 run;
NOTE: There were 19 observations read from the data set SASHELP.CLASS.
NOTE: The PROCEDURE PRINT used 0.09 CPU seconds.
5 ods excel close;
NOTE: Writing EXCEL file: /tmp/tstx1.xlsx
ERROR: Invalid physical name. 6 filename te1 'FIPDJG.TESTXLSX' disp=old;
7 ods excel file=te1;
8 proc print data=sashelp.class;
9 run;
NOTE: There were 19 observations read from the data set SASHELP.CLASS.
NOTE: The PROCEDURE PRINT used 0.08 CPU seconds.
10 ods excel close;
NOTE: Writing EXCEL file: FIPDJG.TESTXLSX
ERROR: Invalid physical name.
... View more