If you try to access an SQL view in a PROC or DATA step using a libref that was allocated with the META Libname engine, the following error occurs and the SAS session becomes unresponsive:

This problem occurs only if the SQL view was created with the USING clause to embed a LIBNAME in the view definition. For example, suppose you defined the following view from the table INVALID_MEMPTR_TEST, and imported the view into metadata:

The error occurs when you allocate a library using the META engine and attempt to read the view. For example:

As a circumvention to the error, either remove the USING clause from the view definition, or allocate the library with the appropriate SAS or DBMS engine rather than the META engine.

See SAS Note 36636 "'ERROR: Invalid memptr' occurs when accessing an SQL view defined with an embedded libname using the META engine" for a related problem.

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

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :