topic Re: How to display by variable from proc report into ods excel file but on the same page as a header in SAS Programming

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

hira — Mon, 17 Oct 2022 20:37:40 GMT

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.

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

Reeza — Mon, 17 Oct 2022 20:59:20 GMT

Title?

Title "#byval1";

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

Tom — Mon, 17 Oct 2022 21:38:02 GMT

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;

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

ballardw — Mon, 17 Oct 2022 21:44:05 GMT

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.

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

hira — Tue, 18 Oct 2022 09:26:43 GMT

Thank you so much.

It did work.