Hi,
I have a situation where I need to calculate a performance based on 2 criteria. Below is what I have attempted in EG - but it errored.
The 1st 2 criterias are from one table, and the last 2 are from another table. There is no common column/field between the 2 tables - so I did not join them.
If the employee meets the two conditions, s/he is considered "EFFECTIVE".
Please advise how I should fix this. Thanks much!
***************
PROC SQL NOEXEC;
4 SELECT t1.WeightedAvg_NCL,
5 t1.ApprovalRate,
6 t2.Standard_NCL,
7 t2.Standard_ApprovalRate,
8 /* DecisionEffectiveness */
9 (if WeightedAvg_NCL <= Standard_NCL and ApprovalRate >= Standard_ApprovalRate then de='effective';
_______________
22
76
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, (, *, **, +, -, '.', /, <, <=, <>, =, >, >=, AND, EQ, EQT,
GE, GET, GT, GTT, LE, LET, LT, LTT, NE, NET, OR, ^=, |, ||, ~=.
ERROR 76-322: Syntax error, statement will be ignored.
9 ) AS
_
180
ERROR 180-322: Statement is not valid or it is used out of proper order.