I'm running SAS version 9.1.3 with Service Pack 4 on a Windows XP Professional platform. Here is my SAS Log below.
1981 proc sql noexec;
1982 create table prodlib.Loan_System_PCS_xref as
1983 select application_id, obligor, obligation
1984 from whse.afs_w_acaps_all as a LEFT JOIN prodlib.regH_suspects_newcolumns as b
1985 on a.application_id=b.application_id
1986 CASE when SCAN(obligor,1) gt ' '
----
22
76
ERROR 22-322: Syntax error, expecting one of the following: ;, !, !!, &, *, **, +, ',', -, /, <, <=, <>, =, >, >=, AND,
ANSIMISS, CROSS, EQ, EQT, EXCEPT, FULL, GE, GET, GROUP, GT, GTT, HAVING, INNER, INTERSECT, JOIN, LE, LEFT, LET,
LT, LTT, NATURAL, NE, NET, NOMISS, NOT, OR, ORDER, OUTER, RIGHT, UNION, WHERE, ^, ^=, |, ||, ~, ~=.
ERROR 76-322: Syntax error, statement will be ignored.
1987 then SYSTEM = "AFS_Level3"
1988 else SYSTEM = ' '
1989 end as SYSTEM;
1990 quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds