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 and Infographic
Here's the deal — b is correct because when PROC SQL references tables through a CAS library, SAS Viya can push query processing to CAS for distributed in-memory execution. A is wrong; CAS tables are not necessarily materialized to SAS work.
Full explanation below image
Full Explanation
B is correct because when PROC SQL references tables through a CAS library, SAS Viya can push query processing to CAS for distributed in-memory execution. A is wrong; CAS tables are not necessarily materialized to SAS work. C is wrong; SAS/ACCESS is for external database connectivity, not CAS. D is wrong; PROC FEDSQL is separate from PROC SQL.