PROC FEDSQL is used to query across a CAS in-memory table and an ex…

Question

PROC FEDSQL is used to query across a CAS in-memory table and an external RDBMS table simultaneously. Which characteristic distinguishes PROC FEDSQL from PROC SQL in this federated scenario?

Accepted Answer

PROC FEDSQL uses ANSI SQL-92 syntax and can push query predicates down to remote data sources for optimization, whereas PROC SQL processes all data locally after pulling it into SAS memory — Here's the deal — a is correct because PROC FEDSQL is SAS Viya's ANSI SQL-92 federated query engine that can execute queries across CAS tables and external data sources, with the ability to push predicates (WHERE conditions, aggregations) down to the remote source to minimize data movement. PROC SQL pulls all data into SAS memory first.

Answer

PROC FEDSQL can only query two data sources simultaneously; PROC SQL can handle unlimited sources

Answer

PROC FEDSQL requires SAS/ACCESS licenses to work with RDBMS sources; PROC SQL can connect to any ODBC source without licensing

Answer

PROC FEDSQL produces identical output to PROC SQL but runs 10x faster on CAS tables by default

PROC FEDSQL is used to query across a CAS in-memory table and an external RDBMS table simultaneously. Which characteristic distinguishes PROC FEDSQL from PROC SQL in this federated scenario?

Short Explanation and Infographic

Full Explanation