I just wanted to follow-up, in case someone else runs across this problem.    But like I said, the field I was originally using was already created using a PUT Statement and the format: SUM(CALCULATED DATE_OF_DATA, -next_due_date) AS CONT_DELQ_DAYS_c , PUT(CALCULATED CONT_DELQ_DAYS_c, contractual_delinquency_days61_.) AS CONTRACTUAL_DELINQUENCY_c , PUT(CALCULATED CONT_DELQ_DAYS_c, validation_delinquency_days61_.) AS VALIDATION_DELINQUENCY_c So rather than use the field 'VALIDATION_DELINQUENCY_c' in the PROC REPORT layout, I needed to use the field 'CONT_DELQ_DAYS_c' and apply the format in the DEFINE Statement, along with the COMPLETEROWS Option in the PROC REPORT Statement and the PRELOADFMT Option in the DEFINE Statement: PROC REPORT DATA=&client_number..&client_number._&medte._analysis MISSING COMPLETEROWS STYLE(header)=[fontfamily="Albany AMT"] STYLE(column)=[fontfamily="Albany AMT"] ; SYSECHO "Printing Validation Delinquency" ; COLUMNS CONT_DELQ_DAYS_c &delinquency_balance_field. &delinquency_balance_field.=DELQBAL,(PCTSUM SUM) ; DEFINE CONT_DELQ_DAYS_c / GROUP "Validation Delinquency" MLF RIGHT format=validation_delinquency_days61_. PRELOADFMT ; DEFINE &delinquency_balance_field. / N "Count" STYLE(column)=[cellwidth=.7in] format=comma9. ; DEFINE DELQBAL / "" format=dollar18.2 ; DEFINE PCTSUM / "Percent of Field" STYLE(column)=[cellwidth=1.2in] format=percent9.2 ; DEFINE SUM / "&delinquency_balance_field." STYLE(column)=[cellwidth=1.4in] format=dollar18.2 ; RBREAK AFTER / SUMMARIZE STYLE=header[font_style=italic] ; COMPUTE AFTER / STYLE=[fontsize=3 fontfamily="Calibri" font_style=italic font_weight=bold just=center] ; CALL DEFINE("CONT_DELQ_DAYS_c", "style", 'style=header[pretext="Grand Totals" textalign=right]') ; LINE " " ; LINE "%sysfunc(PROPCASE(%sysfunc(TRANSLATE(&client_name., ' ', '_')))) is currently using &line_filter." ; LINE " " ; LINE "^S={font_weight=medium} Delq Filter Used: None" ; LINE " " ; ENDCOMP ; RUN ; Thank you again, @PaigeMiller , for your help!       ... View more

I figured it out. I did not explain as well as I should, the GROUP variable in the PROC REPORT output is previously defined with the format and a PUT statement when it is created. I changed the PROC REPORT to use the days column and included the format in the report definition and it appears to work. THank you again for your help! Much Appreciated! ... View more

Thank you for the reply!   Should I include the COMPLETEROWS option in the PROC REPORT Statement, as well?   Also, there was this error: WARNING: The format for variable VALIDATION_DELINQUENCY_c cannot be preloaded. A finite set of formatted values cannot be produced from the format. The format is not recognized, is a SAS format, calls a function, or contains a nested format in its definition. Preload will have no effect.   In case it helps, here is the PROC REPORT code: PROC REPORT DATA=t_delinquencysort MISSING COMPLETEROWS style(header)=[fontfamily="Albany AMT"] style(column)=[fontfamily="Albany AMT"] ; SYSECHO "Printing Validation Delinquency" ; COLUMNS VALIDATION_DELINQUENCY_c &delinquency_balance_field. &delinquency_balance_field.=DELQBAL,(PCTSUM SUM) ; DEFINE VALIDATION_DELINQUENCY_c / GROUP "Validation Delinquency" MLF RIGHT ORDER=data PRELOADFMT ; DEFINE &delinquency_balance_field. / N "Count" style(column)=[cellwidth=.7in] format=comma9. ; DEFINE DELQBAL / "" format=dollar18.2 ; DEFINE PCTSUM / "Percent of Field" style(column)=[cellwidth=1.2in] format=percent9.2 ; DEFINE SUM / "&delinquency_balance_field." style(column)=[cellwidth=1.4in] format=dollar18.2 ; RBREAK AFTER / SUMMARIZE style=header[font_style=italic] ; COMPUTE AFTER / style=[fontsize=3 fontfamily="Calibri" font_style=italic font_weight=bold just=center] ; CALL DEFINE("VALIDATION_DELINQUENCY_c", "style", 'style=header[pretext="Grand Totals" textalign=right]') ; LINE " " ; LINE "%sysfunc(PROPCASE(%sysfunc(TRANSLATE(&client_name., ' ', '_')))) is currently using &line_filter." ; LINE " " ; LINE "^S={font_weight=medium} Delq Filter Used: None" ; LINE " " ; ENDCOMP ; RUN ; ... View more

When I format as dollar16.2 I get $30,616.00 ... View more

Variables in Creation Order # Variable Type Len 1 customer_name Char 25 2 account_number Char 8 3 loan_number Char 5 4 loan_date Num 8 5 maturity_date Num 8 6 term Num 8 7 payment_amount Num 7 8 odd_payment_amount Num 7 9 total_of_payments Num 7   I told you it was a number with a length of 7, so here is also a picture that says it is a number with a length of 7 ... View more

Apologies for not being clear, I am reading this data in from an external text file like this:   "CUSTOMER NAME","ACCOUNT NUMBER","LOAN NUMBER","LOAN DATE","MATURITY DATE","TERM","PAYMENT AMOUNT","ODD PAYMENT AMOUNT","TOTAL OF PAYMENTS" "******, ****","15028","28","010919","011724","060","0030616","0030616","1836960" ... View more

I thought it might be something via WHICHC or CHOOSEC, but wasn't sure how to implement either. Thank you for your help!! ... View more

Thank you, Cynthia!  This does indeed help, great paper! ... View more

I do not know where I read that MLF was NOT an option for PROC REPORT, but it may have been implemented somewhat recently?   Either way, thank you for pointing out that I can use it, appreciate your help! ... View more

Hi ballardw,   The format is actually already using multilabel, but as far as I know multilabel formats are not recognized within proc report, only means, summary, and tabulate.   PROC FORMAT ; VALUE $delinq_61_ (MULTILABEL) "0" = " 0" "30" = " 31-60" "60" = " 61-90" "90" = " 91-120" "120" = "121-150" "150" = "151-180" "180" = "181-210" "210" = "211+ " "90","120","150","180","210" = "Total 90+ Delinquency" ; RUN ; My hope was to be able to sum the specific rows within proc report, rather than use tabulate ... View more