Proc tabulate to create multiple tables+using ODS excel to export into one excel file

[Ronein]

Hello

I want to use ODC EXCEL in order to export tables into excel.

I want that each table will be in a separate sheet.

There will be 3 sheets: Europe ,Asia, USA.

I also want to ask how sas determine the order of the sheets.

proc sort data=sashelp.cars out=cars;
by origin;
run;
proc tabulate data=cars;
class make;
by origin;
var invoice;
table make ALL='TOTAL'  ,invoice=SUM;
Run;

[Kurt_Bremser · Accepted solution]

Try

ods excel options (sheet_interval="bygroup");