In Base SAS^® software, incorrect results might occur when you run an SQL procedure query when the following conditions exist:

• An SQL view is created from a DBMS table that is being accessed with a LIBNAME engine statement. The query to create the SQL view contains a function that is not passed down to the database.
• A second SQL view is created that is a query of the first view. The query to create the second SQL view contains the DISTINCT argument and an ORDER BY clause, and it creates a new variable that is a constant value.
• You have submitted an SQL query referencing the second view, where the query contains the COUNT summary function, and the argument to the function is the name of the constant variable that was created in the second view.

To work around this issue, either change the query such that one of the above conditions is not present, or create SAS data sets rather than SQL views.

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: