Under certain conditions, SQL procedure queries that contain the DISTINCT keyword do not generate output with unique rows as expected.

Typically, to encounter the problem, you must run a pair of queries that meet the following conditions:
 

• The first query uses CREATE VIEW syntax to create a view to a SAS data set and uses the DISTINCT keyword in the SELECT clause. If you use CREATE TABLE syntax, you do not encounter a problem.
   
• The first query that creates the view also needs to create a column that contains a constant value.
   
• The second query that generates the output data set needs to contain a non-summary function or a calculation such as the ROUND() or ABS() functions. If a function is not used, but is replaced with a calculation on a numeric variable, the problem also occurs. Ultimately, the issue appears when a numeric manipulation of the data occurs with a function or a calculation.

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