I tried this command proc sql ; create table want1 case when ttg < 4.5 then LDL_nw2 = TC - ((HDL)+(Ttg/5)) else . from have1 end as ldl_nw2 ; quit; it says: 15 proc sql ; 16 create table want1 as 17 case when ttg < 4.5 then LDL_nw2 = TC - ((HDL)+(Ttg/5)) ---- ---- 22 76 202 ERROR 22-322: Syntax error, expecting one of the following: (, SELECT. ERROR 76-322: Syntax error, statement will be ignored. ERROR 202-322: The option or parameter is not recognized and will be ignored. 17 ! case when ttg < 4.5 then LDL_nw2 = TC - ((HDL)+(Ttg/5)) ---- 22 ERROR 22-322: Syntax error, expecting one of the following: a quoted string, !, !!, &, *, **, +, ',', -, /, <, <=, <>, =, >, >=, AND, AS, EQ, EQT, FORMAT, FROM, GE, GET, GT, GTT, INFORMAT, INTO, LABEL, LE, LEN, LENGTH, LET, LT, LTT, NE, NET, NOT, OR, TRANSCODE, ^, ^=, |, ||, ~, ~=. 18 else . 19 from have1 20 end as ldl_nw2 ; 21 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.06 seconds cpu time 0.01 seconds Kindly suggest
... View more