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.

A quién va dirigido

Formatos disponibles	Duración
Presencial:	1.0 día
Live Web:	2 sesiones de medio día
e-learning:	7 horas/180 día licencia

Before attending this course, you should have nine months or more of SAS programming experience or have completed the Programación SAS 1: Introducción and Programación SAS 2: Gestión de Datos 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.

Este curso utiliza 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.