CASL Programming for Distributed Computing in SAS® Viya®

1 Videos

• Module Overview

1 Assignment

• Activity: View Available Tables

7 Videos

• 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

1 Assignment

• Review of Introduction to SAS Viya and CAS

1 External Tool

• Open SAS Viya for Learners to Practice

1 Videos

• Module Overview

2 Assignment

• Activity: Use the CAS API
• Activity: Find the EXISTS Built-In Function

3 Videos

• Submitting Code to CAS
• CASL Programming Components
• Running CASL Code from SAS

1 Assignment

• Activity: Find the loadTable CAS Action

4 Videos

• Introduction to CAS Actions
• CAS Action Sets
• CAS Actions Syntax
• Demo: Executing CAS Actions

2 Assignment

• Activity: Create and Print a CASL Variable
• Activity: Use Variables in CAS Actions

4 Videos

• Creating Numeric and String Variables
• Working With Numeric Data
• Working With String Data
• Demo: Creating and Using String and Numeric Variables

3 Assignment

• Activity: Create and Access an Array
• Activity: Iterate Over an Array
• Activity: Find the UNIQUE Built-In Function

7 Videos

• 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

1 Quiz

• Activity: Find the UNIQUE Built-In Function

5 Assignment

• 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

8 Videos

• 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

1 Assignment

• Review of CASL Fundamentals

1 Readings

• Summary of CAS Language (CASL) Fundamentals

1 External Tool

• Open SAS Viya for Learners to Practice

1 Videos

• Module Overview

1 Assignment

• Activity: Identify the Active Caslib

2 Videos

• Exploring and Managing the CAS Connection
• Demo: Exploring and Managing a CAS Session

1 Assignment

• Activity: Explore Available Caslibs

8 Videos

• 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

6 Assignment

• 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
• Exercise: Load a Server-Side File into Memory

11 Videos

• 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

1 Assignment

• Review of Connecting to CAS and Accessing Data

1 Readings

• Summary of Connecting to CAS and Accessing Data

1 External Tool

• Open SAS Viya for Learners to Practice

1 Videos

• Module Overview

7 Assignment

• 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
• Exercise: Explore a CAS Table Using Actions

9 Videos

• 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

2 Assignment

• Activity: Print Rows of a Result Table
• Exercise: Identify Categorical Columns for Analysis

2 Videos

• Characterizing Data
• Demo: Characterizing Data

3 Assignment

• Activity: Remove Duplicate Rows of a Table
• Activity: Specify the Length of a Computed Column
• Exercise: Document Invalid Data

6 Videos

• 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

1 Readings

• Alternative to table.copyTable for SAS Viya for Learners

1 Assignment

• Review of Exploring and Validating Data

1 Readings

• Summary of Exploring and Validating Data

1 External Tool

• Open SAS Viya for Learners Practice

1 Videos

• Module Overview

1 Assignment

• Activity: Find the SCAN Common Function

1 Videos

• Data Preparation in CAS

6 Assignment

• 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
• Exercise: Update a Table in Place
• Exercise: Create a New CAS Table

14 Videos

• 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

1 Readings

• Reminder to use table.partition

3 Assignment

• Activity: Execute DATA Step Code with an Action
• Activity: Add a Label to a Column
• Exercise: Impute Missing Values

8 Videos

• 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

2 Assignment

• Activity: Execute an SQL Query with an Action
• Activity: Execute an SQL Query with an Action

5 Videos

• Introduction to the FedSql Action Set
• Simple FedSQL Query
• Creating CAS Tables Using SQL
• Joins
• Demo: Imputing Missing Values

1 Assignment

• Review of Preparing Data

1 Readings

• Summary of Preparing Data

1 External Tool

• Open SAS Viya for Learners to Practice

1 Videos

• Module Overview

6 Assignment

• Activity: Find the Summary Action
• Activity: Execute the Summary Action
• Activity: Execute the Aggregate Action
• Activity: Execute the freqTab Action
• Exercise: Generate Descriptive Statistics Using Summary
• Exercise: Generate a Crosstabulation Report

9 Videos

• 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

3 Assignment

• Activity: Create a Graph from a CAS Table
• Practice: Create a Bar Chart from a Summarized CAS Table
• Exercise: Create a Bar Chart from a Summarized CAS Table

5 Videos

• Introduction to Data Visualization and Reporting
• Best Practice
• Demo: Data Visualization Using CAS Tables
• Using the SAS Output Delivery System
• Demo: Exporting Results

1 Readings

• About Exporting Results

3 Videos

• Getting the Best Performance
• Best Practices
• Demo: Getting the Best Performance

1 Assignment

• Review of Analyzing and Summarizing Data

1 Readings

• Summary of Analyzing and Summarizing Data