Data Step
Fedsql
Guide SAS VIYA
SAS9
How to retrieve the memory size of all tables in a CASLIB?
Working with SAS Viya and the CAS (Cloud Analytic Services) engine often involves monitoring the memory footprint of your data. A common question frequently arises: how to obtai...
Promoting CAS Tables: Understanding Scope and Avoiding the "Table not found" Error
In SAS Viya, sharing data between users is based on a key concept: promotion. A table loaded into memory is by default visible only to you (Session Scope). To make it public, yo...
SAS Viya: How to Properly Manage the Creation and Deletion of CASLIBs
When automating tasks in SAS Viya, it's common to use macros to configure data sources. A classic case is looping through a list of authentication domains (for example, for Orac...
Passing Dynamic Parameters to FedSQL in a Custom Action
Creating User-Defined Actions in SAS Viya allows for encapsulating complex logic to make it reusable. However, a technical challenge often arises when attempting to embed FedSQL...
CAS Storage Optimization: Mastering the DVR Format When Loading Data
In SAS Viya environments, RAM management is critical. As data volumes increase, it becomes imperative to use intelligent storage strategies. One of the most effective methods is...
CAS Storage Optimization: Mastering the DVR Format When Loading Data
In SAS Viya environments, RAM management is critical. As data volumes increase, it becomes imperative to use intelligent storage strategies. One of the most effective methods is...
Get Started! A Beginner's Guide to Programming in the SAS® Cloud Analytic Services (CAS) Environment
IntroductionStarting something new, whether a personal or professional project, can be intimidating. Yet, it is often a very rewarding process. If you are hesitant to start prog...
CAS vs SAS: Understanding Data Step Performance and Behavior Differences
When transitioning to SAS Viya, a common question arises among developers: why does some code appear much faster in CAS, while in other cases, the gain is less obvious? More imp...
CAS vs. SAS: Understanding the Performance and Behavior Differences of the Data Step
When transitioning to SAS Viya, a common question among developers is: why does some code seem much faster in CAS, while in other cases the gain is less obvious? More importantl...
Resolving the "offset exceeds the varying data buffer" error during an ODBC load
When loading data into CAS (Cloud Analytic Services) via an ODBC interface, particularly from databases like MySQL, you may encounter a blocking error related to the management ...
Sharing data between two CAS sessions
In the SAS Viya architecture, memory and session management is a key concept. It frequently happens that a user loads data or creates a library (caslib) in one session (let's ca...
Why (and how) CAS crushes traditional performance
Inertia is a powerful phenomenon. Even among the most fervent SAS users, the adoption of CAS (Cloud Analytic Services), SAS Viya's in-memory engine, sometimes raises reluctance....
Transferring In-Memory Data Between CAS Servers
With the evolution of the SAS Viya architecture, the need to move in-memory data from one CAS server to another (for example, during a migration between two Viya environments or...