When you set SQLGENERATION=DBMS, the SORT and RANK procedures fail to push down with SAS/ACCESS Interface to Spark. When you encounter this issue, the procedure still runs, but it falls back to a standard execution. 

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

Note that several other minor issues with Databricks Spark are addressed by this hot fix. 

Operating System and Release Information

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

A fix for this issue for SAS/ACCESS Interface to Hadoop 9.47 is available at:

A fix for this issue for SAS/ACCESS Interface to JDBC 9.41 is available at:

A fix for this issue for SAS Threaded Kernel DS2 and FedSQL Language Processors 9.41_M5 is available at:

A fix for this issue for SAS Threaded Kernel Extension for Hadoop Hive 9.47 is available at:

A fix for this issue for SAS/ACCESS Interface to Spark 9.4 is available at:

A fix for this issue for SAS Threaded Kernel Extension for Spark 9.4 is available at: