By default, every SAS session (including
SAS server sessions) provides access to the SAS libraries Maps, Sasuser,
and Sashelp. These libraries contain sample data sets and other files
that are generally not of interest to ODBC users. Therefore, the driver
does not report the contents of these libraries when it invokes a
SAS ODBC server. (From a programming standpoint, when SQLTables, SQLStatistics,
or SQLColumns is called, the result set that is returned does not
include rows for the SAS libraries Maps, Sasuser, or Sashelp.) If
you want information from these libraries, you can do either of the
following tasks:
-
Use a LIBNAME statement to define
the SAS library to the SAS ODBC server.
-
Use the
SAS ODBC Driver
Configuration dialog box to define the SAS library to
your ODBC applications.
In both cases, you must
use a different name (that is, not Maps, Sasuser, or Sashelp) as your
libref or library name.