I have PROC Report , do not know what reason, output columns missing value. SAS code in color columns missing from output.
Attach Table and output report for your reference.
SAS code:
PROC REPORT DATA=Rewk0.REWORK7100_SUMAMRY
style(header)=[font_size=11 pt background=silver]
style(summary)=[font_weight=bold];
define month / style(column)=[cellwidth=.8in];
COLUMN LOB QUARTER Month AllProcessed_Claims AllReworked_Claims AllRework_Percent Manually_Reworked Manual_ReworkedClaims_Percent Manual_ProcessedClaims_Percent Robot_Rework Robot_ReworkedClaims_Percent Robot_ProcessedClaims_Percent NonSuppressed_ProcessedClaims NonSuppressed_ReworkedClaims NonSuppressed_Rework_Percent Controllable_Rework Controllable_Rework_Percent Uncontrollable_Rework Uncontrollable_Rework_Percent ConfigRework ConfigRework_Percent;
define QUARTER /style(column)=[cellwidth=.8in];
define AllProcessed_Claims /'All Processed Claims' style(column)=[width=0.8in];
define quarter /group;
define AllReworked_Claims /style(column)=[cellwidth=1.2in];
define AllRework_Percent/format=percent12.4 style=[tagattr="format:#,##0.0#\%"];
define Manual_ReworkedClaims_Percent/format=percent12.4 style=[tagattr="format:#,##0.0#\%"];
define Manual_ProcessedClaims_Percent/format=percent12.4 style=[tagattr="format:#,##0.0#\%"];
define Robot_Rework/style(column)=[cellwidth=1.2in];
define Robot_ReworkedClaims_Percent/format=percent12.4 style=[tagattr="format:#,##0.0#\%"];
define Robot_ProcessedClaims_Percent/format=percent12.4 style=[tagattr="format:#,##0.0#\%"];
define NonSuppressed_ProcessedClaims/style(column)={just=right cellwidth=2in};
define NonSuppressed_ReworkedClaims/style(column)=[cellwidth=2in];
define NonSuppressed_Rework_Percent/format=percent12.4 style=[tagattr="format:#,##0.0#\%"];
define Controllable_Rework/style(column)=[cellwidth=1.4in];
define Controllable_Rework_Percent/format=percent12.4 style=[tagattr="format:#,##0.0#\%"];
define Uncontrollable_Rework/style(column)=[cellwidth=1.2in];
define Uncontrollable_Rework_Percent/format=percent12.4 style=[tagattr="format:#,##0.0#\%"];
define ConfigRework/style(column)=[cellwidth=1.2in];
define ConfigRework_Percent/format=percent10.2 style=[tagattr="format:##0.00\%"];
break after QUARTER / summarize STYLE=[background=lightgray];
rbreak after / summarize STYLE=[background=lightblue];
RUN;
Those three columns without value after run PROC Report, do not know the reason.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.