I'm a complete newbie to Enterprise Guide, and I'm trying to access my SAS library but to no avail. My library engine is oracle based. Can someone offer a few pointers or make some suggestions on how I can do this?
Hi...well, it depends on whether you have a "standalone" EG install and are using SAS on a server or whether you are working within the confines of the Enterprise Intelligence Platform (where all data access is controlled through the Metadata Server).
Generally speaking, the LIBNAME statement has a way to point to an Oracle table and thus, allow you to treat the table as a SAS data set.
libname myoralib oracle user="robert" password="mypswd" path="thepath" ;
Subsequent references to your table would then be
However, the answer really is more involved than just issuing a LIBNAME statement -- your SAS administrator may need to ensure that you have the appropriate SAS/Access product for Oracle and make sure that you have the correct access privileges to the tables.
I suggest that you contact Tech Support for the correct answer considering your particular configuration and installation setup.