cas casauto sessopts=(caslib='casuser'); libname mycas cas; caslib _all_ assign; data mycas.earnings; Amount=1000; Rate=.075/12; do month=1 to 12; Earned +(amount+earned)*(rate); end; run; proc print data=mycas.earnings;...
proc export data=mycaslib.creditqualify outfile="your-file-path\CreditQualify.csv" dbms=csv replace; run;
caslib csvfiles task=add type=dnfs path="/data/csv/" desc="Spreadsheets and CSV source data."; proc casutil; list files; load casdata="County_Population.csv" importoptions=(filetype="csv" getnames="true") casout="co...
In the SAS Viya environment, in-memory data management is crucial. Before manipulating a table, it is often necessary to check its existence, know its size, or retrieve its metadata (creation date, encoding, number of rows).This is where the tableInfo action from the table action set comes in.In ...
In the classic SAS ecosystem (v9), the concept of SQL Pass-Through (implicit or explicit) is well-known for delegating computations to the database. With the arrival of SAS Viya and the in-memory engine CAS (Cloud Analytic Services), this mechanism has evolved.There are now two ways to perform SQ...
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...
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 two different Kubernetes namespaces) has become crucial.Previously complex, this operation is now simplified thanks to ...
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 obtain storage details (size, memory usage) for all tables in a library at once?If you have already tried using wildcards lik...
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: ...
Long-time SAS 9 users are increasingly looking to migrate to SAS Viya to harness the power of the CAS (Cloud Analytic Services) engine. This distributed and in-memory engine can significantly speed up existing processes and analyze massive data volumes.However, a key step in this modernization in...