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
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 ServerOverview 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) OverviewCAS fundamentals.Understanding caslibs.Managing Data in SAS Cloud Analytic ServicesLoading 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)Modifying SQL code to run in CAS.Column data types in CAS.Using the Native CAS Language (CASL)Introduction to CASL.Using CAS actions.
Live Instructor Dates 
