topic Re: SAS pdf output not starting on the same page in SAS Programming

SAS pdf output not starting on the same page

twix17 — Mon, 08 Jul 2024 23:03:53 GMT

Hello Dear community,

I am trying to have two outputs on the same page but i am not getting a desired result.

Below is my code
Thanks for your help.


/*PRINT TABLE*/
ods escapechar="~";
options nodate;
options orientation=landscape leftmargin=0in pageno=1 rightmargin=0in topmargin=1in bottommargin=1in;
ods pdf startpage=never;
ods pdf file="output_path\output.pdf" notoc  ;
title;
/* Display Header */
proc report data=header nowd style(report)={just=left};
column col1 col2;
define col1 / display ' ' style(column)=[cellwidth=2in font_size=9pt font_face=calibri background=#90D5FF font_weight=bold]; 
define col2 / display ' ' style(column)=[cellwidth=3in font_size=9pt font_face=calibri];
run;

/* Display Body */
proc report data=data nowd style(report)={just=left};
columns <column list>;
define column_1 / 'column 1' style(header)={font_size=7pt font_weight=bold background=#90D5FF} style(column)=[cellwidth = 0.4in font_size=7pt font_face=calibri];
define column_2 / 'column 2' style(header)={font_size=7pt font_weight=bold background=#90D5FF} style(column)=[cellwidth = .6in font_size=7pt font_face=calibri];
define column_3 / 'column 3' style(header)={font_size=7pt font_weight=bold background=#90D5FF} style(column)=[cellwidth = 1in font_size=7pt font_face=calibri];
define column_4 / 'column 4' style(header)={font_size=7pt font_weight=bold background=#90D5FF} style(column)=[cellwidth = 0.8in font_size=7pt font_face=calibri];
define column_5 / 'column 5' style(header)={font_size=7pt font_weight=bold background=#90D5FF} style(column)=[cellwidth = 0.7in font_size=7pt font_face=calibri];
run;

ods pdf close;

Re: SAS pdf output not starting on the same page

Ksharp — Tue, 09 Jul 2024 01:07:02 GMT

Try
ods pdf startpage=never;
ods pdf file="output_path\output.pdf" notoc ;
----->
ods pdf file="output_path\output.pdf" notoc startpage=no;

Re: SAS pdf output not starting on the same page

twix17 — Tue, 09 Jul 2024 01:54:00 GMT

Hi @Ksharp
I tried this but the output remains the same.
ods pdf file="output_path\output.pdf" notoc startpage=no;

Regards.

Re: SAS pdf output not starting on the same page

Ksharp — Tue, 09 Jul 2024 02:11:35 GMT

That is due to you are using "orientation=landscape " option which leave no enough room to include the second table.

To make more room for second table ,try "papersize=(60in 80in)" option OR try "columns=2"option.


/*PRINT TABLE*/
ods escapechar="~";
options nodate;
options orientation=landscape papersize=A4 leftmargin=0in pageno=1 rightmargin=0in topmargin=1in bottommargin=1in;
ods pdf file="c:\temp\output.pdf" notoc  startpage=no columns=2;
title;
/* Display Header */
proc report data=sashelp.class nowd style(report)={just=left};
run;

/* Display Body */
proc report data=sashelp.class nowd style(report)={just=left};
run;

ods pdf close;

Re: SAS pdf output not starting on the same page

twix17 — Tue, 09 Jul 2024 05:26:37 GMT

Thanks @Ksharp

The new update partially works but i would want the output in the format below

instead of side by side.

Thanks again for your help.

Re: SAS pdf output not starting on the same page

Ksharp — Tue, 09 Jul 2024 07:11:39 GMT

/*PRINT TABLE*/
ods escapechar="~";
options nodate;
options orientation=landscape leftmargin=0in pageno=1 rightmargin=0in topmargin=1in bottommargin=1in;
ods pdf file="c:\temp\output.pdf" notoc startpage=no ;
title;
/* Display Header */
proc report data=sashelp.class nowd style(report)={just=left cellpadding=0 cellspacing=0 };
run;

/* Display Body */
proc report data=sashelp.class nowd style(report)={just=left cellpadding=0 cellspacing=0 };
run;

ods pdf close;