Agreed. Here's a sample sas code. I am trying to convert to read as sql code. data PARTB_PHYS_LOOPY (drop = nat_key nat_key_count util_cnt_sum paid rename = paid2 = paid); set PARTB_PHYS_LOOPY; by nat_key; if (last.nat_key and util_cnt_sum >= 1 and nat_key_count > 1 )then paid2 = put(abs(CLM_LINE_NCH_PMT_AMT)*100+&count,$11.); else paid2 = paid; run;
... View more