Thank you for the response. I am familiar with the SAS/ACCESS way of doing it. But my problem was the first column in the oracle table is a sequence generated ID. Is there a way of inserting data into ORACLE using SAS/ACCESS way where the first column is a sequence generated by oracle and the rest of the columns are from a sas data set? Updated version of my syntax is as below proc sql; connect to oracle(user=xxxxx password=xxxxx path=xxxxx); execute( insert into oracletable (ID, col1) select * schema.nextval from dual, select col1 from sas dataset ) by oracle; disconnect from oracle; quit;
... View more