The following error started when I added lines 40, 41. 26 proc sql; 27 connect to odbc as myodbc (user=iuser password=XXXXXXXX dsn=idsname insertbuff = 10000); 28 create table SSQL.TEMP as 29 SELECT DISTINCT 30 VAR1, 31 VAR2, 32 VAR3 33 FROM SASLIB.sASDATASET 34 WHERE VAR2 IN('H','L') AND VAR1 IS NOT MISSING; NOTE: SAS variable labels, formats, and lengths are not written to DBMS tables. NOTE: SAS threaded sort was used. NOTE: Table SSQL.TEMP created, with 215 rows and 3 columns. 35 execute ( 36 merge into MASTER_TBL a 37 using TEMP b 38 on (a.VAR1=b.VAR1 39 and a.VAR2=b.VAR2) 40 when not matched by MASTER_TBL 41 then insert(VAR1, VAR2, VAR3) values(B.VAR1, B.VAR2, B.VAR3) 42 when matched then update 43 set a.VAR3=b.VAR3; 44 ) by myodbc; ERROR: CLI execute error: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near 'MASTER_TBL'. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 45 execute (drop table TEMP) by myodbc; NOTE: Statement not executed due to NOEXEC option. 46 disconnect from myodbc; NOTE: Statement not executed due to NOEXEC option. 47 quit; NOTE: The SAS System stopped processing this step because of errors.
... View more