An easy way to associate a
libref with a relational DBMS is to use the New Library
One method to open this window is to issue the DMLIBASSIGN command
from your SAS session's command box or command line. You can also
open the window by clicking the file cabinet icon in the SAS Explorer
toolbar. Below, the user Samantha assigns a libref MYORADB to an Oracle
database that the SQL*Net alias ORAHRDEPT references. By using the
SCHEMA= LIBNAME option, Samantha can access database objects that
another user owns.
Here is how to use the
features of the New Library
enter the libref that you want to assign to a SAS library or a relational
click the down arrow to select a name from the pull-down listing.
Enable at startup
click this if you want the specified libref to be assigned automatically
when you open a SAS session.
these fields represent the SAS/ACCESS
connection options and vary
according to the SAS/ACCESS
engine that you specify. Enter the appropriate
information for your site's DBMS. The
lets you enter SAS/ACCESS
LIBNAME options. Use blanks to separate
this button to assign the libref, or click Cancel
exit the window without assigning a libref.