You receive an empty result set after you query a SAS table or SAS view that was created from a database management system (DBMS) table.

The code example here for the query uses Oracle as the DBMS, but the code also applies to other DBMS systems.

After you run this code, you might see an error similar to the following in the SAS log: 

For this particular example, nine rows should have been returned, but no rows were generated.

This error happens under the following conditions:

• The SAS table or view is created from a DBMS table, using an explicit Structured Query Language (SQL) pass-through facility.  
• A column that is listed in the WHERE clause is not listed in the SELECT statement. 

To work around this issue, any column that is named in the WHERE clause must be included in the SELECT statement, as shown in this example:

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.4_M5 is available at:

A fix for this issue for Base SAS 9.4_M4 is available at: