BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
DavidPhillips2
Rhodochrosite | Level 12

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;

1 ACCEPTED SOLUTION

Accepted Solutions
DavidPhillips2
Rhodochrosite | Level 12

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%};

View solution in original post

5 REPLIES 5
ballardw
Super User

Was there anything unexpected in the log?

 

 

DavidPhillips2
Rhodochrosite | Level 12

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;

DavidPhillips2
Rhodochrosite | Level 12

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

DavidPhillips2
Rhodochrosite | Level 12

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%};

Cynthia_sas
Diamond | Level 26

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

show_marg.png

 

  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

CFC_SAS_Communities_400x225.jpg

Call for content now open!

It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.

Submit your proposal →

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 9166 views
  • 1 like
  • 3 in conversation