I have the following code with me:
proc sql; create Table _final_ as select final_slot, calc_client_slot, CASE when final_slot = calc_client_slot then 0 else 1 end as flag_ from app_port; quit;
but when I run it, it shows error. Here is the log:
675 proc sql;
676 create Table _final_ as
677 select final_slot, calc_client_slot, CASE
678 when final_slot = calc_client_slot then 0
--
22
76
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, <, <=, <>, =, >, >=, ?, AND, CONTAINS, EQ,
EQT, GE, GET, GT, GTT, LE, LET, LIKE, LT, LTT, NE, NET, OR, ^=, |, ||, ~=.
ERROR 76-322: Syntax error, statement will be ignored.
679 else 1
680 end as flag_
681 from app_port;
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
682 quit;
NOTE: The SAS System stopped processing this step because of errors.
Help would be appreciated. Thank you.
... View more