There is an undocumented option _method, which may give you some idea. Here is an example: proc sql _method; select distinct name, max(age) as maxAge from sashelp.class group by sex; quit; /* on log NOTE: The query requires remerging summary statistics back with the original data. NOTE: SQL execution methods chosen are: sqxslct sqxunqs sqxsumg sqxsort sqxsrc( SASHELP.CLASS ) */
... View more