Would anyone know how to easily generate a multi-sheets Excel file from multiple datasets by using SAS 8.2 ? One dataset corresponding to one worksheet in Excel. It should act as the SHEET option of the PROC EXPORT on SAS 9.
In addition I'd like to find a solution which does not require Excel to be opened and the Excel File to exist before executing the SAS code.
I've already read a lot of topics on the internet but none gave me the expected results.
In SAS 8.2, you only have ODS HTML available to you. By default, ODS HTML will create one worksheet for EVERY ODS sandwich:
ods html file='allinone.html' style=sasweb;
proc print data=file1; run;
proc print data=file2; run;
proc print data=file3; run;
ods html close;