|
CAS Data Management on the SAS® Viya® 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 ManagementIntroduction.CAS Programming IntroductionHow to program against CAS.SAS-CAS interaction.CAS table scope.Connecting to multiple CAS dervers.CAS Data LifecycleOverview.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 DataOverview.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 ArchitectureCAS 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 ModelingIntroduction.Extended data types.Indexes.Partitioning and sorting.Repeated tables.Compression.Duplicate value reduction.User defined formats.CAS views.CAS Data ProcessingCAS 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.
|
