Incorrect results might occur when the following is true about an SQL query:

• A LIBNAME statement is used to access data located in a database management system (DBMS)
• The SELECT clause includes the creation of a new variable that is a constant value
• The SELECT clause includes a CASE expression that uses a function that is not passed down to the database
• The SELECT clause includes a summary function
• The GROUP BY clause is included

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_M3 is available at: