When you create a SAS Scalable Performance Data Server table for which the query includes an ORDER BY clause, the ORDER BY clause might not be included in the query that is passed to the SAS Scalable Performance Data Server for processing. As a result, the rows in the table are not in sorted order, which might affect performance.

To work around this issue, use explicit pass-through processing.

Operating System and Release Information

A fix for this issue for Base SAS 9.21_M3 is available at: