When you generate output using the ODS destination for Excel and you specify both the SHEET_LABEL=" " and the SHEET_INTERVAL="BYGROUP" options, the BY-group value that is used as a part of the Excel worksheet name is prefixed by the text "ByGroup" and the number of the BY group.

To retain only the BY-group value as the worksheet name on the tab, replace the SHEET_LABEL= option with the SHEET_NAME="#BYVAL(BY-group variable)" option. The sample code below illustrates this:

ods excel file='c:\Class.xlsx'
    options(sheet_interval="bygroup"
            sheet_name="#byval(sex)");

proc sort data=sashelp.class out=class; 
   by sex;
run;

proc print data=class; 
   by sex;
run;
 
ods excel close;

Operating System and Release Information