export to multiple sheets in excel with separate by group tables within each sheet

[Ronein]

Hello

I want to export data from SAS into Excel  to multiple sheets.

Each Sex will have another sheet.

Within the sheet I want to have separate tables (with title of each table)  for each age.

I have tried to add "ID age" statement but results are not as I want because there are no separate tables for each age group. What is the way to solve it please?

thanks

proc sort data=sashelp.class out=class;
by sex;
run;
ods excel file="d:\myfolder\class.xlsx" options(sheet_interval='BYGROUP' sheet_name= '#byval1');
proc print data=class;
by sex;
Id age;
run;
ods excel close;

[ChrisNZ]

You need to create the sheets manually, and use the BY statement to separate tables in each sheet. 

[PaigeMiller]

Use PROC PRINT with by sex age;