Hi, I have a question regarding the summarize function in proc report. I have a table with 3 columns containing numbers and 2 columns containing percentages. I am wondering if there is any way to get a single row at the bottom of this table with the sum of the number columns and the combined rate of the percentage columns. I can use BREAK AFTER / SUMMARIZE to get the sums of the number columns, but have not found a way to include the combined rate of the percentages. Is this possible? Here is my code: PROC REPORT DATA=SAMPLE_DATA ; COLUMNS COMPANY STATE YEAR LOB NUMBER1 PERCENT1 NUMBER2 PERCENT2 NUMBER3 NUMBER4; DEFINE COMPANY / ORDER NOPRINT; DEFINE STATE / ORDER NOPRINT; DEFINE YEAR / 'Year' ORDER format=YEAR4.; DEFINE NUMBER1 / FORMAT=DOLLAR15.; DEFINE NUMBER2 / FORMAT=DOLLAR15.; DEFINE NUMBER3 / FORMAT=DOLLAR15.; DEFINE NUMBER4 / FORMAT=DOLLAR15.; DEFINE PERCENT1 / FORMAT=PERCENT10.1; DEFINE PERCENT2 / FORMAT=PERCENT10.1; COMPUTE BEFORE _PAGE_ / LEFT; LINE COMPANY $CMPYFMT.; LINE STATE $STFMT.; LINE ' '; ENDCOMP; BREAK AFTER STATE / PAGE SKIP; BREAK AFTER YEAR / SUMMARIZE style={font_weight=bold cellheight=.25in vjust=b}; RUN; So I am looking for a summary of each year, essentially the sum of the numbers and combined rate of percents from all LOB in each year, state, company.
... View more