topic Re: Proc Report Headline Break PDF in SAS Programming

Proc Report Headline Break PDF

usanj — Tue, 15 Jul 2025 12:53:55 GMT

Hi,

I am trying to generate both RTF and PDF output using the same PROC REPORT. It works fine for RTF & PDF when I don't assign any cell widths in define statement. But I see a break line in the row over the column headers for the column which has the cell widths assigned. Below is the sample code. No issues in _car2* but I see the break line in _car1.pdf output. Any suggestions to fix this to allow the cell width control of any column without the break line causing the issue?

ods path work.temp(update) sashelp.tmplmst(read) sasuser.templat(update);

options leftmargin=0.75in rightmargin=0.75in topmargin=0.75in bottommargin=0.75in;

options orientation=landscape;

proc template;
define style cstyle;
parent=styles.Printer;
style Table /
foreground=black
background=white
cellspacing=0
cellpadding=0
frame=hsides
rules=groups
;
style Body /
foreground=black
background=white
;
style SysTitleAndFooterContainer /
cellspacing=0
;
end;
run;

ods rtf file="/outputs/_cars1.rtf" startpage=yes style=cstyle;
ods pdf file="/outputs/_cars1.pdf" startpage=yes style=cstyle;

proc report data=sashelp.cars nowd style(report)={just=left outputwidth=100%};
column ( make model type origin drivetrain);
define make / style(column)={just=left cellwidth=10%};
run;

ods _all_ close;

ods rtf file="/outputs/_cars2.rtf" startpage=yes style=cstyle;
ods pdf file="/outputs/_cars2.pdf" startpage=yes style=cstyle;

proc report data=sashelp.cars nowd style(report)={just=left outputwidth=100%};
column ( make model type origin drivetrain);
define make / style(column)={just=left };
run;

ods _all_ close;

Thanks

Re: Proc Report Headline Break PDF

Kathryn_SAS — Tue, 15 Jul 2025 15:45:49 GMT

Instead of using OUTPUTWIDTH, define a CELLWIDTH for each column.

ods _all_ close;
ods rtf file="_cars1.rtf" startpage=yes style=cstyle;
ods pdf file="c_cars1.pdf" startpage=yes style=cstyle;

proc report data=sashelp.cars nowd style(report)={just=left};
column ( make model type origin drivetrain);
define make / style(column)={just=left cellwidth=1in};
define model / style(column)=[cellwidth=2in];
define type / style(column)=[cellwidth=2in];
define origin  /style(column)=[cellwidth=2in];
define drivetrain / style(column)=[cellwidth=1in];
run;

ods _all_ close;

Re: Proc Report Headline Break PDF

usanj — Tue, 15 Jul 2025 16:57:16 GMT

Hi Kathryn - with above suggested code, only 3 columns show up Page 1 and next 2 are getting pushed to next page. My intention is to make the page wide (minus the margins) and fit in as many columns as possible.

Re: Proc Report Headline Break PDF

Kathryn_SAS — Tue, 15 Jul 2025 17:22:15 GMT

You may have to use trial and error to determine the best Cellwidths based on orientation and margin settings. You will not be able to use OUTPUTWIDTH if you do not want a break in the header border in the PDF output.