Hi, I am still getting the same error. Please help Below is the complete log 81 libname mydblib oracle user=ABCD password=A12345 path=msrprod2 schema=MCA; NOTE: Libref MYDBLIB was successfully assigned as follows: Engine: ORACLE Physical Name: msrprod2 82 proc sql; 83 create table brand as 84 select PROD,IND_ID from ( 85 select 'DR' as PROD,IND_ID AS IND_ID --------- 22 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, AS, CONTAINS, EQ, EQT, FROM, GE, GET, GT, GTT, LE, LET, LIKE, LT, LTT, NE, NET, OR, ^=, |, ||, ~=. 86 FROM UNIC.DR ---- 22 76 ERROR 22-322: Syntax error, expecting one of the following: a name, (, ), ',', '.', ANSIMISS, AS, CROSS, EXCEPT, FULL, GROUP, HAVING, INNER, INTERSECT, JOIN, LEFT, NATURAL, NOMISS, OUTER, RIGHT, UNION, WHERE. ERROR 76-322: Syntax error, statement will be ignored. 87 UNION 88 select 'HF' PROD_ABBR,INDIVIDUAL_ID_ID 89 FROM UNICARUNUS.HF 90 UNION 91 select 'ROH' PROD_ABBR,INDIVIDUAL_ID_ID 92 FROM UNICARUNUS.ROH 93 UNION 94 select 'NBB' PROD_ABBR,INDIVIDUAL_ID_ID 95 FROM UNICARUNUS.NBB 96 UNION 97 select 'EMR' PROD_ABBR,INDIVIDUAL_ID_ID 98 FROM UNICARUNUS.EMR); 99 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.03 seconds cpu time 0.03 seconds
... View more