topic proc report : repeat value on each page for grouping variable value at the beginning in ODS and Base Reporting

proc report : repeat value on each page for grouping variable value at the beginning

raja777pharma — Tue, 21 Jan 2025 05:57:08 GMT

Hi ,

I am trying to display the COL1 "Subject ID" Groupe variable value in next page starting to identify the rows related to Subject

My current code is :

options orientation=landscape nodate nonumber center nobyline ;
ods rtf file = "&apath\table 02.rtf" startpage-yes style=styles.outrtf device-sasemf;
proc report data= prodout.table  headline headskip missing center split='|' nowd
style (report) - (cellpadding=0.5pt cellspacing=1pt just=c FRAME-ABOVE  ASIS=ON RULES-GROUPS)
style (header) = (font=("courier new", 9pt, bold) vjust-middle  asis=on just=1}
style (column) - (font-("Courier New", 9pt, normal) asis=on /just=1/}
style (lines) = (font=("courier new", 9pt, normal) asis=on):

column coll pageord ord0 col2 col3 col col5;

define pageord /order = internal order noprint;
define ord0    /order = internal order noprint;


define coll / 'Subject ID' group width=15 flow style (header) - [just-left] style (column) - [cellwidth =15% asis=on] left id;
define COL2 / flow 'Reported Term/System| Organ Class/Preferred Term' width=39 flow style (header) = [just-style (column) - [cellwidth =39% asis-on]:
define col3 / flow 'Start date' width=15 flow style (header) = [just=left]   style (column) - [cellwidth -15% asis=on];
define col4 / flow 'Ongoing/End date' width=15 flow style (header) = [just=left] style (column) = [cellwidth -15% asis=on];
define col5 / flow 'Intensity' width=15 flow style (header) - [just=left] style (column) = [cellwidth -15% asis=on];

compute after ord0;
  line '     ';
  endcomp;
  
run;

ods rtf close;
ods listing;

I want to repeat the Subject ID on page 2 for first row .

Below is the output

Page 1

Page 2

Thank you,

Rajasekhar.

Re: proc report : repeat value on each page for grouping variable value at the beginning

Ksharp — Tue, 21 Jan 2025 06:31:56 GMT

data have;
 set sashelp.heart(obs=90);
 keep sex weight height bp_status;
run;
proc sort data=have;by sex;run;
option nodate nonumber;
title;
ods tagsets.rtf file='c:\temp\temp.rtf' style=journal startpage=no;
proc report data=have nowd spanrows;
column sex bp_status weight height ;
define sex/order;
define bp_status/display;
define weight/display;
run;
ods tagsets.rtf close;

Re: proc report : repeat value on each page for grouping variable value at the beginning

raja777pharma — Tue, 21 Jan 2025 07:20:08 GMT

Hi ,

I have updated below statement , but still getting same and not repeating the subject id

define coll / 'Subject ID' order width=15 flow style (header) - [just-left] style (column) - [cellwidth =15% asis=on] left id;

Thank you,

Rajasekhar.

Re: proc report : repeat value on each page for grouping variable value at the beginning

Ksharp — Tue, 21 Jan 2025 08:12:37 GMT

So did you check where is difference between your code and mine ?

title;
ods tagsets.rtf file='c:\temp\temp.rtf' style=journal startpage=no;
proc report data=have nowd spanrows;
column sex bp_status weight height ;
define sex/order;
define bp_status/display;
define weight/display;
run;
ods tagsets.rtf close;