topic Re: Data to print in single page but it is splitting In two? in SAS Programming

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

animesh123 — Fri, 02 Dec 2022 14:58:46 GMT

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

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

ballardw — Fri, 02 Dec 2022 15:15:08 GMT

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.

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

animesh123 — Fri, 02 Dec 2022 15:58:11 GMT

What code should I write for SAS Options statement ?

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

ballardw — Fri, 02 Dec 2022 17:00:46 GMT

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.

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

Ksharp — Sat, 03 Dec 2022 03:23:14 GMT

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;

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

gema — Wed, 18 Jan 2023 16:13:02 GMT

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

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

Cynthia_sas — Thu, 19 Jan 2023 00:28:20 GMT

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

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

gema — Thu, 19 Jan 2023 00:42:04 GMT

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,

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

ballardw — Thu, 19 Jan 2023 03:49:25 GMT

@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.

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

Cynthia_sas — Thu, 19 Jan 2023 22:36:09 GMT

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

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

gema — Thu, 19 Jan 2023 22:58:04 GMT

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

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

Cynthia_sas — Fri, 20 Jan 2023 01:56:25 GMT

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