How to display by variable from proc report into ods excel file but on the same page as a header

[hira]

Hi,

Would there be a solution to display by variable (byvar) from a proc report as a header in the excel file (ods output) on the same page, something like below, but not as a column variable.

       byvar

var1 var2 var3

a     b        c

d     e        f

        byvar

var1 var2 var3

a       b        c

d       e         f

Thank you.

[Reeza]

Title?

Title "#byval1";

[Tom · Accepted solution]

Doesn't it do that automatically?

proc sort data=sashelp.class out=class;
 by sex;
run;
ods excel file='c:\downloads\class.xlsx' ;
ods excel options (sheet_interval='none');
proc report data=class;
  by sex;
run;
ods excel close;

[hira]

Thank you so much.

It did work.

[ballardw]

Please show the Proc Report code you are attempting.

I would expect a BY statement in Proc Report to provide something like that unless you have set the BYLINE system option to NOBYLINE.