A data scientist uses PROC FEDSQL in SAS Viya to query data across heterogeneous sources. What is the primary advantage of PROC FEDSQL over PROC SQL in a Viya environment?
Select an answer to reveal the explanation.
Short Explanation
Here's the deal — PROC FEDSQL gives you the SAS Viya federated SQL engine, so you can query CAS tables and multiple heterogeneous sources with ANSI SQL and distributed in-memory processing. It's the right fit because it's built for Viya's distributed data landscape.
Full Explanation
The correct advantage is that PROC FEDSQL uses the SAS Viya federated SQL engine to run ANSI SQL against CAS tables and multiple heterogeneous sources at once, using in-memory distributed processing. The macro-variable claim is wrong because both procedures support macro variables. The machine-learning variable-selection claim is wrong because FEDSQL is a query tool, not a feature-selection tool. The data-step compilation claim is wrong because FEDSQL does not transpile queries into data step code.