Monthly Subscription Starting at AED 99 + VAT

SAS® Programming for Distributed Computing in SAS® Viya®

About

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

Modules

Welcome

    • 1 Videos
    • 2 Readings
Show info about module content

1 Videos

  • Welcome to the Distributed Programming in SAS Viya for Data Analysts Specialization

2 Readings

  • Suggestions for completing this specialization
  • About this Version

Getting Started with This Course

    • 2 Videos
    • 3 Readings
    • 1 ExternalTool
Show info about module content

1 External Tool

  • Access SAS Viya for Learners to Practice in This Course

2 Videos

  • Welcome to the Course
  • Practicing in This Course

3 Readings

  • Learner Prerequisites
  • Set Up Your Practice Files for this Course (REQUIRED)
  • IMPORTANT Notes About This Course Version

Module Overview

    • 1 Videos
    • 1 ExternalTool
Show info about module content

1 External Tool

  • Open SAS Viya for Learners to Practice in this Module

1 Videos

  • Module Overview

SAS Viya Platform Overview

    • 6 Videos
Show info about module content

6 Videos

  • Introduction to the SAS Viya Platform
  • SAS Viya Platform Overview
  • SAS Viya Programming Interfaces
  • Demo: Exploring the SAS Viya Platform
  • SAS Viya Servers and Processing Environments
  • Demo: Comparing SAS Compute Server and CAS Server Processing Speeds

Module Review

    • 1 Assignment
Show info about module content

1 Assignment

  • Review of SAS Viya Platform Overview

Module Overview

    • 1 Videos
    • 1 ExternalTool
Show info about module content

1 External Tool

  • Open SAS Viya for Learners to Practice in this Module

1 Videos

  • Module Overview

Running SAS Code on the Compute Server

    • 5 Videos
    • 1 Assignment
Show info about module content

1 Assignment

  • Activity: Run a Traditional SAS Program

5 Videos

  • SAS Viya Compute Server Overview
  • Demo: Running SAS and Python Code in SAS Studio
  • Demo: Programming Interface Features
  • Running SAS 9 Code on the Compute Server in SAS Viya
  • Compute Server Considerations

Module Review

    • 1 Assignment
Show info about module content

1 Assignment

  • Review of Running SAS Code on the SAS Compute Server

Module Overview

    • 1 Videos
    • 1 ExternalTool
Show info about module content

1 External Tool

  • Open SAS Viya for Learners to Practice in this Module

1 Videos

  • Module Overview

CAS Fundamentals

    • 5 Videos
    • 2 Assignment
Show info about module content

2 Assignment

  • Question: Processing Data in CAS
  • Activity - Start a CAS Session

5 Videos

  • CAS Server on SAS Viya
  • Processing Data on the CAS Server
  • Compute Server or CAS?
  • Processing Code in CAS
  • Demo: Connecting to a CAS Server Using a Snippet

Understanding Caslibs

    • 10 Videos
    • 5 Assignment
Show info about module content

5 Assignment

  • Activity - Create a SAS Library and Add a Folder Shortcut
  • Activity: View Available Caslibs and Attributes
  • Activity - View Caslib Files and Tables
  • Activity: Create a Caslib from a Path
  • Activity - Compare a Base SAS Library and a Caslib

10 Videos

  • SAS Libraries
  • Accessing Data through Caslibs
  • Caslib Attributes
  • Viewing Caslib Attributes
  • Assigning Library References to a Caslib
  • Demo: Accessing Caslibs
  • CASUTIL Procedure
  • Manually Adding Caslibs
  • Demo: Defining a New Caslib
  • Accessing Data Sources with Compute or CAS

Module Review

    • 1 Assignment
Show info about module content

1 Assignment

  • Review of SAS Cloud Analytic Services (CAS) Overview

Module Overview

    • 1 Videos
    • 1 ExternalTool
Show info about module content

1 External Tool

  • Open SAS Viya for Learners to Practice in this Module

1 Videos

  • Module Overview

Loading Data to In-Memory Tables

    • 11 Videos
    • 5 Assignment
Show info about module content

5 Assignment

  • REQUIRED Activity - Create an Autoexec File to Start a CAS Session
  • Activity: Load a Server-Side File into CAS
  • Activity: Load a Client-Side File into CAS
  • Activity: Compare Client-Side and Server-Side Load Times
  • Practice: Load a Client-Side SAS Data Set and Excel File into CAS Using a Snippet

11 Videos

  • Loading Files into In-Memory Tables
  • Loading Server-Side Data Source Files
  • Demo: Loading Server-Side Files into CAS
  • Loading Client-Side Data Source Files
  • Client-Side Load - PROC CASUTIL
  • Client-Side Load - DATA Step and PROC IMPORT
  • Demo: Loading Client-Side SAS Data into CAS
  • Client-Side and Server-Side Loading Considerations
  • In-Memory Table Scope
  • Demo: Promoting CAS Tables
  • Table Scope Considerations

Accessing DBMS Data

    • 1 Videos
    • 1 Assignment
Show info about module content

1 Assignment

  • Question - Loading DBMS Data

1 Videos

  • Accessing Database Tables

Saving and Dropping In-Memory Tables

    • 4 Videos
    • 3 Assignment
Show info about module content

3 Assignment

  • Activity - Compare Load Time for SASHDAT Files
  • Activity - Delete a Table from a Caslib
  • Practice: Save a Copy of the In-Memory Table as a SASHDAT File

4 Videos

  • Ending a CAS Session
  • Saving In-Memory Tables
  • Demo: Saving CAS Tables as Data Source Files in a Caslib
  • Dropping In-Memory Tables

Module Review

    • 1 Assignment
Show info about module content

1 Assignment

  • Review of Managing Data in SAS Cloud Analytic Services (CAS)

Module Overview

    • 1 Videos
    • 1 ExternalTool
Show info about module content

1 External Tool

  • Open SAS Viya for Learners to Practice in this Module

1 Videos

  • Module Overview

Modifying DATA Step Code to Run in SAS Cloud Analytic Services (CAS)

    • 8 Videos
    • 5 Assignment
Show info about module content

5 Assignment

  • Activity - Examine Threads Used with a DATA Step
  • Activity - Compare Single- and Multiple-Threaded Process
  • Activity - Threads for By-Group Processing
  • Activity - Add Detailed Log Messages
  • Practice: Modify a DATA Step to Run in CAS (Creating New Variables)

8 Videos

  • DATA Step Processing in CAS
  • Demo: Modifying a DATA Step to Run in CAS
  • Single- or Multi-Threaded Processing
  • Demo: Summarizing in CAS with the Sum Statement
  • DATA Step with By-Group Processing
  • Demo: By-Group Processing in CAS
  • DATA Step Restrictions in CAS
  • Demo: Modifying DATA Step Code to Run in CAS – Part 2

Module Review

    • 1 Assignment
Show info about module content

1 Assignment

  • Review of Modifying DATA Step Code to Run in SAS Cloud Analytic Services (CAS)

Module Overview

    • 1 Videos
    • 1 ExternalTool
Show info about module content

1 External Tool

  • Open SAS Viya for Learners to Practice in this Module

1 Videos

  • Module Overview

Introduction to SAS Procedures in SAS Viya

    • 2 Videos
    • 2 Assignment
Show info about module content

2 Assignment

  • Activity - Procedures that use CAS
  • Activity: Run a Foundation SAS Procedure on a CAS Table

2 Videos

  • SAS Procedures in SAS Viya
  • SAS Foundation Procedures

Running CAS-Enabled Procedures

    • 7 Videos
    • 2 Assignment
Show info about module content

2 Assignment

  • Activity - Run PROC MEANS in CAS
  • Practice: Use the MDSUMMARY Procedure to Generate Statistics in CAS

7 Videos

  • SAS Foundation Procedures: Workarounds for CAS
  • Demo: Modifying Foundation SAS Procedures to Run in CAS
  • CAS-Enabled Base SAS Procedures
  • PROC MDSUMMARY
  • Demo: Producing Descriptive Statistics in CAS Using PROC MDSUMMARY
  • Running Machine Learning Procedures in SAS Viya
  • Demo: Comparing Machine Learning Procedures in SAS Viya

Module Review

    • 1 Assignment
Show info about module content

1 Assignment

  • Review of Running SAS Procedures in SAS Cloud Analytic Services (CAS)

Module Overview

    • 1 Videos
    • 1 ExternalTool
Show info about module content

1 External Tool

  • Open SAS Viya for Learners to Practice in this Module

1 Videos

  • Module Overview

Modifying SQL Code for CAS

    • 6 Videos
    • 3 Assignment
Show info about module content

3 Assignment

  • Activity - Convert PROC SQL to PROC FEDSQL
  • Activity: Use PROC FEDSQL to Access Traditional SAS Libraries
  • Practice: Modify a Simple SQL Query to Run in CAS Using FedSQL

6 Videos

  • Comparing the SQL and FEDSQL Procedures
  • Demo: Executing SQL Queries in CAS Using PROC FEDSQL
  • Additional Differences Between PROC SQL and PROC FEDSQL
  • PROC FEDSQL in CAS
  • Altering In-Memory Tables
  • Demo: Creating an In-Memory Table Using PROC FEDSQL

Column Data Types in CAS

    • 5 Videos
    • 3 Assignment
Show info about module content

3 Assignment

  • Question - Character Value Storage
  • Activity - Compare CHAR and VARCHAR Column Lengths
  • Activity: Choose Appropriate Data Type

5 Videos

  • Column Data Types
  • CHAR Data Columns
  • VARCHAR Data Columns
  • Numeric Data Types
  • Mapping Data Types

Module Review

    • 1 Assignment
Show info about module content

1 Assignment

  • Review of Modifying SQL Code to Run in SAS Cloud Analytic Services (CAS)

Module Overview

    • 1 Videos
    • 1 ExternalTool
Show info about module content

1 External Tool

  • Open SAS Viya for Learners to Practice in this Module

1 Videos

  • Module Overview

Introduction to CASL

    • 4 Videos
    • 2 Assignment
Show info about module content

2 Assignment

  • Activity - View CASL History​
  • Activity - Explore CAS Action Documentation

4 Videos

  • What is CASL?
  • CAS Action Sets
  • Why Learn CASL?
  • Demo: Summarizing Data and Benchmarking CASL

Using CAS Actions (Optional)

    • 4 Videos
    • 4 Assignment
Show info about module content

4 Assignment

  • Activity - Load Excel File to a Table
  • Activity - Generate a Frequency Report
  • Activity - Compute Summary Statistics
  • Practice: Use CAS Actions to Load an Excel File and Generate Frequency Counts

4 Videos

  • Loading Data to Memory
  • Demo: Using a CAS Action to Load a Table into Memory
  • Exploring Data
  • Preparing and Analyzing Data

Module Review

    • 1 Assignment
Show info about module content

1 Assignment

  • Review of Using the Native CAS Language (CASL)

Auto Summary

Unlock the full potential of distributed computing with the "SAS® Programming for Distributed Computing in SAS® Viya®" course, designed for advanced learners in the field of Data Science and AI. This expert-level course, available on Coursera, delves into modifying Base SAS programs to run efficiently within SAS Viya’s scalable, cloud-native architecture. Led by Coursera, this comprehensive program will guide you through leveraging SAS Cloud Analytic Services (CAS) to manage and analyze in-memory tables. Key skills covered include loading data into CAS, adapting DATA step and SQL procedure code for CAS execution, utilizing CAS-enabled procedures, and writing CASL code for executing CAS actions. Ideal for those with prior SAS programming experience—including accessing data via SAS libraries, data preparation with the DATA step, querying with PROC SQL, and summarizing with MEANS and FREQ procedures—this course builds on foundational knowledge to enhance your capabilities in distributed computing. Enrollment offers a Starter subscription option, allowing flexible access to the course content. Join this advanced learning journey and master the intricacies of SAS programming in a distributed computing environment with SAS Viya.

Stacey Syphus
Instructors

Stacey Syphus

Peter Styliadis
Instructors

Peter Styliadis