The FedSQL Procedure
A Brief Overview
SAS FedSQL is a SAS
proprietary implementation of ANSI SQL:1999 core standard. It provides
support for new data types and other ANSI 1999 core compliance features
and proprietary extensions.
At the highest level,
FedSQL provides a common ANSI SQL syntax across all data sources.
FedSQL is a vendor-neutral SQL dialect that accesses data from various
data sources without having to submit queries in the SQL dialect that
is specific to the data source (or DBMS). An ANSI standard SQL allows
for as much processing to be pushed into a DBMS as possible.
FedSQL is not a replacement for PROC SQL. On the contrary, both are tools that are used for specific scenarios. They offer different strengths for different situations. ...
Get SAS Certified Professional Prep Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
