I'm trying to generate report that look like test --> TAT REPORT 24Dec2019 TAT less than 5 hours 5 - 8 hours More than 8 hours Grand Total FTR 0 0 0 0 % 100% 0% 0% FTNR 1 1 108 110 % 1% 1% 98% Grand Total 17 1 108 126 % 13% 1% 86% Below is the code i'm using PROC REPORT DATA=test_b style(header)= {FOREGROUND = WHITE BACKGROUND = MAROON FONT = ('Calibri',7.5PT) FONTWEIGHT = BOLD BORDERCOLOR =BLACK} style(column)= {FONT = ('Calibri',7.5PT) BORDERCOLOR =BLACK just= center} style(report)= {FONT = ('Calibri',7.5PT) BORDERCOLOR =BLACK just= center} ; column ("test --> TAT REPORT &REPORT_DT" tat 'less than 5 hours'n '5-8 hours'n 'More than 8 hours'n 'Grand Total'n); RUN; Output: test --> TAT REPORT 27DEC2019 TAT less than 5 hours 5-8 hours More than 8 hours Grand Total FTNR 1 1 107 109 % 0.0091743 0.0091743 0.9816514 . FTR 16 . 1 17 % 0.9411765 . 0.0588235 . I'm unable to figure out is how to calculate the "Grand Total" and "Total percentage".
... View more