Automating analytical tasks via the SAS Viya REST API is a common practice for integrating the power of SAS into external pipelines. However, a frequent error occurs when using the runCode action to manipulate tables located in CAS libraries (Caslibs) whose names exceed the historical 8-character...
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 Oracle) to dynamically create CASLIBs.However, a difficulty often arises when this code needs to be executed multiple times:...
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...
When running complex models in SAS Viya (like VDMML), your process may abruptly stop, displaying a specific error message about quotas. This issue often occurs when training resource-intensive models, such as "Random Forests," which generate large state files (ASTOREs).If you have encountered the...
The transition from SAS 9.4 to SAS Viya often comes with a learning curve regarding in-memory data management. A common confusion arises when transitioning from PROC SQL to PROC FEDSQL to interact with tables loaded in CAS libraries (CASLIBs).If you have ever encountered the error "BASE driver, s...
Integrating large-scale data between SAS Viya and a Hadoop cluster is a common operation, but it can sometimes run into subtle configuration problems. One of the most frequent obstacles when defining a Caslib is the occurrence of a timeout error immediately after executing the connection code.Thi...
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 call it Session A), and then wants to access it from a new session (Session B).However, a direct attempt to assign the exi...
/****************************************************************************** * STRESS TEST SAS VIYA (CAS) AVEC RAPPORT DE PERFORMANCE ******************************************************************************/ /* --- BLOC INITIALISATION DU CHRONO --- */ /* On crée une table vide po...
cas; /* 1. Création d'une table temporaire en mémoire CAS */ DATA casuser.ma_table_basique; INPUT ID Name $ Value; DATALINES; 1 Alice 100 2 Bob 150 3 Charlie 120 ; RUN; /* 2. Afficher les informations de la table */ PROC CAS; TABLE.tableInfo RESULT=r / ...
cas; /* Création d'une table de référence */ DATA samples.produits_ventes; INPUT Annee Produit $ Quantite Prix; DATALINES; 2023 A 10 100 2023 B 20 50 ; RUN; PROC CAS; /* Cas A : Table introuvable avec quiet=TRUE */ TABLE.tableInfo RESULT=r_non_existent / ...