Still getting an error even with your modification 27 proc sql; 28 create table temp as 29 select contract_number, sum(enrollment) as parent_enrol, 30 case when calculated parent_enrol lt 50000 then 1 31 else when calculated parent_enrol le 200000 then 2 __________ 22 76 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, (, *, **, +, -, '.', /, <, <=, <>, =, >, >=, ?, AND, BETWEEN, CONTAINS, END, EQ, EQT, GE, GET, GT, GTT, IN, IS, LE, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, ^, ^=, |, ||, ~, ~=. ERROR 76-322: Syntax error, statement will be ignored. 32 else when calculated parent_enrol gt 200000 then 3 33 else 4 34 end as parent_size 35 from D107342.AP15747022_Master 36 group by contract_number; NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 37 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time
... View more