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

Ronein — Sun, 17 May 2020 18:25:56 GMT

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;

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

Kurt_Bremser — Sun, 17 May 2020 19:02:54 GMT

Try

ods excel options (sheet_interval="bygroup");

topic Re: Proc tabulate to create multiple tables+using ODS excel to export into one excel file in SAS Programming

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

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