The Problem with &SYSDATEIf you regularly work with SAS, you have probably already used the automatic macro variable &SYSDATE. However, a specific behavior can surprise users: &SYSDATE does not store the current date, but the start date of the SAS session.If you start SAS on Monday an...
In a modern Kubernetes-based architecture like SAS Viya, resource management (CPU and RAM) is no longer static. It becomes dynamic and granular. One of the keys to optimizing infrastructure costs while ensuring the performance of critical processes is to move away from the one-size-fits-all model...
In the SAS® Viya™ architecture, effective data management relies on a fundamental concept: the Caslib. A Caslib is an in-memory space on the CAS (Cloud Analytics Services) server intended to hold tables, access controls, and information about data sources.This article explores the different types...
In a SAS Viya environment, security and user experience partly depend on session management. By default, SAS Viya web applications log out a user after a certain period of inactivity (usually 30 minutes).This article guides you step-by-step to modify this interval via SAS Environment Manager, whe...
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, you must promote it (Global Scope).However, it often happens that the promote statement fails with a frustrating message: ...
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 programming with SAS® Cloud Analytic Services (CAS), know that the benefits are considerable.CAS is the analytical engine at...
When working with SAS to interact with Big Data environments like Hadoop Impala, resource management is crucial. A common requirement is to assign a session to a specific "Request Pool" to ensure that queries are prioritized or managed correctly by the cluster.Although using SQL Pass-Through allo...
When starting with SAS Viya, it's common to encounter different syntaxes to perform a seemingly identical task: connecting a SAS library to a Caslib. A common confusion arises when initializing a session and assigning a libref.Should the Caslib be defined only in the session options (SESSOPTS), o...
In the world of SAS programming, a debate persists: which is more performant, PROC SQL or the DATA step? The classic answer is "it depends." However, there are specific scenarios where SQL's performance literally collapses, going from a few minutes to several hours, or even crashing the session.O...
When getting started with SAS Viya, and more specifically when automating tasks via the CAS REST API, it is common to want to create sessions programmatically.However, a frequent error can occur when using tools like cURL to initiate these sessions: the HTTP 403 status code. This article explains...