With this SAS Program you are able to connect to a database with SQL Pass Through via ODBC. The advantage is, that the SQL Statement will be processed by the resources of the database. The disadvantage is, that you cannot use SAS specific functions which are not supported by the database sql language.
—
proc sql;
connect to odbc (dsn=“…“ user=“…“ password=“*****“);
create table my_table as
select * from connection to odbc
(
select
…
from
…
where
…
);
disconnect from odbc;
quit;