Hi I'm trying to straighten out some faulty data with the Data Validation transformation in my ETL process. I'm using the CASE expression to achieve this. My expression: CASE WHEN Discount < 0 THEN (Discount * (-1)) ELSE Discount END This syntax seems to work in the SAS Enterprise Guide but it throws an error in my transformation. Error: 2065 x_custom_rule = ""; output etls_Exceptions; Discount = CASE WHEN Discount 2065 ! < 0 THEN (Discount * (-1)) ELSE Discount END; end; if error_rows=0 then do; ____ 22 ERROR 388-185: Expecting an arithmetic operator. ERROR 202-322: The option or parameter is not recognized and will be ignored. ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, ;, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT, LE, LT, MAX, MIN, NE, NG, NL, OR, ^=, |, ||, ~=. I'm really confused about this problem. I'm using SAS Integration Studio 4.8 Cheers
... View more