/*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;