Hello, Would appreciate if someone can advise the cause of the error code pasted below as well thanks proc sql ; 222 create table Insttable_without_DupKey as 223 select DISTINCT(Reporting_INST_NAME), Reporting_INST_AT, Reporting_INST_AM, Reporting_FAC_NUM,FAC_NUM,INST_NAME2,INST_NAME,INST_AM, INST_AT, 224 Strokecentre2,Strokeunit2,TPA_IS,EVT1718_IS 225 group by Reporting_INST_NAME ----- 22 76 ERROR 22-322: Syntax error, expecting one of the following: a quoted string, !, !!, &, (, *, **, +, ',', -, '.', /, <, <=, <>, =, >, >=, ?, AND, AS, BETWEEN, CONTAINS, EQ, EQT, FORMAT, FROM, GE, GET, GT, GTT, IN, INFORMAT, INTO, IS, LABEL, LE, LEN, LENGTH, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, TRANSCODE, ^, ^=, |, ||, ~, ~=. ERROR 76-322: Syntax error, statement will be ignored. 226 having (Reporting_INST_NAME) = MAX(Reporting_INST_NAME) 227 AND Reporting_INST_AT = MAX(Reporting_INST_AT) 228 AND Reporting_INST_AM = MAX(Reporting_INST_AM) 229 AND Strokeunit2 = MAX(Strokeunit2) 230 ; 231 quit; proc sql ;
create table Insttable_without_DupKey as
select DISTINCT(Reporting_INST_NAME), Reporting_INST_AT, Reporting_INST_AM, Reporting_FAC_NUM,FAC_NUM,INST_NAME2,INST_NAME,INST_AM, INST_AT,
Strokecentre2,Strokeunit2,TPA_IS,EVT1718_IS
group by Reporting_INST_NAME
having (Reporting_INST_NAME) = MAX(Reporting_INST_NAME)
AND Reporting_INST_AT = MAX(Reporting_INST_AT)
AND Reporting_INST_AM = MAX(Reporting_INST_AM)
AND Strokeunit2 = MAX(Strokeunit2)
;
quit;
... View more