When PROC SQL references tables in a CAS library via a CAS libref in SAS Viya, where does SQL execution typically occur?
Select an answer to reveal the explanation.
Short Explanation
Here's the deal — when PROC SQL references tables through a CAS library, SAS Viya can push query processing to CAS for distributed in-memory execution. You don't have to bring both CAS tables into SAS work first.
Full Explanation
PROC SQL pushes the query to the CAS engine for in-memory distributed execution when tables are referenced through a CAS library. The SAS compute engine materializing both CAS tables to SAS work is wrong because CAS tables are not necessarily materialized to SAS work. SAS/ACCESS translating to a database SQL dialect is wrong because SAS/ACCESS is for external database connectivity, not CAS. PROC FEDSQL automatically intercepting the query is wrong because PROC FEDSQL is separate from PROC SQL.