שלום @Yul
זה עובד על המחשב שלי עם SAS 9.4M6 על Windows:
ods excel file="C:\Users\User\Desktop\Temp\Checks.xlsx" options(sheet_name="sheet1");
proc print data=sashelp.class;
run;
ods excel options(sheet_name="sheet2");
proc print data=sashelp.cars;
run;
ods excel options(sheet_name="sheet3");
proc print data=sashelp.class;
run;
ods excel close;
גם זה עובד:
proc export data=sashelp.class outfile="C:\Users\User\Desktop\Temp\Example.xlsx" dbms=xlsx replace;
sheet="CLASS1";
run;
proc export data=sashelp.class outfile="C:\Users\User\Desktop\Temp\Example.xlsx" dbms=xlsx replace;
sheet="CLASS2";
run;
חגי