topic Re: proc report - how to page break by groups in SAS Programming

proc report - how to page break by groups

HitmonTran — Tue, 11 Jan 2022 21:56:06 GMT

Hi,

I am trying to create a proc report that page break by treatment group (variable trtgrp) and laboratory parameter (variable param).

below is my code:

%macro dorpt (trtgrp=);
proc report data=final nowindows spacing=1 headskip headline split='|' spanrows;
      where trtgrp = "&trt" ;
	  by param;

      column trtgrp param avisitn avisit atoxgrn lbtox (/*"^S={borderbottomcolor=black borderbottomwidth=1} Baseline Result"*/'Baseline Result' col1-col5);

	  define trtgrp     / order noprint;
	  define param     / order noprint;
	  define avisitn   / order noprint;
	  define avisit    / group " " style(column)={asis=on width=2.8in just=left} style(header)={just=center};
	  define atoxgrn   / order noprint;
	  define lbtox     / order " " style(column)={width=1.4in just=left} style(header)={just=left};
	  define col1      / display "Normal" style(column)={width=.9in just=center} style(header)={just=center};
	  define col2      / display "Grade 1" style(column)={width=1.2in just=center} style(header)={just=center};
	  define col3      / display "Grade 2" style(column)={width=1.2in just=center} style(header)={just=center};
	  define col4      / display "Grade 3" style(column)={width=1.2in just=center} style(header)={just=center};
	  define col5      / display "Grade 4" style(column)={width=1.2in just=center} style(header)={just=center};

	* break after param /  page;

	 compute after avisitn;
	     line @1 " ";
	  endcomp; 

	/*  compute before param;
	   line @1 " ";
	   line @2 param $200.;
	  endcomp;*/


  run;

%mend;

%dorpt(trt=%str(1.0 mg/Placebo));
%dorpt(trt=%str(2.0 mg/Placebo));

Re: proc report - how to page break by groups

ballardw — Tue, 11 Jan 2022 22:33:21 GMT

First thing, your shown code should throw an error because the parameter defined in the macro is TRTGRP= but us calls with TRT=.

Did you try: BY Param Trtgrp; ? If the data isn't sorted to use that add the NOTSORTED to the by statement if your data is grouped in the data set as wanted. If not sort/group it before proc report.

You could use the #BYvar and #ByVal approach in title statements to get the sort of heading you show.

Param would be #Byvar1 with #Byval1 and Trtgrp would be #byvar2 and #byval2 in the order I show.

Likely you wouldn't want those variables in the Columns but I may be wrong.

Re: proc report - how to page break by groups

Ksharp — Wed, 12 Jan 2022 12:59:04 GMT

I think you can code like this :

%macro dorpt (trtgrp= , param= );
title "XXXXXX  &trtgrp ";
title2 "YYYYYYYY &param ";
proc report data=final nowindows spacing=1 headskip headline split='|' spanrows;
      where trtgrp = "&trtgrp"  and param= "&param" ;
 column ...........

Re: proc report - how to page break by groups

HitmonTran — Wed, 12 Jan 2022 20:24:05 GMT

thank you, the #BYVAR worked but now it's showing titles I don't need. I tried using title10=" "; but it still shows. How would I get rid of the red circle?

  title8 j=l "Laboratory Parameter: #byval2";
  title9 height=9pt j=l "Treatment Group: &trt";

    proc report data=final nowindows spacing=1 headskip headline split='|' spanrows;
      by trtgrp param;

      column  avisitn avisit atoxgrn lbtox (/*"^S={borderbottomcolor=black borderbottomwidth=1} Baseline Result"*/'Baseline Result' col1-col5);
 
	  define avisitn   / order noprint;
	  define avisit    / group " " style(column)={asis=on width=2.8in just=left} style(header)={just=center};
	  define atoxgrn   / order noprint;
	  define lbtox     / order " " style(column)={width=1.4in just=left} style(header)={just=left};
	  define col1      / display "Normal" style(column)={width=.9in just=center} style(header)={just=center};
	  define col2      / display "Grade 1" style(column)={width=1.2in just=center} style(header)={just=center};
	  define col3      / display "Grade 2" style(column)={width=1.2in just=center} style(header)={just=center};
	  define col4      / display "Grade 3" style(column)={width=1.2in just=center} style(header)={just=center};
	  define col5      / display "Grade 4" style(column)={width=1.2in just=center} style(header)={just=center};
 

	 compute after avisitn;
	     line @1 " ";
	  endcomp; 
 
  run;

Re: proc report - how to page break by groups

AD16 — Wed, 14 Feb 2024 20:14:48 GMT

Just use options nobyline;