Chapter Contents

Previous

Next

Assigning a Libref Interactively

One of the easiest ways to associate a libref with a relational DBMS or SAS data library is to use the New Library window. To open this window, issue the LIBASSIGN command from your SAS session's command box or command line. In New Library Window, the user Samantha assigns a libref MYORADB to an ORACLE database referred to by the SQL*Net alias ORAHRDEPT. The LIBNAME option, SCHEMA=RFCDEPT, enables the user Samantha to access database objects that are owned by another user.

New Library Window

The following list describes how to use the New Library window:

• Name: enter the libref that you want to assign to a SAS data library or a relational DBMS.

• Engine: enter the name of your SAS engine or SAS/ACCESS engine for your relational DBMS. Or, click the down arrow to select a name from the pull-down listing.

• Enable at startup: click on 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 engine-connection options and vary according to SAS/ACCESS engine that you specify. Enter the appropriate information for your site's DBMS. The Options field enables you to enter SAS/ACCESS LIBNAME options. Use blanks to separate multiple options.

• [OK]: click on this button to assign the libref, or click on [Cancel] to exit the window without assigning a libref.

Chapter Contents

Previous

Next

Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.