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 SAS
ODBC 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.