SAS Bigdata loading -Using the SAS/ACCESS® LIBNAME Engine - how Proc sort works

[Ponvani]

I m in the ch4 -Using the SAS/ACCESS® LIBNAME Engine under sorting and reporting.

I saw an example where the sorting in the proc sort step occurs in Hive itself using order by. Does this happens for other Databases also? i.e. instead of hive table can I do the same for oracle or teradata? will the Access engine support for other Database to sort inside the respective DB's. 

[RW9]

For databases, code can be sent to the database SQL parser for processing - it is called pass-through - and then the SQL is compiled and executed in the database.

[LinusH]

This is described in the SAS/ACCESS documentation, please dig in there.

In short, most ACCESS interfaces with relational data source support push down (or implicit SQL pass through) of joins, order by, BY, group by, WHERE and a selection of functions. There are also a couple of SAS PROCs that have been pass through enabled, such as FREQ and SUMMARY.