topic Re: ODS PDF Landscape in SAS Programming

ODS PDF Landscape

DavidPhillips2 — Wed, 10 Jul 2019 20:16:32 GMT

For some reason this simple call of my proc report to change the orientation to landscape is staying is portrait. Am I missing something?

OPTIONS orientation=landscape nodate;
ods pdf

file="/serverpath/my.pdf"

ods escapechar='~';

/*proc report goes here*/

ods pdf close;

ods pdf(id=VCU_Report_Printing1) close;

Re: ODS PDF Landscape

ballardw — Wed, 10 Jul 2019 20:28:57 GMT

Was there anything unexpected in the log?

Re: ODS PDF Landscape

DavidPhillips2 — Wed, 10 Jul 2019 20:44:24 GMT

No errors around the pdf area. I think i need to set the margins for the proc report part somehow because this works.

OPTIONS orientation=landscape nodate;
ods pdf file="/serverpath/testOrientation.pdf";

ods escapechar='~';
proc sql;
select count(*), count(*), count(*),count(*), count(*), count(*), count(*), count(*), count(*), count(*),
count(*), count(*), count(*),count(*), count(*), count(*), count(*), count(*), count(*), count(*),
count(*), count(*), count(*), count(*), count(*), count(*), count(*), count(*) from sashelp.shoes
quit;
ods pdf close;

ods pdf(id=VCU_Report_Printing1) close;

Re: ODS PDF Landscape

DavidPhillips2 — Wed, 10 Jul 2019 20:46:45 GMT

I also have an image in the title that spans longer than the proc report.

Re: ODS PDF Landscape

DavidPhillips2 — Wed, 10 Jul 2019 21:01:31 GMT

It was the width of the proc report. Not sure how it got capped.

but this worked.

proc report data=FacultyProfileFall out=finalTable /*wid*/ style(report)={outputwidth=100%};

Re: ODS PDF Landscape

Cynthia_sas — Wed, 10 Jul 2019 22:23:49 GMT

Hi: You can change the margins for PDF and RTF in the OPTIONS statement. This worked for me:

Even with LANDSCAPE orientation, without any other instructions, the first PROC REPORT uses default widths that it calculates. With a style override to use 100% of the area between the margins, then the output is "stretched" to fit between the margins set in the OPTIONS statement.

Cynthia