/*anyone making more than $99,999 a 2% raise, anyone making more than $49,999 to (including) $99,999 a 3% raise,
anyone making more than $29,999 to (including) $49,999 a 4% raise, and everyone else gets a 5% rais*/
data midterm.activeemployee;
set midterm.employee1;
if (salary >99999) then salary+salary *.02 ;
else if (salary >(49999<salary<=99999))then salary+ salary*.03;
else if (salary >(29999<salary<=49999))then salary+salary *.04 ;
else if (salary<=29999 ) then salary+salary *.05;
run;