TITLE height=3 color=BLUE J=LEFT "Branch Wise 1+ Count";
PROC REPORT DATA=WORK.FINAL_DPD LS=132 PS=60 SPLIT="/" CENTER ;
COLUMN LOAN_BRANCH_BHEEM DPD TOTAL_COUNT PCT;
DEFINE DPD / SUM FORMAT= 11. WIDTH=11 SPACING=2 CENTER "1+ Count" ;
DEFINE LOAN_BRANCH_BHEEM / DISPLAY FORMAT= $150. WIDTH=150 SPACING=2 LEFT "Branch";
DEFINE TOTAL_COUNT / SUM CENTER "Total Count";
DEFINE PCT/computed format = percent8.2 CENTER "% (Count)";
RBREAK AFTER/SUMMARIZE;
COMPUTE AFTER;
LOAN_BRANCH_BHEEM="Grand Total";
if upcase(_BREAK_)="_RBREAK_" then do;
call define (_row_,'style','style=[background=#EDF2F9 foreground=#112277 fontweight=bold');
END;
ENDCOMP;
COMPUTE PCT;
PCT =_c2_/_c3_;
ENDCOMP;
RUN;
... View more