SAS SQL DB2 pass-through eg select

The SAS-code below shows you how to make SQL pass-through to DB2 and collect the result in a new table.

proc sql noprint;

connect to db2 as db(database=<Your database> user=<Your username> password=<Your password>);
create table <Dummy> as
select * from connection to db
select * from <schema>.<table>
disconnect from db;

It is also possible to use authdomain to collect credentials instead of user and password and the DB2 database has to be available to SAS.

Leave a Reply

Your email address will not be published. Required fields are marked *