Some explicit pass-through code as below should do the job. Using DIS I'd implement this as a custom transformation for re-usability.
select put(seq_no,z16. -l) into :seq_no
from connection to ora
(
SELECT
ORACLE_SCHEME.MY_SEQUENCE.NEXTVAL as seq_no
FROM
DUAL
);
Register Today!
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.