Job Meter = High
Programming for SAS Viya
30 Hours
Online Instructor-led Training
USD 1399 (About this Course
This course is for users who need to modify existing Base SAS programs that will execute in SAS Viya. This course leverages the power of SAS Cloud Analytic Services (CAS) to access, manage, and manipulate in-memory tables. This course is not intended for beginning SAS software users.
Learn how to- Connect to Cloud Analytic Services (CAS).
- Access and use caslibs.
- Load SAS data sets, CSV files, and Microsoft Excel files into CAS.
- Save SASHDAT files.
- Modify Base SAS programs to execute in CAS.
- Modify SQL procedure code to execute in CAS using FedSQL.
- Use CAS-enabled functions and procedures.
Target Audience
SAS programmers transitioning to SAS Viya
-----------------------------------------------------------------------
Programming for SAS Viya
Course Details & Curriculum
Introduction
- Overview of SAS Viya.
- Accessing SAS libraries.
- Session-scope and global-scope caslibs.
- Accessing caslibs.
- Changing the active caslib.
- Connecting to a CAS server using a snippet.
- Overview of loading tables into CAS and saving the tables.
- Session-scope and global-scope tables.
- Accessing SAS data sets, CSV files, and Microsoft Excel files and loading them into CAS.
- Promoting tables in CAS.
- Saving and using SASHDAT files.
- Overview of single-threaded processing in Base SAS.
- Overview of multi-threaded processing in SAS Viya.
- Modifying Base SAS DATA step programs to run in CAS.
- Understanding DATA step restrictions in CAS.
- Modifying SQL procedure code to execute in CAS using FedSQL.
- Using CAS-enabled Base SAS procedures.
- Creating and using user-defined formats in CAS.
- Using SAS functions in CAS.