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; ... View more

I have Table1 attached file in detail. I want using Proc Transpose function, have new table called Table2.   --------------------------------------------------------------------------------------------------------------------------------- Table1: Month,           ENROLLMENT,    MAJOR_MEDICAL,    PBM,    Pharmacy,   LB,      DENTAL             _ 2018-01_       212,400              10,962                        2,890     12,344        483      1,868 ---------------------------------------------------------------------------------------------------------------------------------   I want this transpose become table 2 as : --------------------------------------------------------------- Table2:  OHI_Plan,                       _2018-01_             ENROLLMENT                 212,400              MAJOR_MEDICAL           10,962              PBM                                   2,890              Pharmacy                          12,344              LB                                      483             DENTAL                            1,868 -------------------------------------------------------------------------------- SAS code: Proc sort data = table1;  By Month; Run;   Proc Transpose data = table1 out=table2;   name = OHI_PLan;   ID Month; run;   After the SAS ode run, got result table 2 only has column names, without data. OHI_Plan , _201801_     Do not know why.     ... View more

I have simple PROC SQL update, not sure why it dose not working.   PROC SQL; UPDATE work.LOB2100_PF022_Summary SET OHI_PLAN='Total Enrolled Health Plan'; QUIT;     ... View more