Desktop productivity for business analysts and programmers

Opening SAS library using Enterprise Guide

Reply
N/A
Posts: 0

Opening SAS library using Enterprise Guide

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
SAS Super FREQ
Posts: 8,721

Re: Opening SAS library using Enterprise Guide

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
N/A
Posts: 0

Re: Opening SAS library using Enterprise Guide

Thank you Cynthia, you're feedback is appreciated.
Ask a Question
Discussion stats
  • 2 replies
  • 105 views
  • 0 likes
  • 2 in conversation