In this course, you explore the visual interfaces and learn the programming techniques for loading and preparing your data in SAS Viya. Both the interfaces, SAS Data Preparation (SAS Data Studio) and SAS Studio flows, can be used to create jobs that prepare and load data in CAS. SAS Data Preparation focuses on in-memory data preparation and data wrangling done by the business analyst. SAS Studio flows can be used for other data management use cases like ETL (Extract, Transform, and Load) processing of data on the SAS server where data is first loaded to SAS data sets or a databases before making data available in-memory in CAS. The course also introduces SAS programming techniques to load data in SAS Viya and ways to migrate your Base SAS programs to make use of new capabilities in the DATA step, FedSQL, and procedures to enable fast, parallel in-memory processing in SAS Viya. When explaining the core concepts of data management in SAS Viya, we introduce you to the data architecture of SAS Viya and the CAS data life cycle. CAS IO in SAS Viya introduces you to ways to improve load-processing time using techniques like parallel and multi-node loading. In discussing physical data modeling in CAS, several techniques are discussed to improve the size and performance of in-memory tables. Finally, a discussion of data processing in CAS presents the data manipulation techniques using common procedures, CAS actions, SAS DS2, FedSQL, and data quality algorithms.
Who should attend
Data engineers and data scientists interested in the ways to load and prepare data for visualizations and analytics in SAS Viya
Experience with SAS code is required. You can gain this knowledge and experience by completing the SAS Programming 1: Essentials and SAS Programming 2: Data Manipulation Techniques courses. Additional knowledge of SQL and advanced programming and efficiency techniques is helpful to understand the methods presented, but it is not required.
This course addresses SAS Viya software.
