Available in:
SAS® Cloud Analytic Services (CAS) for the Data Engineer
CASD : CASDV1
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
- Access and load data efficiently in SAS Viya using a variety of techniques
- Identify the main elements of the SAS Viya data architecture
- Optimize your SAS Viya data model and management
- Use CAS procedures and the CAS language to process data in CAS
- Adapt existing SAS and SQL code to run in CAS
Who Should Attend
Technical users 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;SAS Studio
Course Outline
Workshop Overview
- Hands-on Lab Environment.
- What's New in the Workshop?
- What is CAS?
- CAS Data Access.
- Programming in CAS.
- Serial Loading (Review).
- Server-Side Massively Parallel Loading.
- Server-Side Multi-Node Loading.
- Data Saving.
- Data Loading Mechanisms.
- Data Distribution.
- Failover.
- Elasticity.
- Indexes.
- Partitioning and Sorting.
- Repeated Tables.
- Compression.
- Duplicate Value Reduction.
- User-Defined Formats.
- Views.
- CAS-enabled vs Non-CAS-enabled Data Processing.
- DATA Step Programming in CAS.
- FedSQL Programming in CAS.
- Joins with SAS Formats and Hash Objects.
- Data Manipulation with CAS Actions.
- Where to go next for DS2, DQ, and CASL.