Cynthia has valid questions that should be answered to give a more exact answer. Here is pseudo proc sql that should get you going: proc sql;   create table output as   select   em.name,   s.current_salary,   case   when e.profile = 'Pilot' and r.promotion = 0 and r.rating = 1 then s.current_salary * 1.2   when e.profile = 'Pilot' and r.promotion = 0 and r.rating = 2 then s.current_salary * 1.12   when e.profile = 'Pilot' and r.promotion = 0 and r.rating = 3 then s.current_salary * 1.08   when e.profile != 'Pilot' and r.promotion = 0 and r.rating = 1 then s.current_salary * 1.12   when e.profile != 'Pilot' and r.promotion = 0 and r.rating = 2 then s.current_salary * 1.06   when e.profile != 'Pilot' and r.promotion = 0 and r.rating = 3 then s.current_salary * 1.04   when e.profile = 'Pilot' and r.promotion = 1 and r.rating = 1 then s.current_salary * 1.2 + s.current_salary * .1   when e.profile = 'Pilot' and r.promotion = 1 and r.rating = 2 then s.current_salary * 1.12 + s.current_salary * .1   when e.profile = 'Pilot' and r.promotion = 1 and r.rating = 3 then s.current_salary * 1.08 + s.current_salary * .1   when e.profile != 'Pilot' and r.promotion = 1 and r.rating = 1 then s.current_salary * 1.12 + s.current_salary * .1   when e.profile != 'Pilot' and r.promotion = 1 and r.rating = 2 then s.current_salary * 1.06 + s.current_salary * .1   when e.profile != 'Pilot' and r.promotion = 1 and r.rating = 3 then s.current_salary * 1.04 + s.current_salary * .1   end as new_salary   from   rating r,   employeemaster e,   salary s   where   e.employee_id = s.employee_id   and e.employee_id = r.employee_id; quit; ... View more