Usage Note 37651: Defining a database library in SAS® Enterprise Guide® 4.2 for availability when you connect to a local SAS session with SAS Enterprise Guide
When you connect to a local SAS session using SAS Enterprise Guide 4.2, the SAS Enterprise Guide repository is not available. Without this repository, you cannot create or store libraries via the New Library window in SAS Enterprise Guide.
Follow these steps to ensure that the library is available when you invoke SAS Enterprise Guide and connect to a local SAS session.
- Select Tools ► Options to display the Options dialog box.
- In the Options dialog box, select SAS Programs from the list in the left pane, as shown here:

- From the SAS Program window, select the check box Submit SAS code when server is connected and select the Edit radio button.
- Enter a LIBNAME statement similar to the following in the edit window:
libname ora oracle user=oracle-userid password=oracle-password path=alien;
- Click Save to exit the edit window.
- Click Apply and then OK to close the Options window.
Operating System and Release Information
SAS System | SAS Enterprise Guide | Microsoft® Windows® for x64 | 4.2 | | 9.2 TS2M0 | |
Microsoft Windows Server 2003 Datacenter Edition | 4.2 | | 9.2 TS2M0 | |
Microsoft Windows Server 2003 Enterprise Edition | 4.2 | | 9.2 TS2M0 | |
Microsoft Windows Server 2003 Standard Edition | 4.2 | | 9.2 TS2M0 | |
Microsoft Windows XP Professional | 4.2 | | 9.2 TS2M0 | |
Windows Vista | 4.2 | | 9.2 TS2M0 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Usage Note |
Priority: | |
Topic: | Data Management ==> Data Sources ==> External Databases ==> Oracle
|
Date Modified: | 2009-11-16 09:28:21 |
Date Created: | 2009-10-29 12:57:05 |