Run traditional SAS code on the SAS Viya platform.
Connect to SAS Cloud Analytic Services (CAS).
Access and use caslibs on the CAS server.
Load SAS data sets, Parquet files, CSV files, Microsoft Excel files, and DBMS tables into CAS.
Save distributed CAS tables back to permanent storage in a variety of formats like SASHDAT, Parquet, and CSV.
Modify DATA step code to execute in CAS.
Modify SQL procedure code to execute in CAS using FedSQL.
Use CAS-enabled procedures.
Write CASL code to execute actions on the CAS server.
Who Should Attend
SAS programmers transitioning to SAS Viya
Prerequisites
Before attending this course, you should have nine months or more of SAS programming experience or have completed the SAS Programming 1: Essentials and SAS Programming 2: Data Manipulation Techniques courses. Specifically, you should be able to do the following:;
Understand programming logic concepts.
Use SAS software to access SAS libraries.
Read and manipulate data with the DATA step.
Use SQL to query and join tables.
Use the MEANS and FREQ procedures to summarize data.
SAS Products Covered
SAS Studio;SAS Viya
Course Outline
SAS Viya Platform Overview
Introducing the SAS Viya platform.
SAS Viya programming interfaces.
SAS Viya servers and processing environments.
Running SAS Code on the SAS Compute Server
Overview of running SAS code on the SAS Compute Server.
SAS Viya Compute Server overview.
Running SAS 9 Code on the Compute Server in SAS Viya.
SAS Cloud Analytic Services (CAS) Overview
CAS fundamentals.
Understanding caslibs.
Managing Data in SAS Cloud Analytic Services
Loading data to in-memory tables.
Accessing DBMS data.
Saving and dropping in-memory tables.
Modifying DATA Step Code to Run in SAS Cloud Analytic Services (CAS)
Modifying DATA step code to run in SAS Cloud Analytic Services (CAS).
Running SAS Procedures in SAS Cloud Analytic Services (CAS)
Introduction to SAS procedures in SAS Viya.
Running CAS-enabled SAS procedures.
Modifying SQL Code to Run in SAS Cloud Analytic Services (CAS)