Welcome to the SAS Programming for Distributed Computing in SAS Viya course. SAS Viya is an AI, analytic and data management platform running on a scalable, distributed, cloud-native architecture. In this course you will learn how to modify existing Base SAS programs to execute in SAS Viya. The programs you create will leverage the power of SAS Cloud Analytic Services (CAS) to access, manage, and analyze in-memory tables.
This is an advanced course, intended for learners with SAS programming experience. To be successful, you should be able to access data via SAS libraries, read and prepare data with the DATA step, query data using PROC SQL, and summarize data with the MEANS and FREQ procedures. This foundational knowledge can be acquired in the Coursera SAS Programmer specialization.
By the end of the course, you will be able to:
- Load data into SAS Cloud Analytic Services
- Modify DATA step and SQL procedure code to execute in CAS
- Use CAS-enabled procedures
- Write CASL code to execute CAS actions
Overview
Syllabus
- Specialization Overview
- In this module you learn about the courses included in this specialization.
- Course Overview and Logistics
- In this module you discover what you will learn in this course and access the files you will use to practice.
- SAS Viya Platform Overview
- In this module you learn the basics of the SAS Viya platform architecture including the two primary servers, the SAS Compute Server and the SAS Cloud Analytics Services (or CAS) server.
- Running SAS Code on the SAS Compute Server
- In this module you execute traditional SAS code on the SAS Compute Server. You explore considerations to make when migrating programs from SAS®9 to the Compute Server.
- SAS Cloud Analytic Services (CAS) Overview
- In this module you learn about the CAS server, the in-memory massively parallel processing analytic engine. You explore the architecture of CAS, how data is processed, and some of the main considerations when determining if programs should execute on the Compute Server or the CAS Server.
- Managing Data in SAS Cloud Analytic Services (CAS)
- In this module you load different types of files into memory in CAS and examine the common attributes of those in-memory tables. You learn to reference in-memory tables in your programs and how to save those tables efficiently back to disk in a variety of file formats.
- Modifying DATA Step Code to Run in SAS Cloud Analytic Services (CAS)
- In this module you modify DATA step code to run in CAS and discover the potential impact of multi-threaded processing.
- Running SAS Procedures in SAS Cloud Analytic Services (CAS)
- In this module you explore procedures that perform data management and manipulation, calculate descriptive statistics, and generate reports in CAS.
- Modifying SQL Code to Run in SAS Cloud Analytic Services (CAS)
- In this module you modify PROC SQL code to run in the distributed CAS server using PROC FEDSQL. You also explore the additional data types are supported in CAS.
- Using the Native CAS Language (CASL)
- In this module you are introduced to the CAS Language, or CASL. You utilize several CAS actions to access, explore, and summarize data.
Taught by
Stacey Syphus and Peter Styliadis
