I don't know why line 9 of the original posting is differnt once posted. In my code to use the characters to represent "greater than or Equal to" and "less than or equal to" - I don't spell it out in my codes. I just don't know why this forum deletes them from my codes below.
Here is what I would like for SAS EG to return one of the three performance:
*if WeightedAvg_NCL Less Than or Equal to Standard_NCL and ApprovalRate Greater Than or Equal to Standard_ApprovalRate then de='effective';
*if WeightedAvg_NCL > Standard_NCL and ApprovalRate < Standard_ApprovalRate then de='ineffective';
*if WeightedAvg_NCL = Standard_NCL and ApprovalRate = Standard_ApprovalRate then de='meet'
Thanks again!
****************
3 PROC SQL NOEXEC;
4 SELECT t1.WeightedAvg_NCL,
5 t1.ApprovalRate,
6 t2.Standard_NCL,
7 t2.Standard_ApprovalRate,
8 /* Decision Effectivness */
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 if
__
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
10 WeightedAvg_NCL > Standard_NCL and ApprovalRate < Standard_ApprovalRate then de='ineffective';
10 ! ) AS
_
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
... View more