SAS(R) Programming for Distributed Computing in SAS(R) Viya(R) 

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

Suggestions for completing this specialization

Welcome to the Course

Practicing in This Course

Learner Prerequisites

Set Up Your Practice Files for this Course (REQUIRED)

Module Overview

SAS Viya in the SAS Platform

SAS Viya Programming Interfaces

SAS Viya Servers and Processing Environments

Demo: Running a SAS Program in SAS Studio

The CAS Language and CAS Actions

Parallel Processing in CAS

Compute Server or CAS?

Server Strengths

Processing Code in CAS

Demo: Connecting to a CAS Server Using a Snippet

Activity - Start a CAS Session

Review of Introduction to SAS Viya

Module Overview

SAS Libraries

Accessing Data through Caslibs

Caslib Attributes

Assigning Library References to a Caslib

Predefined Caslibs

Demo: Accessing Caslibs

CASUTIL Procedure

Manually Adding Caslibs

Setting the Default Caslib

Demo: Defining a New Caslib

Loading Files into In-Memory Tables

Loading Client-Side Data Source Files

Demo: Loading Client-Side SAS Data into CAS

Loading Other Client-Side Data Source Files

In-Memory Table Scope

Loading Server-Side Data Source Files

Accessing Database Tables

Ending a CAS Session

Saving In-Memory Tables

Demo: Saving a SASHDAT File in a Caslib

Dropping In-Memory Tables

Activity - Create a SAS Library and Add a Folder Shortcut

Activity - View Caslib Files and Tables

Activity - Create a Caslib and Compare it to a SAS Library

REQUIRED Activity - Create an Autoexec File to Start a CAS Session

Activity - Promote an In-Memory Table

Practice: Load a Client-Side SAS Data Set and Excel File into CAS Using a Snippet

Question - Loading DBMS Data

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

Review of Loading Data into CAS

Module Overview

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

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

CHAR Data Columns

VARCHAR Data Columns

Numeric Data Types

Mapping Data Types

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)

Activity - Convert PROC SQL to PROC FEDSQL

Practice: Modify a Simple SQL Query to Run in CAS Using FedSQL

Question - Character Value Storage

Activity - Compare CHAR and VARCHAR Column Lengths

Review of Modifying Base SAS Programs to Run in CAS

Module Overview

SAS Procedures in SAS Viya

SAS Foundation Procedures

SAS Foundation Procedures: Workarounds for CAS

CAS-Enabled Base SAS Procedures

PROC MDSUMMARY

Demo: Producing Descriptive Statistics in CAS Using PROC MDSUMMARY

Additional CAS-Enabled Base SAS Procedures

What is CASL?

CAS Action Sets

Why Learn CASL?

Loading Data to Memory

Demo: Using a CAS Action to Load a Table into Memory

Exploring Data

Preparing and Analyzing Data

Demo: Summarizing Data and Benchmarking CASL

Activity - Procedures that use CAS

Activity - Run PROC MEANS in CAS

Practice: Use the MDSUMMARY Procedure to Generate Statistics in CAS

Activity - View CASL History

Activity - Explore CAS Action Documentation

Activity - Load Excel File to a Table

Activity - Generate Frequency Report

Activity - Compute Summary Statistics

Practice: Use CAS Actions to Load an Excel File and Generate Frequency Counts

Review of Using CAS-Enabled Procedures and CAS Actions