Microsoft SQL Server tables do not show up in the SAS Explorer Window for a new library after you use a database management system (DBMS) engine to assign a libref, as shown in the following LIBNAME statements:

To resolve this problem, add the option SCHEMA=DBO to the LIBNAME statement, as shown in the following example:

When you submit the LIBNAME statements with SCHEMA=DBO, the SQL Server tables will then be visible in the SAS Explorer window.

Operating System and Release Information