Thanks, but I will try to better articulate my problem here with code. I apologize but I am a beginner SAS developer: Following is the simple SAS CODE: libname datadir "~/data"; proc sql; connect to vertica as vmart ( server="&rmtsrv" port=5433 database=verpoc user="&rmtuser" password="&rmtpw" INSERT_SQL=YES ); create table datadir.apptest as select * from connection to vmart (select * from poc.apptest where extract (year from dttm_val) > 1582 limit 100); disconnect from vmart; ***The above code created a sas dataset called apptest.sas7bdat in the data directory. ***I would now like to insert 2 columns from the apptest.sas7bdat into a new testsas table in the database. proc sql; connect to vertica as vmart ( server="&rmtsrv" port=5433 database=verpoc user="&rmtuser" password="&rmtpw" INSERT_SQL=YES ); select * from connection to vmart (insert into poc.testsas select id_evnt,id_apptest from datadir.apptest); I know I cannot do what is highlighted in red because it executes on Vertica and that datadir.apptest is not valid. I would like to know how I can Read rows from apptest.sas7bdat and insert them into Vertica and potentially insert the full sas apptest.sas7bdat dataset, after manipulation, back into Vertica. What is the right SQL pass-through syntax or alternative way to run the insert? Is there any bulk insert supported from the script? Thanks.
... View more