Case function to create brackets

[sdang]

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

[SASKiwi · Accepted solution]

Try this:

Case

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

else t1.Salary

end

[stat_sas]

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;

[sdang]

Thank you.  It worked.