topic Re: ODS PDF: Suppress header if data flows to multiple pages in ODS and Base Reporting

ODS PDF: Suppress header if data flows to multiple pages

SuryaKiran — Thu, 28 Jan 2021 19:44:58 GMT

Hello Community,

Trying to find a way to suppress headers if the data flows to multiple pages in the same PROC REPORT.

data class;
set sashelp.class sashelp.class sashelp.class;
run;

ods pdf file="/user/Test_for_Header.pdf" ;
proc report data=class;
run;
ods pdf close;

I don't want the header on page 2.

Re: ODS PDF: Suppress header if data flows to multiple pages

Cynthia_sas — Thu, 28 Jan 2021 22:46:29 GMT

Hi, you would need to run 2 REPORT steps.
1) page 1 uses regular column headers
2) page 2 and all subsequent pages use NOHEADER option on the PROC REPORT statement. Here's what it looks like:

Cynthia

Re: ODS PDF: Suppress header if data flows to multiple pages

Ksharp — Fri, 29 Jan 2021 12:53:56 GMT

Change all the numeric variable into character.

data class;
length name sex _age _weight _height $ 40;
if _n_=1 then do;
name='name';sex='sex';_age='age';_weight='weight';_height='height';
output;
end;
set sashelp.class sashelp.class sashelp.class;
_age=put(age,best8. -l);
_weight=put(weight,best8. -l);
_height=put(height,best8. -l);
output;
drop age weight height;
run;

ods pdf file='c:\temp\x.pdf';
proc report data=class noheader;
compute name;
 n+1;
 if n=1 then call define(_row_,'style','style=header{fontsize=4 fontweight=blod}');
endcomp;
run;
ods pdf close;

Re: ODS PDF: Suppress header if data flows to multiple pages

SuryaKiran — Fri, 29 Jan 2021 15:54:06 GMT

Thanks for your reply @Ksharp. This is what I exactly did, but thought there must be a easy option that I might be missing in ODS PDF or PROC REPORT. If I don't find an easy way, I will mark this a solution.

Re: ODS PDF: Suppress header if data flows to multiple pages

SuryaKiran — Fri, 29 Jan 2021 15:58:25 GMT

Thanks for your reply @Cynthia_sas. Unfortunately I can't run two proc report, because I have another proc report before that might have varying rows. Rows count can't be pre-defined.

Re: ODS PDF: Suppress header if data flows to multiple pages

Ksharp — Sat, 30 Jan 2021 10:49:12 GMT

Yeah. I also want to know this option.
Maybe @Cynthia_sas know or talk to sas support .

Re: ODS PDF: Suppress header if data flows to multiple pages

Cynthia_sas — Sat, 30 Jan 2021 15:31:20 GMT

Hi, There is NOT any option. I showed the way to do it with 2 PROC REPORT steps. Otherwise, you need to fiddle with the data. For reports that are subject to regulatory constraints, fiddling with the data is not usually considered a viable option. There is nothing to ask Tech Support about this. There is NOT any option such as you envision.
Cynthia