CAS vs. Compute Server: Where Should You Run Your FedSQL Code in SAS Viya

This code is also available in:

Expert Advice

Michael
Responsable de l'infrastructure Viya.

Views are excellent for single-pass usage or ad-hoc queries. However, if you plan to analyze the same data multiple times in a session (e.g., running 10 different statistical procedures on it), it is usually more efficient to copy it to a physical table once to avoid re-querying the database repeatedly.

Stop replicating data unnecessarily—use SAS Views for real-time efficiency.

FedSQL on the SAS^© Viya^™ platform supports new data types and proprietary extensions, optimizing queries with multi-threaded algorithms for large-scale operations. It can be submitted via the SAS^© Compute Server or the CAS Server. With the Compute Server, FedSQL supports the same statements as in SAS^© 9.4 and uses PROC FEDSQL to access data via SAS^© libraries. On the CAS Server, only CREATE TABLE (with AS expression), SELECT, and DROP TABLE are supported, with full implicit SQL pass-through support and limited explicit pass-through via the CONNECTION TO component. Data processed on the CAS Server uses CAS data types.

CAS vs. Compute Server: Where Should You Run Your FedSQL Code in SAS Viya

Expert Advice

Stop replicating data unnecessarily—use SAS Views for real-time efficiency.

Beyond the WORK Library: Mastering the 4 Default SAS Libraries You Must Know

Combine and Conquer: Mixing Physical Paths and Existing Librefs in One LIBNAME Statement

Stop Importing, Start Connecting: A Master Class in SAS/ACCESS Engines and SQL Pass-Through

Stop Wasting CPU: How to Use the SAS SORTEDBY= Option to 'Fake' a Sort

SAS Viya Essentials: How to Read, Write, and Persist In-Memory CAS Tables

Don't Lose Your Data: How to Prevent Truncation When Migrating SAS Libraries to UTF-8

Skip the Libname: A Guide to Direct File Access and Path References in SAS

Dynamic Data Access: How to Automate Librefs with Macros and DLCREATEDIR

Unlocking ADLS Gen2: The Secret to Reading Distributed ORC Tables with SAS

Go Cloud-Native: How to Convert and Upload SAS Data to Parquet on Google Cloud

Related Documentation

The Big Four: Decoding the Differences Between Work, User, Sashelp, and Sasuser

Beyond Physical Files: Unlocking the Logical Power of the SAS Dataset Mode

Beyond the Basics: Mastering SAS Data Access Models and Record-Level Locking

SAS Table Structure: Optimize Your Metadata and Sorting (V9/SPD)