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;
Try
ods excel options (sheet_interval="bygroup");
Try
ods excel options (sheet_interval="bygroup");
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.