A table in the Metadata Library Engine (MLE) library might not close after you access it with an SQL view. This problem can occur under the following circumstances:

• You have a data table in an MLE library.
• You use an SQL view in that library or in another MLE library to read the data table.

If you use any SAS DATA or PROC step to read from the SQL view, the data table does not close properly. In addition, if you use a subsequent step to replace the underlying data table, the following error might be generated:

This problem can also occur in situations where the number of observations or matches are written out in a final PROC SQL step. A small number of observations that are written might not produce the error. However, increased numbers of observations can produce an error similar to the following:

To circumvent this problem:

1. De-assign the MLE library before you run the PROC SQL step.
   

   Note: The metadata security is bypassed when the MLE library is de-assigned.

2. Re-assign the MLE library after you run the PROC SQL step.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for Base SAS 9.3_M2 is available at:

A fix for this issue for Base SAS 9.3_M1 is available at: