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
