I have been successful at adding a summary row below each category that sums all the columns. I am trying to insert a second summary row, but this one is the the total of all rows above that meet a specific criteria. Each row in orange in the sample needs to be summed up for the second totals row, also in orange. I am a beginner with PROC REPORT, so please forgive my ignorance at this point. If this just isn't possible, I can use an excel macro after the export, but would love to not have to do that. My PROC REPORT code is currently as follows: PROC REPORT DATA=WORK.COUNT_RPT NOWD SPLIT='*' /*BOX */
STYLE(HEADER)=[BACKGROUND=WHITE COLOR=BLACK FONTFAMILY='Arial Unicode MS' FONTSIZE=8PT]
STYLE(COLUMN)=[BACKGROUND=WHITE COLOR=BLACK FONTFAMILY='Arial Unicode MS' FONTSIZE=8PT ]
STYLE(LINES)={BACKGROUND=WHITE COLOR=BLACK FONTFAMILY='Arial Unicode MS' FONTSIZE=8PT}
;
WHERE ACCUM_TYPE_DESCR IN('INDIVIDUAL T1 DED','FAMILY T1 DED','INDIVIDUAL INN DED','FAMILY INN DED','INDIVIDUAL OON DED','FAMILY OON DED');
COLUMN
POLICY7
PLAN
ACCUM_TYPE_DESCR
PLAN_TYPE
RPT_TIER
ACCUM_LIMIT1
LIMIT_MET
COUNT_DISTINCT
SUM_of_ACCUM_YTD1
AVG_of_ACCUM_YTD1
PCT_TOTAL;
DEFINE POLICY7 / DISPLAY 'Policy' F=$12.
STYLE(COLUMN)={JUST=L};
DEFINE PLAN / DISPLAY 'Plan'
STYLE(COLUMN)={JUST=L TAGATTR='WRAPTEXT:NO' WIDTH=100%};
DEFINE ACCUM_TYPE_DESCR / ORDER=DATA GROUP 'Accumulator Description';
BREAK AFTER ACCUM_TYPE_DESCR /SUMMARIZE;
DEFINE PLAN_TYPE / DISPLAY 'PLAN Type'
STYLE(COLUMN)={JUST=L};
DEFINE RPT_TIER / DISPLAY 'Report Tier'
STYLE(COLUMN)={JUST=L};
DEFINE ACCUM_LIMIT1 / DISPLAY 'Plan Limit'
STYLE(COLUMN)={JUST=R TAGATTR='FORMAT:$#,##0_);[RED]\($#,##0\)'};
DEFINE LIMIT_MET / DISPLAY 'Limit Met Category'
STYLE(COLUMN)={JUST=L};
DEFINE COUNT_DISTINCT / ANALYSIS SUM 'Count'
STYLE(COLUMN)={JUST=R TAGATTR='FORMAT:#,##0_)'};
DEFINE SUM_of_ACCUM_YTD1 / ANALYSIS SUM 'Total YTD*Accumulations'
STYLE(COLUMN)={JUST=R TAGATTR='FORMAT:$#,##0_);[RED]\($#,##0\)'};
DEFINE AVG_of_ACCUM_YTD1 / ANALYSIS SUM 'Average*Accumulation'
STYLE(COLUMN)={JUST=R TAGATTR='FORMAT:$#,##0_);[RED]\($#,##0\)'};
DEFINE PCT_TOTAL / ANALYSIS SUM '% of Total'
STYLE(COLUMN)={JUST=R TAGATTR='FORMAT:#,##0.00%_)'};
RBREAK AFTER / SKIP;
/*COMPUTE AFTER ACCUM_TYPE_DESCR ;
LINE ' ';*/
COMPUTE AFTER ACCUM_TYPE_DESCR ;
LINE ' ';
ACCUM_TYPE_DESCR= CATT(ACCUM_TYPE_DESCR,' TOTALS');
DO i=1 TO 7;
/*CALL DEFINE (i,'STYLE','STYLE=[FONT_WEIGHT=BOLD bordertopwidth=4PT borderbottomwidth=4PT bordercolor=black
borderstyle=solid BORDERRIGHTCOLOR=WHITE BORDERLEFTCOLOR=WHITE]');*/
CALL DEFINE (i,'STYLE','STYLE=[FONT_WEIGHT=BOLD');
END;
DO i=8 TO 11;
/*CALL DEFINE (i,'STYLE','STYLE=[FONT_WEIGHT=BOLD
bordertopwidth=4PT borderbottomwidth=4PT bordercolor=black
borderstyle=solid]');*/
CALL DEFINE (i,'STYLE','STYLE=[FONT_WEIGHT=BOLD');
END;
ENDCOMP;
COMPUTE PCT_TOTAL ;
IF LIMIT_MET = '4.YES-LIMIT MET' THEN DO;
DO i = 7 to 11;
CALL DEFINE(i,'STYLE','STYLE=[BACKGROUND=#ffda03]');
END;
END;
/*for the same criteria LIMIT_MET='4.YES-LIMIT MET' INSERT THE COUNT TOTAL, YTD ACCUM TOTAL, AND AVG YTD ACCUM UNDER THE OVERALL TOTALS*/
ENDCOMP;
RUN;
... View more
