You are viewing as a ‘Guest’. Your progress will not be recorded.
SAS® Cloud Analytic Services (CAS) for the Data Engineer
2h 3m + Hands-On Practice
START FREE TRIAL
Available in:
A person using a tablet to complete a video based eLearning course and hands-on lab.


  
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?
Introduction to CAS
  • What is CAS?
  • CAS Data Access.
  • Programming in CAS.
Advanced Loading and Saving Techniques
  • Serial Loading (Review).
  • Server-Side Massively Parallel Loading.
  • Server-Side Multi-Node Loading.
  • Data Saving.
Data Architecture
  • Data Loading Mechanisms.
  • Data Distribution.
  • Failover.
  • Elasticity.
Physical Data Modeling
  • Indexes.
  • Partitioning and Sorting.
  • Repeated Tables.
  • Compression.
  • Duplicate Value Reduction.
  • User-Defined Formats.
  • Views.
CAS Data Processing
  • 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.