I think I am getting close!! I forgot to mention it is a character variable. I made the change. But got another error message: 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 OPTION DEBUG=DBMS_SELECT SQL_IP_TRACE=(NOTE, SOURCE); 4 PROC SQL NOEXEC; 5 SELECT (CASE 6 WHEN t1.Think_About_Coll='0' then '0' 7 WHEN t1.Think_About_Coll='4' then '1' 8 WHEN t1.Think_About_Coll in ( '3' , '2' ) OR t1.Grade_Think_About_Coll in ( '1' , '2' ) then '2' 9 WHEN t1.Grade_Think_About_Coll in( '3' , '4' ) then = '3' _ 22 ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, BTRIM, INPUT, PUT, SUBSTRING, USER. 10 else '.' 11 end as Think_College) AS CALCULATION __ 22 76 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, ), *, **, +, -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN, CONTAINS, 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. 12 FROM WORK.SELECTION_RENAMING_RECODING t1; 13 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 0.00 seconds 14 %PUT SQL_IPTRACE_RESULT=&SYS_SQL_IP_ALL; SQL_IPTRACE_RESULT=-1 15 OPTIONS SQL_IP_TRACE=(NONE); 16 QUIT; RUN;
... View more
