CAS Data Management on the SAS® Viya® Platform

Preview mode

Not attempted CAS Data Management on the SAS(R) Viya(R) Platform

Duration: 14 hours

DM316W : DM316B

This course provides an in-depth look at the features and functionality of SAS Viya Data Management architecture, design, lifecycle, and programming.

Learn How To

Get familiar with SAS Viya data architecture.

Operate a data management ecosystem in SAS Viya.

Get familiar with CAS programming.

Access and load data efficiently in SAS Viya and CAS using different techniques.

Optimize your SAS Viya data model.

Process data in CAS.

Who Should Attend

Technical resources who need to support Data Management on SAS Viya

Prerequisites

Before attending this course, students should be familiar with:;

Data access and management concepts.

SAS Viya fundamentals.

Base SAS coding techniques.

SAS Viya 4: Core Topics.

SAS Products Covered

SAS Viya

Course Outline

Workshop Overview

Workshop welcome.

Using the hands-on lab with this course.

What is new.

CAS Data Management

Introduction.

CAS Programming Introduction

How to program against CAS.

SAS-CAS interaction.

CAS table scope.

Connecting to multiple CAS dervers.

CAS Data Lifecycle

Overview.

Define the CAS library (CASLIB).

Load the CAS table.

Modify the CAS table.

Save the CAS table.

Unload the CAS table.

Reload the CAS table.

Extract the CAS table.

Drop the CAS table.

Loading and Reading CAS Data

Overview.

Server side serial loading.

Server side massively parallel loading.

Server side multi node loading.

Client side loading.

Data saving.

Supplemental SAS DI Studio.

Supplemental loading with SAS CONNECT.

CAS Data Architecture

CAS data persistence.

CAS data architecture in containers.

Accessing existing path-based data.

MPP CAS data architecture.

CAS data distribution.

CAS failover.

CAS elasticity.

CAS Physical Data Modeling

Introduction.

Extended data types.

Indexes.

Partitioning and sorting.

Repeated tables.

Compression.

Duplicate value reduction.

User defined formats.

CAS views.

CAS Data Processing

CAS enabled vs Non-CAS enabled.

CAS data manipulation introduction.

DATA step in CAS.

DS2 in CAS.

FedSQL in CAS.

FedSQL Pass-Through in CAS.

SAS formats in CAS.

Hash objects in CAS.

Data manipulation technique comparison.

Transpose in CAS.

Other common PROCs-Actions.

Data quality functions in CAS.

Data quality CAS actions.

Supplemental CAS network data movement.

THIS COURSE IS PART OF

SAS Data Engineering Learning Subscription

Skip Earn this badge

Earn this badge