group by report proc report sheet_name = "#byval1"

[snip]

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

ods excel file='G:.....\class.xlsx'
options(sheet_name = "#byval1");
proc report data=class;
by sex;
column sex height weight;
define age / group; 
define height / mean; 
define weight / mean; 
rbreak before / summarize; 
run;
ods excel close;

Good morning, I produce a report with proc report and the option sheet_name = "#byval1" to have my data on two tabs according to my group by. I do not want to have my group displayed in the report. how to do it please?

[ballardw · Accepted solution]

Set OPTIONS NOBYLINE prior to the report. Don't forget to turn it back on later.

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

options nobyline;
ods excel file="&outpath.class.xlsx"
   options(sheet_name = "#byval1");
proc report data=class;
by sex;
column sex height weight;
define age / group; 
define height / mean; 
define weight / mean; 
rbreak before / summarize; 
run;
ods excel close;
options byline;

Warning: your COLUMNS statement does not include the AGE variable so the report has issues.

---

@snip wrote:

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

ods excel file='G:.....\class.xlsx'
options(sheet_name = "#byval1");
proc report data=class;
by sex;
column sex height weight;
define age / group; 
define height / mean; 
define weight / mean; 
rbreak before / summarize; 
run;
ods excel close;

Good morning, I produce a report with proc report and the option sheet_name = "#byval1" to have my data on two tabs according to my group by. I do not want to have my group displayed in the report. how to do it please?

---

[snip]

Thank you very much for your answer !!
the class table was just to be able to provide an example of what I want, it's not my real data