Course Overview and Logistics-Course Overview
Welcome to this Course
()
Learner Prerequistes
Practicing in this Course
()
Important Notes about this Course Version
Set Up Your Practice Files for this Course (REQUIRED)
Introduction to SAS Viya and CAS-Module Overview
Module Overview
()
Introduction to SAS Viya and CAS-SAS Viya 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
()
CAS Language (CASL) Fundamentals-Module Overview
Module Overview
()
CAS Language (CASL) Fundamentals-Introduction to CASL
Submitting Code to CAS
()
CASL Programming Components
()
Running CASL Code from SAS
()
CAS Language (CASL) Fundamentals-CASL CAS Actions
Introduction to CAS Actions
()
CAS Action Sets
()
CAS Actions Syntax
()
Demo: Executing CAS Actions
()
CAS Language (CASL) Fundamentals-CASL Numeric and String Variables
Creating Numeric and String Variables
()
Working With Numeric Data
()
Working With String Data
()
Demo: Creating and Using String and Numeric Variables
()
CAS Language (CASL) Fundamentals-CASL Arrays
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
()
CAS Language (CASL) Fundamentals-CASL Dictionaries
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
()
CAS Language (CASL) Fundamentals-Review
Summary of CAS Language (CASL) Fundamentals
Connecting to CAS and Accessing Data-Overview
Module Overview
()
Connecting to CAS and Accessing Data-Exploring the CAS Connection
Exploring and Managing the CAS Connection
()
Demo: Exploring and Managing a CAS Session
()
Connecting to CAS and Accessing Data-Exploring the CAS Connection
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
()
Connecting to CAS and Accessing Data-Managing In-Memory Tables
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
()
Connecting to CAS and Accessing Data-Review
Summary of Connecting to CAS and Accessing Data
Exploring and Validating Data-Overview
Module Overview
()
Exploring and Validating Data-Exploring Table Structure
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
()
Exploring and Validating Data-Characterizing Data
Characterizing Data
()
Demo: Characterizing Data
()
Exploring and Validating Data-Validating Data
Validating Data
()
Identifying and Isolating Duplicates
()
Alternative to table.copyTable for SAS Viya for Learners
Introduction to Table.copyTable
()
Subsetting Rows and Columns in CopyTable
()
Using copyTable to Validate Data
()
Demo: Validating Data Using CASL
()
Exploring and Validating Data-Review
Summary of Exploring and Validating Data
Preparing Data-Overview
Module Overview
()
Preparing Data-Introduction to Data Preparation in CASL
Data Preparation in CAS
()
Preparing Data-Modifying Tables and Values
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
()
Reminder to use table.partition
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
()
Preparing Data-Data Preparation Actions
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
()
Preparing Data-Using SQL in CAS
Introduction to the FedSql Action Set
()
Simple FedSQL Query
()
Creating CAS Tables Using SQL
()
Joins
()
Demo: Imputing Missing Values
()
Preparing Data-Review
Summary of Preparing Data
Analyzing and Summarizing Data-Overview
Module Overview
()
Analyzing and Summarizing Data-Summarizing Data with Actions
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
()
Analyzing and Summarizing Data-Visualizing and Reporting
Introduction to Data Visualization and Reporting
()
Best Practice
()
Demo: Data Visualization Using CAS Tables
()
Using the SAS Output Delivery System
()
About Exporting Results
Demo: Exporting Results
()
Analyzing and Summarizing Data-Getting the Best Performance
Getting the Best Performance
()
Best Practices
()
Demo: Getting the Best Performance
()
Analyzing and Summarizing Data-Review
Summary of Analyzing and Summarizing Data