topic Re: Case function to create brackets in SAS Enterprise Guide

Case function to create brackets

sdang — Wed, 24 Sep 2014 00:22:44 GMT

Hi, can some one help me on this case function. I'm trying to create a new calculated column and employee hired between two dates, they get bonus based on the dates range I set.

Case

When date(01/01/1976)<=t1.Employee_Hire_Date<=date(12/31/1985) then t1.Salary*.001

else t1.Salary

end

Re: Case function to create brackets

SASKiwi — Wed, 24 Sep 2014 01:13:42 GMT

Try this:

Case

When "01/01/1976"d <=t1.Employee_Hire_Date<= "12/31/1985"d then t1.Salary*.001

else t1.Salary

end

Re: Case function to create brackets

stat_sas — Wed, 24 Sep 2014 01:57:04 GMT

Based on your logic looks like you are trying to add bonus amount in salaries for the employees hired between the specified dates. So end variable will be salary again.

Case

When "01Jan1976"d <=t1.Employee_Hire_Date<= "31Dec1985"d then t1.Salary*1.001

else t1.Salary end as Salary;

Otherwise, if need a bonus variable then

Case

When "01Jan1976"d <=t1.Employee_Hire_Date<= "31Dec1985"d then t1.Salary*0.001

else 0 end as Bonus;

Re: Case function to create brackets

sdang — Thu, 25 Sep 2014 00:10:49 GMT

Thank you. It worked.