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.
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;
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;
Thank you so much.
It did work.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.