the query is passed through the SAS server to the SAS SQL processor, which processes each row of the table and returns only the summary rows to your local SAS session. You can also use RSPT to join ...