https://communities.sas.com/t5/SAS-Enterprise-Guide/Opening-SAS-library-using-Enterprise-Guide/m-p/3727#M1200 Hello,<BR /> <BR /> 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?<BR /> <BR /> Jam2007 Wed, 04 Jul 2007 14:42:03 GMT deleted_user 2007-07-04T14:42:03Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Opening-SAS-library-using-Enterprise-Guide/m-p/3727#M1200 Hello,<BR /> <BR /> 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?<BR /> <BR /> Jam2007 Wed, 04 Jul 2007 14:42:03 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Opening-SAS-library-using-Enterprise-Guide/m-p/3727#M1200 deleted_user 2007-07-04T14:42:03Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Opening-SAS-library-using-Enterprise-Guide/m-p/3728#M1201 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).<BR /> <BR /> 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.<BR /> [pre]<BR /> libname myoralib oracle user="robert" password="mypswd" path="thepath" ;<BR /> [/pre]<BR /> Subsequent references to your table would then be<BR /> [pre]<BR /> data=myoralib.mytable<BR /> [/pre]<BR /> <BR /> 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.<BR /> <BR /> I suggest that you contact Tech Support for the correct answer considering your particular configuration and installation setup.<BR /> <BR /> cynthia Wed, 04 Jul 2007 18:24:52 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Opening-SAS-library-using-Enterprise-Guide/m-p/3728#M1201 Cynthia_sas 2007-07-04T18:24:52Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Opening-SAS-library-using-Enterprise-Guide/m-p/3729#M1202 Thank you Cynthia, you're feedback is appreciated. Thu, 05 Jul 2007 11:54:09 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Opening-SAS-library-using-Enterprise-Guide/m-p/3729#M1202 deleted_user 2007-07-05T11:54:09Z