Hi Ram, If you are using SAS 9.4, you can do this with the the DBIDIRECTEXEC system option. This code uses ACCESS to PostgreSQL. It is worth noting that the explicit pass-thru method gives you more control and may be preferable, but this does work. I ran this with SAS 9.4M2. libname mypg postgres server=localhost database=mydb user=myuser pw=mypasswd; proc sql; create table mypg.cars as select * from sashelp.cars; quit; options dbidirectexec sastrace=',,,d' sastraceloc=saslog nostsuffix; /*create the view */ proc sql; create view mypg.jeeps as select * from mypg.cars where make='Jeep'; quit; /* see if it worked. It should return 3 */ proc sql; select count(*) from mypg.jeeps; quit;
... View more
