In Base SAS^® software, a query being passed to a database might not include an ORDER BY clause when you run an SQL procedure query and the following conditions exist:

• You create a view that selects a variable and the sum of a second variable where the results are grouped by the first variable.
• You run a query that references that view and selects both variables, renames the variable that was used in the GROUP BY clause, and sorts by the variable that was used in the GROUP BY clause.

For example, you might encounter this issue if you ran code similar to the following:

Instead, SAS retrieves the results and does the sorting. 

The workaround is to rename the column as a data set option on the table in the CREATE TABLE statement instead of renaming via the SELECT clause.

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:

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