proc sql pass through facility in SAS

Question

I am trying to connect to the Oracle database and facing a problem at the select statement of Sql in SAS here is the code I wrote.

libname oral oracle path='jumbo' schema='AAA';
proc sql;
connect using oral;
create table ght as 
select * from connection to oral
(select * from  bo_gut);
disconnect from oral;
quit;

and now I am getting an error saying

ERROR: ORACLE prepare error:ORA-00942:table or view does not exist

what can be the problem, the the schema that I am using has this table "bo_gut" but still not able to create a new table from it.

DomPazz DomPazz · Accepted Answer · 2015-03-20T12:11:25

Just use your library (and this will query faster if the table is large).

libname oral oracle path='jumbo' schema='AAA';
proc sql;
create table ght as
select * from oral.bo_gut;
quit;

If you still get that error, then make sure the table actually exists and SAS can see it.

This will print everything SAS can see in a library to the LOG.

proc datasets lib=oral memtype=all;
quit;

If you cannot see the table, then check your Oracle permissions.

proc sql pass through facility in SAS

2 Answers