Available in:
CAS Data Management on the SAS® Viya® Platform
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.
- Introduction.
- How to program against CAS.
- SAS-CAS interaction.
- CAS table scope.
- Connecting to multiple CAS dervers.
- 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.
- 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 persistence.
- CAS data architecture in containers.
- Accessing existing path-based data.
- MPP CAS data architecture.
- CAS data distribution.
- CAS failover.
- CAS elasticity.
- Introduction.
- Extended data types.
- Indexes.
- Partitioning and sorting.
- Repeated tables.
- Compression.
- Duplicate value reduction.
- User defined formats.
- CAS views.
- 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.
Live Class Schedule
Duration: 14 hours
Step into our live classes and experience a dynamic learning environment where you can ask questions, share ideas, and connect with your instructor and classmates. With on-demand lab hours, you can explore the material at your own pace. Our globally acclaimed instructors will motivate you to think bigger, so you can take what you've learned and achieve your biggest goals.
This course isn't publicly scheduled, but private training and mentoring may be available. Contact us to explore options.
Private Training
Get training tailored specifically for your team, led by expert SAS instructors. Choose from virtual sessions, or training at your location (or ours). Perfect for teams seeking a customized curriculum and plenty of interaction with a SAS specialist. We'll schedule it at a time that works for you.
Mentoring Services
Take your training to the next level with personalized mentoring. While private training offers structured coursework, mentoring provides hands-on, real-time support from a subject matter expert. As you work with your own data, you'll receive expert guidance to help you uncover insights, unlock the full potential of your data, and make faster progress. Perfect for those looking to apply what they’ve learned and see quicker results.