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.

This course can help prepare you for the following certification exam(s): SAS® Viya® Programming Specialist.

• Connect to SAS Cloud Analytic Services (CAS).
• Access and use caslibs.
• Load SAS data sets, CSV files, Microsoft Excel files, and DBMS tables 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.
• Write CASL code to execute CAS actions.

Who should attend

Formats available	Standard Duration
Classroom:	1 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.

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.
• Accessing DBMS data in CAS.
• Saving and dropping in-memory tables.

• Modifying DATA step code for CAS.
• Modifying SQL code for CAS.
• Defining CAS column data types.

• Using CAS-enabled Base SAS procedures.
• Understanding CASL syntax.
• Accessing, exploring, and summarizing data with CAS actions.