The LIBNAME Statement for Relational Databases

Assigning a Libref Interactively

An easy way to associate a libref with a relational DBMS is to use the New Library window. 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. In the following display, 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.

New Library Window

[New Library Window]

Here is to use the features of the New Library window.

Name : enter the libref that you want to assign to a SAS library or a relational DBMS.
Engine : 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.
Library Information : 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 Options field lets you enter SAS/ACCESS LIBNAME options. Use blanks to separate multiple options.
OK: click this button to assign the libref, or click Cancel to exit the window without assigning a libref.

Top of Page