topic Proc Report header label "BY Group" in SAS Programming

Proc Report header label "BY Group"

HitmonTran — Wed, 13 Jan 2021 03:08:51 GMT

Hi,

I am outputting a .RTF using proc report using "By" statement. The "by group" on the header only appear on the first page and is center-aligned. How do I left-align and change the wording on every page? Thank you.

code:

title4 &title4; 
title5 &title5; 
title6 'Safety Population';

proc report data = final1 nowd headline headskip missing split='@' style(header column)=[protectspecialchars=off];
by dose;

	  columns ordx1 aebodsys total1 aedecod  desc   ;
	  define ordx1     / descending order     order=internal noprint;
	  define aebodsys  / order order=internal noprint;
	  define total1  / descending order  order=internal noprint;
	  define aedecod   / order order=internal noprint;
run;

current output:

want (in hightlight):

Re: Proc Report header label "BY Group"

tarheel13 — Wed, 13 Jan 2021 09:07:14 GMT

Use #byval title option in proc report.

https://www.lexjansen.com/nesug/nesug09/cc/CC29.pdf

Re: Proc Report header label "BY Group"

Cynthia_sas — Wed, 13 Jan 2021 14:30:27 GMT

Hi:
That is a good option; however there will be a challenge with the need to have the BY value centered on the first page, but left justified on all the other pages. With 1 TITLE statement, there is 1 justification -- either centered or left on all pages in the RTF file. So while I agree that using the #byval in the title is what they need to do, the justification expectation will need to change to what is possible.

Cynthia