I'm trying to Print grand total and subtotal. The code is doing its job but labeling of grand total and subtotal is not showing up. Help will be appreciated. Thanks! My code is:
proc report data=Test ;
column Month Customer_ID Bill Code Contractor Bill_1 Bill_2 TOT_AMT;
define Month/group;
define Customer_ID / group;
define Bill Code /group;
define Contractor /group;
/* define statistics*/
define Bill_1/sum format=comma12.2;
define Bill_2/sum format=comma12.2;
define TOT_AMT /sum format=comma12.2;
compute after Month;
Month ='Sub-Total'; endcomp; rbreak after/summarize;
compute after ;
Month='Grand Total'; /*Column or grand total*/
endcomp; break after Month /summarize;
run;
The result is:
Month
Customer_ID
Bill Code
Contractor
Bill_1
Bill_2
TOT_AMT
202001
2908
S10
NET
0
-2,064.69
-2,064.69
S13
REN
6,882.30
0
6,882.30
S16
HIS
1,134.30
0
1,134.30
6,882.30
0
5,951.91
202002
2908
S13
REN
6,882.30
0
6,882.30
S16
HIS
1,134.30
0
1,134.30
6,882.30
0
8,016.60
202003
2908
S13
REN
6,882.30
0
6,882.30
S16
HIS
1,134.30
0
1,134.30
6,882.30
0
8,016.60
24,049.80
-2,064.69
21,985.11
... View more