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

Welcome to this Course

Practicing in this Course

Learner Prerequistes

Important Notes about this Course Version

Set Up Your Practice Files for this Course (REQUIRED)

Module Overview

SAS Viya Overview

SAS Viya Servers

SAS Viya Interfaces

SAS Viya Interfaces to Other Systems

When to Choose CAS

Caslibs

Connecting to CAS from the Compute Server

Activity: View Available Tables

Review of Introduction to SAS Viya and CAS

Module Overview

Submitting Code to CAS

CASL Programming Components

Running CASL Code from SAS

Introduction to CAS Actions

CAS Action Sets

CAS Actions Syntax

Demo: Executing CAS Actions

Creating Numeric and String Variables

Working With Numeric Data

Working With String Data

Demo: Creating and Using String and Numeric Variables

Introduction to CASL Arrays

Accessing Array Elements

Using an Array in a CAS Action

Iterating Through an Array

Demo: Using an Array with CAS Actions

Array Operators

Using Array Functions

Introduction to CASL Dictionaries

Creating a Dictionary in CASL

Accessing and Modifying a Dictionary

Using a Dictionary in a CAS Action

Demo: Using Dictionaries with CAS Actions

CAS Actions Return a Dictionary

Demo: Working with CAS Action Results

Iterating Through a Dictionary

Summary of CAS Language (CASL) Fundamentals

Activity: Use the CAS API

Activity: Find the EXISTS Built-In Function

Activity: Find the loadTable CAS Action

Activity: Create and Print a CASL Variable

Activity: Use Variables in CAS Actions

Activity: Create and Access an Array

Activity: Iterate Over an Array

Activity: Find the UNIQUE Built-In Function

Activity: Create and Describe a Dictionary

Activity: Access a Dictionary Value

Activity: Use a Dictionary in a CAS Action

Activity: Store the Results of a CAS Action

Activity: Iterate Over a Dictionary

Review of CASL Fundamentals

Module Overview

Exploring and Managing the CAS Connection

Demo: Exploring and Managing a CAS Session

Accessing Data in the SAS Compute Server

Accessing Data in CAS

Exploring Caslibs

Demo: Adding and Exploring Caslibs

Caslib Attributes

Demo: Exploring a Caslib's Attributes

Viewing Caslibs in SAS Studio

Demo: Assigning a Libref to a Caslib

Loading Files into In-Memory Tables

Loading Server-Side Files

Demo: Loading Server-Side Data into CAS

Loading Client-Side Files

Demo: Loading Client-Side Data into CAS

Accessing and Loading Database Tables

Promoting Tables to Global Scope

Demo: Promoting a Table

Saving In-Memory Tables

Demo: Saving In-Memory Tables

Dropping In-Memory Tables

Summary of Connecting to CAS and Accessing Data

Activity: Identify the Active Caslib

Activity: Explore Available Caslibs

Activity: Load a Server-Side File into Memory

Activity: Load a Client-Side File into Memory

Activity: Promote an In-Memory Table

Activity: Save an In-Memory Table

Activity: Drop an In-Memory Table

Practice: Load a Server-Side File into Memory

Review of Connecting to CAS and Accessing Data

Module Overview

Exploring Table Structure

A Quick Look at Table Values

Working With Action Results

Exploring Action Results

Accessing Result Table Values

Demo: Creating an Array From a Result Table Column

Result Table Computed Columns

Saving CASL Results

Demo: Saving CASL Results

Characterizing Data

Demo: Characterizing Data

Validating Data

Identifying and Isolating Duplicates

Introduction to Table.copyTable

Subsetting Rows and Columns in CopyTable

Using copyTable to Validate Data

Demo: Validating Data Using CASL

Alternative to table.copyTable for SAS Viya for Learners

Summary of Exploring and Validating Data

Activity: View Column Attributes

Activity: Display the First Five Rows of a Table

Activity: View the Results of a CAS Action

Activity: Filter a Result Table

Activity: Create a Computed Column in a Result Table

Activity: Save a Result Table as a SAS Data Set

Practice: Explore a CAS Table Using Actions

Activity: Print Rows of a Result Table

Practice: Identify Categorical Columns for Analysis

Activity: Remove Duplicate Rows of a Table

Activity: Specify the Length of a Computed Column

Practice: Document Invalid Data

Review of Exploring and Validating Data

Module Overview

Data Preparation in CAS

Introduction

Updating a Table in Place

Using Conditional Logic in the Update Action

Demo: Updating a Table in Place

Benefits and Considerations When Updating a Table

Creating a New In-Memory Table

Formatting Calculated Columns

Working with SAS Date and Time Values

Demo: Working with Dates and Times

Data Type Conversion

Demo: Converting Column Data Types

Preparing the Cars Table

Demo: Preparing the Cars Table

Benefits and Considerations When Creating a New Table

Using the DataStep CAS Action

Altering Table Metadata

Imputing Missing Values

Demo: Imputing Missing Values

Transpose Action

Demo: Transposing a Table

Dynamically Removing Outliers

Demo: Dynamically Removing Outliers

Introduction to the FedSql Action Set

Simple FedSQL Query

Creating CAS Tables Using SQL

Joins

Demo: Imputing Missing Values

Reminder to use table.partition

Summary of Preparing Data

Activity: Find the SCAN Common Function

Activity: Load a Client-Side File into Memory

Activity: Update a Column in Place

Activity: Format a Computed Column

Activity: Convert a Column's Data Type

Practice: Update a Table in Place

Practice: Create a New CAS Table

Activity: Execute DATA Step Code with an Action

Activity: Add a Label to a Column

Practice: Impute Missing Values

Activity: Execute an SQL Query with an Action

Review of Preparing Data

Module Overview

Introduction

Summary Statistics Using the Summary Action

Demo: Generating Descriptive Statistics Using Summary

Summary Statistics Using the Aggregate Action

Demo: Generating Descriptive Statistics Using Aggregate

Frequency and Crosstabulation Reports

Demo: Creating Frequency and Crosstabulation Reports

Additional Analytic Actions

Demo: Additional Analytic Actions

Introduction to Data Visualization and Reporting

Best Practice

Demo: Data Visualization Using CAS Tables

Using the SAS Output Delivery System

Demo: Exporting Results

Getting the Best Performance

Best Practices

Demo: Getting the Best Performance

About Exporting Results

Summary of Analyzing and Summarizing Data

Activity: Find the Summary Action

Activity: Execute the Summary Action

Activity: Execute the Aggregate Action

Activity: Execute the freqTab Action

Practice: Generate Descriptive Statistics Using Summary

Practice: Generate a Crosstabulation Report

Activity: Create a Graph from a CAS Table

Practice: Create a Bar Chart from a Summarized CAS Table

Review of Analyzing and Summarizing Data