A data scientist uses PROC FEDSQL in SAS Viya to query data across…

Question

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?

Accepted Answer

PROC FEDSQL can query CAS tables and federated data sources using a distributed SQL engine — Here's the deal — b is correct because PROC FEDSQL leverages the SAS Viya federated SQL engine to run ANSI SQL against CAS tables and multiple heterogeneous data sources simultaneously, taking advantage of in-memory distributed processing. A is wrong because both procedures support macro variables.

Answer

PROC FEDSQL supports SAS macro variables natively while PROC SQL does not

Answer

PROC FEDSQL automatically performs variable selection for machine learning models

Answer

PROC FEDSQL compiles queries into SAS data step code for better performance

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?

Short Explanation and Infographic

Full Explanation