DATA Step, Macro, Functions and more

Proc Report output columns missing value

Reply
Frequent Contributor
Frequent Contributor
Posts: 119

Proc Report output columns missing value

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;

Frequent Contributor
Frequent Contributor
Posts: 119

Re: Proc Report output columns missing value

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

Ask a Question
Discussion stats
  • 1 reply
  • 108 views
  • 0 likes
  • 1 in conversation