This course is for SAS programmers who want to learn how to run code on the SAS Viya platform. In the course, you first learn how you can easily run traditional SAS code in SAS Viya like you have in SAS 9. Then you learn how to modernize your SAS code to take advantage of SAS Cloud Analytic Services (CAS) on the platform to boost program performance. CAS is a high-performance in-memory analytic engine that performs massively parallel processing (MPP) on data of any size, working with multiple machines, CPUs, and threads for lightning-fast results. The course focuses on how to access, manage, analyze, and manipulate in-memory tables on the distributed CAS server using traditional SAS code as well as new coding techniques. This course is not intended for beginning SAS software users.
Learn How To
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
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
Base SAS;SAS Enterprise Guide;SAS Viya;SAS Studio
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
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)