topic How to create a pdf page with 2 columns using ODS with a centered header? in SAS Programming

How to create a pdf page with 2 columns using ODS with a centered header?

Corinthian94 — Thu, 01 Aug 2024 14:08:00 GMT

Hi all,

I am trying to create a SAS report that has some pages with 2 columns with one centered header for the section. Code and output below:

ods pdf startpage = now;

ods pdf columns = 2;

ODS TEXT = "~{newline 1}";

ODS TEXT = "~{STYLE[JUST = C FONTWEIGHT = BOLD FONTSIZE = 12PT]Study Stop}";

ODS TEXT = "~{newline 1}";

proc sort data=current.status_file; by descending stop_date; run;

PROC REPORT DATA = current.status_file NOWD HEADLINE BOX SPLIT = "\";

column study_id stop_date ss_reason ssreas_othersp withdraw_reason;

where ss_reason ne .;

define study_id / center "ID";

define stop_date / center order = internal "Stop Date" format = MMDDYY10.;

define ss_reason / display center "Reason" format=ss.;

define ssreas_othersp / display center "Other reason";

define withdraw_reason / display center "Withdrawal Reason";

run;

ods pdf close;

I am able to get two columns using ODS PFF columns=2, but this then puts the header over the first column instead of at the center at the top of the page. Is there a way to center this in the middle of the two columns? I have tried to find something but have not had any luck, and anything I try gets rid of the two columns which is more important for the formatting than the title being in the middle. Thanks in advance for your help!

Re: How to create a pdf page with 2 columns using ODS with a centered header?

Ksharp — Fri, 02 Aug 2024 03:22:15 GMT

Can't you use TITLE statement ?

data have;
 set sashelp.heart(obs=100);
 keep sex height;
run;

title 'xxxxxxxxxx';
options nodate nonumber;
ods pdf file='c:\temp\temp.pdf' columns=2 startpage=no;
proc report data=have nowd;
run;
ods pdf close;

Re: How to create a pdf page with 2 columns using ODS with a centered header?

Corinthian94 — Thu, 22 Aug 2024 14:19:18 GMT

Thanks for this! Sorry this is so late - this is part of a larger report that has titles on each page, so the title statement is already used for something else at the beginning of the report. I need this specific page to have two columns and a centered header (my code for this page is below). Is there a way to make the title for just this paged centered? Thanks!

ods pdf startpage = now;

ODS TEXT = "~{newline 1}";

ODS TEXT = "~{STYLE[JUST = C FONTWEIGHT = BOLD FONTSIZE = 12PT]Study Stop}";

ODS TEXT = "~{newline 1}";

PROC REPORT DATA = file NOWD HEADLINE BOX SPLIT = "\";

column var var2 ss_reason ssreas_othersp withdraw_reason;

where ss_reason ne .;

define var / center "ID";

define var2 / center order = internal "Stop Date" format = MMDDYY10.;

define ss_reason / display center "Reason" format=ss.;

define ssreas_othersp / display center "Other reason";

define withdraw_reason / display center "Withdrawal Reason";

run;

ods pdf close;

Re: How to create a pdf page with 2 columns using ODS with a centered header?

Ksharp — Fri, 23 Aug 2024 00:31:48 GMT

Nope. I have no idea about it. Maybe @Cynthia_sas could give you a hand.

Re: How to create a pdf page with 2 columns using ODS with a centered header?

Cynthia_sas — Fri, 23 Aug 2024 01:27:28 GMT

Hi: If you're going to use ODS TEXT, and you want to change the style from the default placement I believe you need to change the style template used for the output. There's an example of doing this in the documentation https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/odsug/p14gx25pepks6dn1q9m7vkq3gfoi.htm#n0rx93bn3orev5n1ogar2yb813kra
Cynthia