In SAS^® 9.1.3, performance problems can occur when you use an ORDER BY clause in PROC SQL. More Read and Write cycles occur in PROC SQL with an ORDER BY clause than occur when you use a DATA step and the SORT procedure to accomplish the same task.

Select the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

/* to invoke the feature */ 

  %let sys_sqldirectsort = 1; 

/* to disable the feature */ 

  %let sys_sqldirectsort = 0; 

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at: