CASL Programming for Distributed Computing in SAS® Viya® (Coursera)

This is an advanced course, intended for learners with at least one year of programming experience with a modern language: (SAS, R, Python, SQL, and so on), and at least one year of experience working with data. To be successful in this course, you should have a general understanding of fundamental computer programming concepts and the data analytics lifecycle.

By the end of the course, you will be able to:

- Understand and use various SAS Viya servers.

- Connect to the CAS server to access and manage data.

- Use CASL to explore, prepare and analyze data.

- Create reports and visualizations using SAS Viya.

Course 2 of 3 in the Distributed Programming in SAS® Viya® for Data Analysts Specialization.

What You Will Learn

- Connect to the CAS server to access and manage data.

- Use CASL to prepare and analyze data.

- Create reports and visualizations using SAS Viya.

Syllabus

WEEK 1

Course Overview and Logistics

In this module you

Introduction to SAS Viya and CAS

In this module you examine some basic concepts, beginning with an overview of SAS Viya and the two main servers available for processing data: the SA Compute Server and the SAS Cloud Analytics Services (or CAS) server. Then you learn about caslibs, the mechanism for accessing data within the CAS server. Lastly, you will explore the SAS Studio environment and connect to the CAS server.

WEEK 2

CAS Language (CASL) Fundamentals

In this module you will learn the fundamentals of SAS's new scripting language called the CAS language, or CASL for short. You will learn about how CASL is very different from the traditional SAS programming language. Then you will learn dive into detail about its four main components: variable data types, statements, functions, and CAS actions.

WEEK 3

Connecting to CAS and Accessing Data

In this module you will learn to connect to the CAS server and access it's data. You will begin by making a connection to CAS and exploring the connection options. Then you will begin to learn more about Caslibs by exploring their attributes, data source files and in-memory tables and creating a user defined Caslib. Lastly you will learn about managing in-memory tables by loading, saving, promoting and deleting tables.

WEEK 4

Exploring and Validating Data

In this module you will learn about exploring and validating data using a variety of CAS actions and CASL techniques. You will begin by exploring a CAS table's structure by viewing the column attributes, previewing the table rows, working with the results of an action and more. Then you will learn about charactering data by finding the distinct and missing values in each column. Lastly, you learn about validating data by removing duplicate rows and creating a new CAS table that identifies bad data.

WEEK 5

Preparing Data

In this module you will learn about Preparing Data in CAS. You will begin by executing some common data manipulation using CAS actions techniques such as updating a table in place, creating a new table with computed columns, performing conditional processing, filtering rows and columns, converting column types, working with dates, imputing missing values, restructuring data, and even executing DATA step code in CAS. Lastly you will learn about how to execute fedSQL statements in the CAS server.

WEEK 6

Analyzing and Summarizing Data

In this module you will learn about Analyzing and Summarizing Data in CAS. You will begin by understanding the benefits and considerations of using the CAS server with the compute server for your data processing needs. Then you will execute a variety of actions to obtain summary statistics, frequency and crosstabulation reports. Lastly you will learn about how to process the results of the CAS server by using the SAS Output Delivery System (ODS) on the smaller summarized results to create data visualizations, or output to an external file types like PowerPoint, Word, Excel and PDF.