A colleague tried this out. This syntax worked. Please make sure that SQL server database database is created with ANSI enabled.
52 options validvarname=any; 53 libname ora oracle uid=USER pwd=XXXXXX path=mypath preserve_names=yes; NOTE: Libref ORA was successfully assigned as follows: Engine: ORACLE Physical Name: mypath 54 libname sql odbc uid=USER pwd=XXXXXX dsn=dsnname preserve_names=yes; NOTE: Libref SQL was successfully assigned as follows: Engine: ODBC Physical Name: dsnname
55 proc sql dquote=ansi; 56 insert into sql.blank_test("ID NUM"n, "SALARY"n, "BEG DATE"n, "END DATE"n, "JOB CODE"n) 57 select IDNUM, SALARY, BEGDATE, ENDDATE, JOBCODE from ora.SALARY; NOTE: 319 rows were inserted into SQL."blank_test".
58 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.41 seconds cpu time 0.01 seconds
59 proc sql; 60 select count(*) from sql.blank_test; 61 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.08 seconds cpu time 0.04 seconds
... View more