Units units=units*4 proc sql; update work.payrollmaster_new set salary=salary*1.05 where jobcode like '__1'; proc sql; update work.payrollmaster_new set salary=salary* case when substr(jobcode,3,1)='1' then 1.05 when substr(jobcode,3,1)='2' then 1.10 when substr(jobcode,3,1)='3' then 1.15 else 1.08 end;