Before attending this course, you should have nine months or more of SAS programming experience, or have completed the SAS Programming 2: Data Manipulation Techniques, SAS SQL 1: Essentials, or SAS Macro Language 1: Essentials course. Specifically, you should be able to
- understand programming logic concepts
- use SAS software to access SAS libraries
- create and use SAS date values
- read, concatenate, merge, and match-merge SAS data sets
- use SAS functions to perform data manipulation and transformations
- use the FORMAT procedure to create user-defined formats
- use SQL to query and join tables.
This course addresses Base SAS, SAS Enterprise Guide, SAS Viya software.
Introduction- overview of SAS Viya
- accessing SAS libraries
- session-scope and global-scope caslibs
- accessing caslibs
- changing the active caslib
Loading Data into SAS Cloud Analytic Services (CAS)- overview of loading tables into CAS and saving the tables
- session-scope and global-scope tables
- accessing SAS data sets, CSV files, and Excel files and loading them into CAS
- promoting tables in CAS
- saving and using SASHDAT files
Modifying Base SAS Programs to Run in SAS Viya- 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 Procedures and Functions- using CAS-enabled Base SAS procedures
- creating and using user-defined formats in CAS
- using SAS functions in CAS