I am attempting to use this code on a similar report. I am running into a problem where hold_snum is not populating. Here is my code. proc report data=done spanrows NOWD list ls=100 box style(header)=[fontstyle=italic fontsize=3] style(column)=[fontfamily=helvetica fontsize=2] style(report)=[fontsize=8pt]; column hold_snum catcount ZZCRCDESC ZZCRSDESC CTCLENDDT n pctn dummy; define hold_snum / computed ; define catcount / group ; define ZZCRCDESC / group 'Category' ; define ZZCRSDESC / group 'Disposition Code' ; define CTCLENDDT / across " "; define n / 'Total'; define pctn / 'Percent of Total' format=percent6.2; COMPUTE before catcount; hold_snum=catcount ; endcomp; break after ZZCRCDESC / dol dul skip summarize ; rbreak after/summarize; compute after ZZCRCDESC; ZZCRCDESC = 'SubTotal'; endcomp; compute after; ZZCRCDESC = 'Grand Total'; endcomp; compute ZZCRSDESC; if missing(ZZCRSDESC) then do; line_count=0; call define(_row_,'style','style=[background=lightyellow]'); end; endcomp; run;
... View more