Using a PROC SQL View might produce the error "Libref X is not assigned."

The error occurs when all of the following are true:

• the PROC SQL view was defined with the USING LIBNAME syntax
• the underlying SAS table is indexed
• the index is selected for use by PROC SQL
• the same LIBNAME statement used within the SQL view is not assigned when the view is used
• the option MSGLEVEL=I is used

The error does not set the automatic macro variables &SQLRC, &SYSRC, &SYSERR to nonzero values and does not stop the step from executing.

If the option MSGLEVEL=I is not used, the error is not written to the SAS Log.