Opening SAS library using Enterprise Guide

[deleted_user]

Hello,

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?

Jam2007

[Cynthia_sas]

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.
[pre]
libname myoralib oracle user="robert" password="mypswd" path="thepath" ;
[/pre]
Subsequent references to your table would then be
[pre]
data=myoralib.mytable
[/pre]

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.

cynthia

[deleted_user]

Thank you Cynthia, you're feedback is appreciated.