I am trying to run the following code and I am running into this error: proc sql;
create table data_new as select *,
case when a is not null then 500
else when b>=60 and c=0 then 400
else when d <6 and Days_Arrears>e then 300
else when d <6 and Days_Arrears>e then 200
else when d <6 and Days_Arrears=e then 100
else when f = 'available' then 50
else f = 'vacant' then 25
else 0 end as Points
from data_old;
quit; Error: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
72
73 proc sql;
74
75 create table data_new as select *,
76
77 case when a is not null then 500
78
79 else when b>=60 and c=0 then 400
____________
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.
... View more