The Complete Guide to FedSQL on SAS Viya

Scalable SQL Solutions for Modern Data Processing

Discover how FedSQL provides a vendor-neutral SQL dialect for your SAS Viya projects. This resource hub covers everything from basic syntax to advanced MPP execution. Master the art of writing portable code that runs seamlessly across different data sources while taking advantage of SAS Cloud Analytic Services (CAS). Move beyond traditional PROC SQL and embrace the next generation of data manipulation.

Featured Selection

Explore our most popular thematic folders. Or check out our Knowledge Hub

Data Step
Fedsql
Guide SAS VIYA
SAS9
Topics
Administration SAS9 1 CAS 13 Configuration Viya4 1 Data Step 8 Database 7 Fedsql 8 Guide SAS VIYA 4 Installation SAS9 1 macro SAS9 2 ODS 1 Proc SQL 4 SAS Mainframe 1 SAS VIYA Guide 13 SAS Viya Programming Guide 1 SAS9 31 SAS9 Administration 1 Troubleshooting 5
Fedsql
Advanced Tutorial: Manipulating Native JSON in SAS Viya with FedSQL
22/12/2024
Advanced Tutorial: Manipulating Native JSON in SAS Viya with FedSQL

In the SAS Viya environment, the FedSQL language is the standard for interacting with data. While...

Lire
Fedsql
SAS Viya Tutorial: Pre-process Data in the Database Before CAS Loading
22/09/2024
SAS Viya Tutorial: Pre-process Data in the Database Before CAS Loading

In the SAS Viya architecture, the standard data lifecycle often involves copying tables from a so...

Lire
Fedsql
SAS Viya Optimization: Mastering Implicit Pass-Through with FedSQL
22/12/2023
SAS Viya Optimization: Mastering Implicit Pass-Through with FedSQL

In the classic SAS ecosystem (v9), the concept of SQL Pass-Through (implicit or explicit) is well...

Lire
Fedsql
SAS and SQL: How to Replicate OVER PARTITION BY in SAS
23/07/2022
SAS and SQL: How to Replicate OVER PARTITION BY in SAS

For data analysts coming from the standard SQL world (Oracle, SQL Server, PostgreSQL), one of the...

Lire
Fedsql
Resolving the "BASE driver" connection error with PROC FEDSQL
26/04/2022
Resolving the "BASE driver" connection error with PROC FEDSQL

The transition from SAS 9.4 to SAS Viya often comes with a learning curve regarding in-memory dat...

Lire
Fedsql
SAS Tutorial: Applying SAS Date Formats with PROC FEDSQL
23/09/2021
SAS Tutorial: Applying SAS Date Formats with PROC FEDSQL

One of the most confusing obstacles when moving from PROC SQL (specific to SAS) to PROC FEDSQL (o...

Lire
Fedsql
Handling Date Comparisons in FedSQL
22/08/2021
Handling Date Comparisons in FedSQL

The arrival of SAS Viya and the CAS (Cloud Analytic Services) engine introduced the use of FedSQL...

Lire
Fedsql
SAS Viya Optimization: Emulating PROC SQL with CAS-Enabled PROC FedSQL
26/03/2021
SAS Viya Optimization: Emulating PROC SQL with CAS-Enabled PROC FedSQL

Adopting SAS Viya often comes with a performance goal: leveraging the in-memory CAS (Cloud Analyt...

Lire
Copyright © WeAreCAS 2014-2026
SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. WeAreCAS is an independent community site and is not affiliated with SAS Institute Inc.