I would recode the SQL and make it simplier: The rest of the macro should be ok or you can modify many of the %Let into parameters proc sql noprint; insert into don.hold select "&FULLSF" as , count(distinct &SF&ilaps&Terr) as col1 , sum(Case When &SF&ilaps&CallTY= 'A' and &SF&ilaps&Prod1 = 'LN' Then &SF&ilaps&CallTarg Else 0 End) as col2 , sum(Case When &SF&ilaps&CallTY= 'A' and &SF&ilaps&Prod2 = 'LN' Then &SF&ilaps&CallTarg Else 0 End) as col3 , sum(Case When &SF&ilaps&CallTY= 'A' and &SF&ilaps&Prod3 = 'LN' Then &SF&ilaps&CallTarg Else 0 End) as col4 from don.Q215_ACT_ML_PANEL_FINAL_V5 ;
... View more