Could you please direct me where the error originated or how to resolve the error! Thanks Shakhane 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 proc sql; 74 create table work.weston_milling_sas 75 as 76 select intake.name, intake.xlsx.sap code, warehouse.xlsx.sap code _ 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. 77 from weston_milling_sas.intake.xlsx intake.xlsx 78 inner join westin_milling_sas.warehouse.xlsx warehouse.xlsx 79 from unknown table string null unknown table string 80 on; NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 81 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.01 seconds 82 83 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
... View more