topic Re: label for Summarize row in proc report in SAS Programming

label for Summarize row in proc report

Batman — Thu, 30 Jun 2022 20:46:07 GMT

How can I force the word "Total" for the summary line in the code below?

data a;
input x 1. y 1.;
datalines;
10
21
31
22
;
run;

proc format;
value grp
1='A'
2='B'
3='A'
;

proc report data=a;
col x n;
define x / group format=grp.;
define n / 'count';
compute before;
x = 'Total'; /*column or grand total*/
endcomp;
rbreak before / summarize;
run;

Re: label for Summarize row in proc report

Ksharp — Fri, 01 Jul 2022 02:44:47 GMT

 

data a;
input x 1. y 1.;
datalines;
10
21
31
22
;
run;

proc format;
value grp
1='A'
2='B'
3='A'
.='Total'
;


proc report data=a nowd  ;
column x xx n;
define x / group format=grp10. noprint  ;
define xx/computed;
define n / 'count';
compute xx/character length=10;
 xx=put(x,grp8. -l);
endcomp;
rbreak before / summarize;
run;