topic how do i write this code to do with percentages...instead of adding raise my results show decreasing in New SAS User

how do i write this code to do with percentages...instead of adding raise my results show decreasing

lornamigiro — Fri, 15 Nov 2019 02:14:11 GMT

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

Re: how do i write this code to do with percentages...instead of adding raise my results show decrea

unison — Fri, 15 Nov 2019 02:32:12 GMT

you need to adjust to be salary=salary*(1+raise);

data midterm.activeemployee;
	set midterm.employee1;
	if salary >99999 then  salary=salary*1.02 ;
	else if 49999<salary<=99999 then salary=salary*1.03;
	else if 29999<salary<=49999 then salary=salary*1.04 ;
	else if salary<=29999 then salary=salary*1.05;
run;

-unison

Re: how do i write this code to do with percentages...instead of adding raise my results show decrea

lornamigiro — Fri, 15 Nov 2019 02:39:00 GMT

thank you, it worked.

Re: how do i write this code to do with percentages...instead of adding raise my results show decrea

unison — Fri, 15 Nov 2019 02:41:41 GMT

perfect!

Re: how do i write this code to do with percentages...instead of adding raise my results show decrea

ballardw — Fri, 15 Nov 2019 17:12:47 GMT

And to see the joyous benefit of being on the low end of one of these scales provide input for two employees with incomes of 29999 and 30000 and see the result.