The SAS Output Delivery System and reporting techniques

Is there any way to increase the width of page in ods pdf

Reply
N/A
Posts: 0

Is there any way to increase the width of page in ods pdf

Hi,
There are 30 variables in my dataset and for that dataset if I create a pdf file through ods odf then it shows 20 columns in first page and remaining 10 columns in second page,but i want all 30 columns should come in first page only.Is there any way to do that.


Thanks in advance.
Super Contributor
Posts: 273

Re: Is there any way to increase the width of page in ods pdf

Sivas,
Asking without showing parts of the submitted code is often difficult for the reader
I must presume you are using a proc print
I consider that 20 columns is already much

before opening ods pdf you may act upon options
like orientation margins papersize=A3 ...

and inside proc print you have also options
like heading=vertical
also the format statement can help you to reduce the width of columns

and finally with template or style like
var name/style=[fontsize=nnnpt] ...
act upon the font choices

Andre
N/A
Posts: 0

Re: Is there any way to increase the width of page in ods pdf

Hi Andre,
Actually my code is as fallows

options orientation=landscape;
ods pdf;
proc print data=sashelp.asscmgr;
run;
ods pdf close;

I am using the option orientation=landscape but still I am not getting.
N/A
Posts: 0

Re: Is there any way to increase the width of page in ods pdf

Hi Andre,
Please ignore the above code,the actual code is as follows
options orientation=landscape;
proc report data=sashelp.asscmgr nowd;
define LDESC/width=60;
run;
ods pdf close;
SAS Super FREQ
Posts: 8,740

Re: Is there any way to increase the width of page in ods pdf

Hi:
If you search in the forum search facility for the string "very wide" there was an earlier forum posting on dealing with very wide tables when landscape orientation was not "wide" enough. Basically your choices are to make the font smaller, reduce the cell padding in the table, remove interior tables lines and/or some combination of all of the above.

The earlier forum posting had a large section of code that showed the correct style attributes to change and how to change them in order to try to get "wide" output onto a PDF or RTF page.

One easy alternative is to switch to HTML output which can be as wide as you need it to be because there is no limit on how wide a browser screen can be ... although realistically, you will probably reach the limit of someone's patience to either scroll or squint when you have very wide tables if you make the table too wide or the font too small!

cynthia
Ask a Question
Discussion stats
  • 4 replies
  • 148 views
  • 0 likes
  • 3 in conversation