SAS - ODS Example using BY group to split data to separate sheets

SAS_ODS_EXCEL_split_bygroup.sas

/*This is an example of exporting data to excel, with each section going to a 
separate sheet and each sheet taking the name of the group*/

*sorts your data to use BY logic;
proc sort data=sashelp.cars out=cars;
by origin;
run;

*removes proc title and by line which are usually printed by default;
ods  noptitle;
options nobyline;

*sets file options - notice use of #BYVAL1 in Sheet Name to control sheet names;
ods excel file='/home/fkhurshed/ODS_Example1.xlsx' style=meadow
        options(sheet_interval = "BYGROUP"  sheet_label = " " sheet_name="#Byval1");
 
*displays data in Excel sheet;
proc print data=cars;
by origin;
run;

*closes file;
ods excel close;