Version 7.1 Using Proc Sql from an oracle connection, I am unable to run code in SAS against a particular schema and only that schema in the DB. examples (excluding the PROC SQL and connection strings): Path text: libname temp "/sas_env/empl/sm/My_Name";
%let databasepath2="(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxxx)(PORT=xxxx))
(CONNECT_DATA=(SERVICE_NAME=xxxx)))"; Schema from path causing issue: Proc sql;
connect to oracle (user=xxxxx password='xxxxx' path=&databasepath2);
create table FCST as
select * from DM.items;
Quit; returns a Libref not assigned error DM is a legitimate schema name in the DB and works in every other query application I have schema from same path not causing issue: Proc sql;
connect to oracle (user=xxxxx password='xxxxx' path=&databasepath2);
create table FCST as
select * from APPS.Some_Other_Table_In_This_DB;
Quit; "APPS" is a schema from the same connection and this works fine Any way around this, or just an explanation of what's happening here would be appreciated.
... View more