Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

Programming for SAS Viya

( Duration: 1 Day )

This Programming for SAS Viya training 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.

By attending Programming for SAS Viya workshop, delegates will learn 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

Nine months or more of SAS programming experience. Specifically, you should be able to do the following:

  • 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

The Programming for SAS Viya class is ideal for:

  • SAS programmers transitioning to SAS Viya

COURSE AGENDA

1

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
2

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 Microsoft Excel files and loading them into CAS
  • Promoting tables in CAS
  • Saving and using SASHDAT files
3

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
4

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

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X