SAS® Programming for Distributed Computing in SAS® Viya®

This course is part of Distributed Programming in SAS® Viya® for Data Analysts Specialization

Instructors: Stacey Syphus

What you'll learn

Load data into SAS Cloud Analytic Services
Modify DATA step and SQL procedure code to execute in CAS
Use CAS-enabled procedures and CAS actions

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

46 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

Build your subject-matter expertise

This course is part of the Distributed Programming in SAS® Viya® for Data Analysts Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

There are 10 modules in this course

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

In this module you learn about the courses included in this specialization.

What's included

1 video2 readings

In this module you discover what you will learn in this course and access the files you will use to practice.

What's included

2 videos3 readings1 app item

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.

What's included

7 videos1 assignment1 app item

7 videosTotal 18 minutes

Module Overview0 minutesPreview module
Introduction to the SAS Viya Platform2 minutes
SAS Viya Platform Overview3 minutes
SAS Viya Programming Interfaces1 minute
Demo: Exploring the SAS Viya Platform5 minutes
SAS Viya Servers and Processing Environments2 minutes
Demo: Comparing SAS Compute Server and CAS Server Processing Speeds2 minutes

1 assignmentTotal 15 minutes

Review of SAS Viya Platform Overview15 minutes

1 app itemTotal 5 minutes

Open SAS Viya for Learners to Practice in this Module5 minutes

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.

What's included

6 videos2 assignments1 app item

6 videosTotal 17 minutes

Module Overview0 minutesPreview module
SAS Viya Compute Server Overview3 minutes
Demo: Running SAS and Python Code in SAS Studio4 minutes
Demo: Programming Interface Features6 minutes
Running SAS 9 Code on the Compute Server in SAS Viya1 minute
Compute Server Considerations0 minutes

2 assignmentsTotal 195 minutes

Activity: Run a Traditional SAS Program180 minutes
Review of Running SAS Code on the SAS Compute Server15 minutes

1 app itemTotal 60 minutes

Open SAS Viya for Learners to Practice in this Module60 minutes

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.

What's included

16 videos8 assignments1 app item

16 videosTotal 38 minutes

Module Overview0 minutesPreview module
CAS Server on SAS Viya4 minutes
Processing Data on the CAS Server2 minutes
Compute Server or CAS?2 minutes
Processing Code in CAS0 minutes
Demo: Connecting to a CAS Server Using a Snippet1 minute
SAS Libraries1 minute
Accessing Data through Caslibs2 minutes
Caslib Attributes2 minutes
Viewing Caslib Attributes0 minutes
Assigning Library References to a Caslib5 minutes
Demo: Accessing Caslibs3 minutes
CASUTIL Procedure0 minutes
Manually Adding Caslibs2 minutes
Demo: Defining a New Caslib3 minutes
Accessing Data Sources with Compute or CAS2 minutes

8 assignmentsTotal 630 minutes

Question: Processing Data in CAS180 minutes
Activity - Start a CAS Session15 minutes
Activity - Create a SAS Library and Add a Folder Shortcut15 minutes
Activity: View Available Caslibs and Attributes180 minutes
Activity - View Caslib Files and Tables15 minutes
Activity: Create a Caslib from a Path180 minutes
Activity - Compare a Base SAS Library and a Caslib15 minutes
Review of SAS Cloud Analytic Services (CAS) Overview30 minutes

1 app itemTotal 60 minutes

Open SAS Viya for Learners to Practice in this Module60 minutes

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.

What's included

17 videos10 assignments1 app item

17 videosTotal 49 minutes

Module Overview0 minutesPreview module
Loading Files into In-Memory Tables2 minutes
Loading Server-Side Data Source Files1 minute
Demo: Loading Server-Side Files into CAS10 minutes
Loading Client-Side Data Source Files0 minutes
Client-Side Load - PROC CASUTIL2 minutes
Client-Side Load - DATA Step and PROC IMPORT2 minutes
Demo: Loading Client-Side SAS Data into CAS7 minutes
Client-Side and Server-Side Loading Considerations2 minutes
In-Memory Table Scope1 minute
Demo: Promoting CAS Tables5 minutes
Table Scope Considerations1 minute
Accessing Database Tables2 minutes
Ending a CAS Session0 minutes
Saving In-Memory Tables1 minute
Demo: Saving CAS Tables as Data Source Files in a Caslib5 minutes
Dropping In-Memory Tables0 minutes

10 assignmentsTotal 675 minutes

REQUIRED Activity - Create an Autoexec File to Start a CAS Session15 minutes
Activity: Load a Server-Side File into CAS180 minutes
Activity: Load a Client-Side File into CAS180 minutes
Activity: Compare Client-Side and Server-Side Load Times180 minutes
Practice: Load a Client-Side SAS Data Set and Excel File into CAS Using a Snippet30 minutes
Question - Loading DBMS Data5 minutes
Activity - Compare Load Time for SASHDAT Files15 minutes
Activity - Delete a Table from a Caslib15 minutes
Practice: Save a Copy of the In-Memory Table as a SASHDAT File30 minutes
Review of Managing Data in SAS Cloud Analytic Services (CAS)25 minutes

1 app itemTotal 60 minutes

Open SAS Viya for Learners to Practice in this Module60 minutes

In this module you modify DATA step code to run in CAS and discover the potential impact of multi-threaded processing.

What's included

9 videos6 assignments1 app item

9 videosTotal 27 minutes

Module Overview0 minutesPreview module
DATA Step Processing in CAS2 minutes
Demo: Modifying a DATA Step to Run in CAS4 minutes
Single- or Multi-Threaded Processing2 minutes
Demo: Summarizing in CAS with the Sum Statement2 minutes
DATA Step with By-Group Processing1 minute
Demo: By-Group Processing in CAS2 minutes
DATA Step Restrictions in CAS3 minutes
Demo: Modifying DATA Step Code to Run in CAS – Part 27 minutes

6 assignmentsTotal 110 minutes

Activity - Examine Threads Used with a DATA Step15 minutes
Activity - Compare Single- and Multiple-Threaded Process15 minutes
Activity - Threads for By-Group Processing15 minutes
Activity - Add Detailed Log Messages15 minutes
Practice: Modify a DATA Step to Run in CAS (Creating New Variables)30 minutes
Review of Modifying DATA Step Code to Run in SAS Cloud Analytic Services (CAS)20 minutes

1 app itemTotal 5 minutes

Open SAS Viya for Learners to Practice in this Module5 minutes

In this module you explore procedures that perform data management and manipulation, calculate descriptive statistics, and generate reports in CAS.

What's included

10 videos5 assignments1 app item

10 videosTotal 27 minutes

Module Overview0 minutesPreview module
SAS Procedures in SAS Viya0 minutes
SAS Foundation Procedures1 minute
SAS Foundation Procedures: Workarounds for CAS2 minutes
Demo: Modifying Foundation SAS Procedures to Run in CAS7 minutes
CAS-Enabled Base SAS Procedures1 minute
PROC MDSUMMARY0 minutes
Demo: Producing Descriptive Statistics in CAS Using PROC MDSUMMARY3 minutes
Running Machine Learning Procedures in SAS Viya 2 minutes
Demo: Comparing Machine Learning Procedures in SAS Viya7 minutes

5 assignmentsTotal 95 minutes

Activity - Procedures that use CAS15 minutes
Activity: Run a Foundation SAS Procedure on a CAS Table15 minutes
Activity - Run PROC MEANS in CAS15 minutes
Practice: Use the MDSUMMARY Procedure to Generate Statistics in CAS30 minutes
Review of Running SAS Procedures in SAS Cloud Analytic Services (CAS)20 minutes

1 app itemTotal 5 minutes

Open SAS Viya for Learners to Practice in this Module5 minutes

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.

What's included

12 videos7 assignments1 app item

12 videosTotal 17 minutes

Module Overview0 minutesPreview module
Comparing the SQL and FEDSQL Procedures1 minute
Demo: Executing SQL Queries in CAS Using PROC FEDSQL2 minutes
Additional Differences Between PROC SQL and PROC FEDSQL0 minutes
PROC FEDSQL in CAS0 minutes
Altering In-Memory Tables1 minute
Demo: Creating an In-Memory Table Using PROC FEDSQL4 minutes
Column Data Types0 minutes
CHAR Data Columns1 minute
VARCHAR Data Columns1 minute
Numeric Data Types0 minutes
Mapping Data Types2 minutes

7 assignmentsTotal 445 minutes

Activity - Convert PROC SQL to PROC FEDSQL15 minutes
Activity: Use PROC FEDSQL to Access Traditional SAS Libraries180 minutes
Practice: Modify a Simple SQL Query to Run in CAS Using FedSQL30 minutes
Question - Character Value Storage5 minutes
Activity - Compare CHAR and VARCHAR Column Lengths15 minutes
Activity: Choose Appropriate Data Type180 minutes
Review of Modifying SQL Code to Run in SAS Cloud Analytic Services (CAS)20 minutes

1 app itemTotal 5 minutes

Open SAS Viya for Learners to Practice in this Module5 minutes

In this module you are introduced to the CAS Language, or CASL. You utilize several CAS actions to access, explore, and summarize data.

What's included

9 videos7 assignments1 app item

9 videosTotal 15 minutes

Module Overview0 minutesPreview module
What is CASL?1 minute
CAS Action Sets1 minute
Why Learn CASL?0 minutes
Demo: Summarizing Data and Benchmarking CASL3 minutes
Loading Data to Memory1 minute
Demo: Using a CAS Action to Load a Table into Memory2 minutes
Exploring Data1 minute
Preparing and Analyzing Data2 minutes

7 assignmentsTotal 130 minutes

Activity - View CASL History15 minutes
Activity - Explore CAS Action Documentation15 minutes
Activity - Load Excel File to a Table15 minutes
Activity - Generate a Frequency Report15 minutes
Activity - Compute Summary Statistics15 minutes
Practice: Use CAS Actions to Load an Excel File and Generate Frequency Counts30 minutes
Review of Using the Native CAS Language (CASL)25 minutes