BookmarkSubscribeRSS Feed
JHE
Obsidian | Level 7 JHE
Obsidian | Level 7

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;

1 REPLY 1
JHE
Obsidian | Level 7 JHE
Obsidian | Level 7

Those three columns without value after run PROC Report, do not know the reason.

Catch up on SAS Innovate 2026

Dive into keynotes, announcements and breakthroughs on demand.

Explore Now →
How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1606 views
  • 0 likes
  • 1 in conversation