Search Results

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 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 & Benchmarking SAS Viya: Efficiently saturating your CAS CPU cores

/****************************************************************************** * STRESS TEST SAS VIYA (CAS) AVEC RAPPORT DE PERFORMANCE ******************************************************************************/ /* --- BLOC INITIALISATION DU CHRONO --- */ /* On crée une table vide po...

Monitoring CAS_CACHE_DISK: Under the Hood of SAS Viya Memory

proc cas; /* ------------------------------------------------------------------- OBJECTIF : Auditer l'espace disque du CAS_DISK_CACHE PRÉREQUIS : Droits suffisants pour assumer le rôle de Superuser ------------------------------------------------------------------- */...

Tips for Monitoring SAS Logs in Real-Time on Windows

Surviving "Syntax Check Mode" in Production

SAS on Mainframe: What to Do When the WORK Library is Full?

/* Compression activée pour cette table spécifique */ data WORK.A (compress=yes); set DB2.GRANDE_TABLE; run; /* OU activée globalement pour toute la session */ options compress=yes;

SAS Tutorial: How to Measure Total Execution Time

SAS Viya Optimization: Mastering Implicit Pass-Through with FedSQL

caslib pg_db1 datasource=(srctype="postgres", ...); proc fedsql sessref=mySession _method; create table casuser.myresults{options replace=true} as select film.title, film_category.category_id from pg_db1."film" as film, pg_db1."film_category" as film_category where...

SAS Viya Optimization: Mastering Implicit Pass-Through with FedSQL

proc fedsql sessref=mySession _method; create table casuser.myresults as select film.title, film_category.category_id from pg_db1."film" as film, pg_db2."film_category" as film_category /* ... suite de la requête ... */ quit;

SAS Viya Optimization: Mastering Implicit Pass-Through with FedSQL

/* Utilisation de l'option requireFullPassThrough pour forcer le test */ proc fedsql sessref=mySession _method cntl=(requireFullPassThrough); create table pg_db1.myresults as select * from pg_db1."customer" where put(create_date,ddmmyy10.)='14/02/2006'; /* Fonction SAS */ quit;