instead of SUB value 'Agree services and credit' i want to show TOTAL word in group by sum row the issue is each SUB value is repeat again in group by sum row ,please help how can i remove that value. PROC REPORT DATA=CCG.RICAGO_WEEKLY_MIS_FINAL out=summary_table_result LIST
/*style=[cellwidth=.1 in rules=group frame=void] */
style(header)=[background= #BBDEFB foreground=black]
style(summary)=[background=white foreground=black font_weight=bold]
style={font_size=10pt font=('Calibri') width=600 cellpadding=2 borderwidth=0 bordercolor=white}
;
COLUMN SBU entity (Module) 'SBU Wise Total (All modules) 'n 'Ageing Report'n ;
DEFINE SBU / GROUP center style=[foreground=black font_weight=bold borderleftwidth=2 borderrightwidth=2] ;
define entity / group center style=[foreground=black font_weight=bold borderleftwidth=2 borderrightwidth=2] ;
DEFINE Module / ACROSS center style =[borderleftwidth=1 borderrightwidth=1];
/*DEFINE count / ACROSS style =[borderleftwidth=1 borderrightwidth=1];*/
DEFINE 'Ageing Report'n / ACROSS center style =[borderleftwidth=1 borderrightwidth=1 ];
define 'SBU Wise Total (All modules) 'n /computed center style=[font_weight=bold foreground=black ] ;
break after SBU /summarize dol dul skip;
COMPUTE SBU ;
IF _break_='_RBREAK_' THEN
CALL DEFINE('SBU','style','style=[pretext="Total "]');
ENDCOMP;
compute 'SBU Wise Total (All modules)'n;
'SBU Wise Total (All modules)'n=sum(input(_c2_,best32.),
input(_c3_,best32.),
input(_c4_,best32.),
input(_c5_,best32.),
input(_c6_,best32.),
input(_c7_,best32.),
input(_c8_,best32.)
);
IF 'SBU Wise Total (All modules) 'n ^= ' '
THEN CALL DEFINE(_COL_, "style", "STYLE=[BACKGROUND=#FBFCFC]");
/* call define(_row_,'style','style={borderrightwidth=4 borderrightcolor=black}'); */
endcomp;
endcomp;
compute entity;
count+1;
if mod(count,2) then do;
call define(_row_, "style", "style=[background=#E8EAF6]");
end;
else do;
call define(_row_, "style", "style=[background=#BDC3C7]");
END;
endcomp;
rbreak after / summarize;
RUN;
... View more
