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.

• 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 DATA step code to execute in CAS.
• Modify SQL procedure code to execute in CAS using FedSQL.
• Use CAS-enabled procedures and formats.

Who should attend

Formats available	Standard Duration
Classroom:	1.0 day
Live Web Classroom:	2 half-day session(s)	System Requirements
e-Learning:	7 hours/180 day license	System Requirements

Before attending this course, you should have nine months or more of SAS programming experience or have completed the SAS® Programming 1: Essentials and SAS® Programming 2: Data Manipulation Techniques courses. Specifically, you should be able to do the following:

• Understand programming logic concepts.
• Use SAS software to access SAS libraries.
• Read and manipulate data with the DATA step.
• Use SQL to query and join tables.
• Use the MEANS and FREQ procedures to summarize data.
• Use the FORMAT procedure to create user-defined formats.

This course addresses SAS Studio, SAS Viya software.

• Overview of SAS Viya.
• Overview of SAS Viya servers.

• Understanding caslibs.
• Loading data to in-memory tables.
• Saving and dropping in-memory tables.

• Modifying DATA step code for CAS.
• Modifying SQL code for CAS.

• Using CAS-enabled Base SAS procedures.
• Creating and using user-defined formats in CAS.