Data to print in single page but it is splitting In two?

[animesh123]

I want this Data to print in single page but it is splitting In two. Any suggestion please?

[ballardw]

Proc Print output does that when the length of "printed" line exceeds the display area available.

You could use STYLE overrides on VAR statements to reduce the width of displayed columns or provide a larger space for the display.

It is extremely hard to tell what your code is as pictures are not clear but it appears you may be using PDF output. You can use the SAS Options statement, probably should be before the ODS PDF statement, to set either the ORIENTATION to landscape or the PAPERSIZE option to some larger display are or use a different ODS style that uses smaller fonts to reduce the space used.

[animesh123]

What code should I write for SAS Options statement ?

[ballardw]

I would start with

options orientation=landscape;

However, if your table is longer than the resulting rotation of the print area will display you will have to use Papersize and that will depend on the actual data. So look in the online help for the options.

[gema]

options linesize=132 ps=10000 nocenter orientation=landscape;

[Cynthia_sas]

Hi: Linesize and Pagesize options are ignored by ODS DESTINATIONS. Especially destinations like ODS PDF and ODS RTF and ODS HTML and all the others except for LISTING really do not use Linesize and Pagesize options. Your output looked like RTF or PDF. As mentioned, your code is hard to read since it is a picture of a screen.

Cynthia

[gema]

Those are valid options in SAS. I typed my response in the reply box, so I am confused. I wasn't referring to ODS. Thanks,

[ballardw]

---

@gema wrote:
Those are valid options in SAS. I typed my response in the reply box, so I am confused. I wasn't referring to ODS. Thanks,

---

It is very hard to read but original question is sending output to ODS PDF. So for a workable solution to that question the should related to something that will affect output in ODS PDF.

[Cynthia_sas]

Hi, yes, you are correct, LINESIZE and PAGESIZE are valid SAS System Options. However, they are NOT used for all output creation. These options are designed for the LISTING output (or the Output Window). Other options, equally valid, such as DATE and NUMBER are used by ODS PDF, ODS RTF and the LISTING window, but are NOT used by ODS HTML or ODS CSV destinations. The bottom line is that the SAS System options may or may not be used when you create ODS output.

But, since you want PDF output, those settings will NOT be used for creating PDF output. You should use the topmargin, bottommargin, rightmargin, and leftmargin options along with the orientation=landscape option.
Cynthia

[gema]

Yes. I did not mean to imply that these options were intended for anything other than SAS listing output

[Cynthia_sas]

Hi:
I understand. I was confused because your screen shot was of ODS PDF output, so the LINESIZE and PAGESIZE were not involved in the reason your output was split. Which made me confused why there was even a suggestion to alter those 2 options.
Cynthia

[Ksharp · Accepted solution]

ods pdf file='c:\temp\temp.pdf' style=journal;
proc report data=sashelp.heart(obs=100) nowd style={outputwidth=100%};
define _all_/style(column)={cellwidth=5%};
run;
ods pdf close;