SAS Tech Support provided the answer: Note: That if you're using another Oracle schema's sequence, you need to add it as follows. '{Schema Name Here}.TEST_SEQ.NEXTVAL' Here is an example: DATA TEST_IMPORT; INPUT LOC_NM $; DATALINES; EIN BVN TST RUN; *NWDWLIB is a macro variable with the string of connecting to one of our Oracle DBs; LIBNAME &NWDWLIB; PROC SQL; INSERT INTO NWDWLIB.TEST_LOC (OR_IDENTITY_COLS=(DW_TEST_LOC_ID='TEST_SEQ.NEXTVAL'),DW_TEST_LOC_ID,LOC_NM) SELECT ., LOC_NM FROM WORK.TEST_IMPORT; QUIT; LIBNAME NWDWLIB CLEAR;
... View more
