This course is part of the Distributed Programming in SAS® Viya® for Data Analysts Specialization

Peter Styliadis +1 more instructor

Offered By

Distributed Programming in SAS® Viya® for Data Analysts SpecializationSAS

About this Course

3,467 recent views

Welcome to the CASL Programming for Distributed Computing in SAS Viya course. SAS Viya is an AI, analytic and data management platform running on a scalable, distributed, cloud-native architecture. 
In this course you will learn how how to use the native CAS programming language (CASL) to leverage SAS Cloud Analytics Services (CAS), the high-performance, in-memory analytics and distributed computing engine in SAS Viya . You will learn how to use CASL to access, explore, prepare, analyze, and summarize data in the CAS server's massively parallel processing environment.

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.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Coursera Labs

Includes hands on learning projects.

Learn more about Coursera Labs

Course 2 of 3 in the

Distributed Programming in SAS® Viya® for Data Analysts Specialization

Advanced Level

You should have an understanding of fundamental computer programming concepts, and at least one year of programming and data analysis experience.

Approx. 29 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

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.

Skills you will gain

SAS Studio
Data Manipulation
CASL
Data Analysis
SAS Viya

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Coursera Labs

Includes hands on learning projects.

Learn more about Coursera Labs

Course 2 of 3 in the

Distributed Programming in SAS® Viya® for Data Analysts Specialization

Advanced Level

You should have an understanding of fundamental computer programming concepts, and at least one year of programming and data analysis experience.

Approx. 29 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

Instructors

Peter Styliadis

Senior Technical Training Consultant

SAS Education

13,987 Learners

5 Courses

Stacey Syphus

Offered by

SAS

Through innovative software and services, SAS empowers and inspires customers around the world to transform data into intelligence. SAS is a trusted analytics powerhouse for organizations seeking immediate value from their data. A deep bench of analytics solutions and broad industry knowledge keep our customers coming back and feeling confident. With SAS®, you can discover insights from your data and make sense of it all. Identify what’s working and fix what isn’t. Make more intelligent decisions. And drive relevant change.

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

Syllabus - What you will learn from this course

Week1

Week 1

1 hour to complete

Course Overview and Logistics

1 hour to complete

2 videos (Total 3 min), 3 readings, 1 quiz

1 hour to complete

Introduction to SAS Viya and CAS

1 hour to complete

8 videos (Total 13 min)

Week2

Week 2

5 hours to complete

CAS Language (CASL) Fundamentals

5 hours to complete

27 videos (Total 65 min), 1 reading, 15 quizzes

27 videos

Module Overview1mSubmitting Code to CAS58sCASL Programming Components4mRunning CASL Code from SAS37sIntroduction to CAS Actions32sCAS Action Sets40sCAS Actions Syntax1mDemo: Executing CAS Actions2mCreating Numeric and String Variables52sWorking With Numeric Data1mWorking With String Data2mDemo: Creating and Using String and Numeric Variables8mIntroduction to CASL Arrays2mAccessing Array Elements1mUsing an Array in a CAS Action1mIterating Through an Array2mDemo: Using an Array with CAS Actions3mArray Operators3mUsing Array Functions1mIntroduction to CASL Dictionaries1mCreating a Dictionary in CASL3mAccessing and Modifying a Dictionary1mUsing a Dictionary in a CAS Action2mDemo: Using Dictionaries with CAS Actions6mCAS Actions Return a Dictionary1mDemo: Working with CAS Action Results5mIterating Through a Dictionary1m

1 reading

Summary of CAS Language (CASL) Fundamentals30m

14 practice exercises

Activity: Use the CAS API15mActivity: Find the EXISTS Built-In Function15mActivity: Find the loadTable CAS Action15mActivity: Create and Print a CASL Variable15mActivity: Use Variables in CAS Actions15mActivity: Create and Access an Array15mActivity: Iterate Over an Array15mActivity: Find the UNIQUE Built-In Function15mActivity: Create and Describe a Dictionary15mActivity: Access a Dictionary Value15mActivity: Use a Dictionary in a CAS Action15mActivity: Store the Results of a CAS Action15mActivity: Iterate Over a Dictionary15mReview of CASL Fundamentals30m

Week3

Week 3

5 hours to complete

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.

5 hours to complete

22 videos (Total 66 min), 1 reading, 10 quizzes

22 videos

Module Overview40sExploring and Managing the CAS Connection1mDemo: Exploring and Managing a CAS Session5mAccessing Data in the SAS Compute Server2mAccessing Data in CAS3mExploring Caslibs2mDemo: Adding and Exploring Caslibs3mCaslib Attributes2mDemo: Exploring a Caslib's Attributes4mViewing Caslibs in SAS Studio33sDemo: Assigning a Libref to a Caslib5mLoading Files into In-Memory Tables43sLoading Server-Side Files2mDemo: Loading Server-Side Data into CAS6mLoading Client-Side Files2mDemo: Loading Client-Side Data into CAS4mAccessing and Loading Database Tables2mPromoting Tables to Global Scope3mDemo: Promoting a Table6mSaving In-Memory Tables1mDemo: Saving In-Memory Tables3mDropping In-Memory Tables21s

1 reading

Summary of Connecting to CAS and Accessing Data30m

9 practice exercises

Activity: Identify the Active Caslib15mActivity: Explore Available Caslibs15mActivity: Load a Server-Side File into Memory15mActivity: Load a Client-Side File into Memory15mActivity: Promote an In-Memory Table15mActivity: Save an In-Memory Table15mActivity: Drop an In-Memory Table15mPractice: Load a Server-Side File into Memory30mReview of Connecting to CAS and Accessing Data30m

Week4

Week 4

6 hours to complete

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.

6 hours to complete

18 videos (Total 59 min), 2 readings, 14 quizzes

18 videos

Module Overview46sExploring Table Structure33sA Quick Look at Table Values1mWorking With Action Results2mExploring Action Results1mAccessing Result Table Values3mDemo: Creating an Array From a Result Table Column10mResult Table Computed Columns1mSaving CASL Results2mDemo: Saving CASL Results6mCharacterizing Data2mDemo: Characterizing Data4mValidating Data1mIdentifying and Isolating Duplicates2mIntroduction to Table.copyTable4mSubsetting Rows and Columns in CopyTable40sUsing copyTable to Validate Data2mDemo: Validating Data Using CASL10m

2 readings

Alternative to table.copyTable for SAS Viya for Learners10mSummary of Exploring and Validating Data30m

13 practice exercises

Activity: View Column Attributes1mActivity: Display the First Five Rows of a Table15mActivity: View the Results of a CAS Action15mActivity: Filter a Result Table15mActivity: Create a Computed Column in a Result Table15mActivity: Save a Result Table as a SAS Data Set15mPractice: Explore a CAS Table Using Actions30mActivity: Print Rows of a Result Table15mPractice: Identify Categorical Columns for Analysis30mActivity: Remove Duplicate Rows of a Table15mActivity: Specify the Length of a Computed Column15mPractice: Document Invalid Data30mReview of Exploring and Validating Data30m

Week5

Week 5

6 hours to complete

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.

6 hours to complete

29 videos (Total 91 min), 2 readings, 13 quizzes

29 videos

Module Overview49sData Preparation in CAS3mIntroduction46sUpdating a Table in Place3mUsing Conditional Logic in the Update Action2mDemo: Updating a Table in Place8mBenefits and Considerations When Updating a Table1mCreating a New In-Memory Table1mFormatting Calculated Columns2mWorking with SAS Date and Time Values3mDemo: Working with Dates and Times6mData Type Conversion4mDemo: Converting Column Data Types5mPreparing the Cars Table15sDemo: Preparing the Cars Table7mBenefits and Considerations When Creating a New Table51sUsing the DataStep CAS Action2mAltering Table Metadata2mImputing Missing Values2mDemo: Imputing Missing Values5mTranspose Action1mDemo: Transposing a Table4mDynamically Removing Outliers1mDemo: Dynamically Removing Outliers7mIntroduction to the FedSql Action Set2mSimple FedSQL Query1mCreating CAS Tables Using SQL1mJoins33sDemo: Imputing Missing Values5m

2 readings

Reminder to use table.partition10mSummary of Preparing Data30m

12 practice exercises

Activity: Find the SCAN Common Function15mActivity: Load a Client-Side File into Memory15mActivity: Update a Column in Place15mActivity: Format a Computed Column15mActivity: Convert a Column's Data Type15mPractice: Update a Table in Place30mPractice: Create a New CAS Table30mActivity: Execute DATA Step Code with an Action15mActivity: Add a Label to a Column15mPractice: Impute Missing Values30mActivity: Execute an SQL Query with an Action15mReview of Preparing Data30m

Week6

Week 6

5 hours to complete

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.

5 hours to complete

18 videos (Total 75 min), 2 readings, 10 quizzes

18 videos

Module Overview46sIntroduction3mSummary Statistics Using the Summary Action1mDemo: Generating Descriptive Statistics Using Summary6mSummary Statistics Using the Aggregate Action3mDemo: Generating Descriptive Statistics Using Aggregate6mFrequency and Crosstabulation Reports4mDemo: Creating Frequency and Crosstabulation Reports7mAdditional Analytic Actions17sDemo: Additional Analytic Actions6mIntroduction to Data Visualization and Reporting46sBest Practice1mDemo: Data Visualization Using CAS Tables9mUsing the SAS Output Delivery System1mDemo: Exporting Results10mGetting the Best Performance3mBest Practices1mDemo: Getting the Best Performance5m

2 readings

About Exporting Results10mSummary of Analyzing and Summarizing Data30m

9 practice exercises

Activity: Find the Summary Action1mActivity: Execute the Summary Action1mActivity: Execute the Aggregate Action15mActivity: Execute the freqTab Action15mPractice: Generate Descriptive Statistics Using Summary30mPractice: Generate a Crosstabulation Report30mActivity: Create a Graph from a CAS Table15mPractice: Create a Bar Chart from a Summarized CAS Table30mReview of Analyzing and Summarizing Data30m

About the Distributed Programming in SAS® Viya® for Data Analysts Specialization

SAS Viya is a cloud-enabled, in-memory analytics engine that provides quick, accurate and reliable analytical insights. This professional certificate program is designed for experienced SAS programmers who want to leverage the power of SAS Cloud Analytics Services (CAS) to access, manage, and analyze in-memory tables. You will write SAS programs to execute in CAS using standard SAS syntax, including the DATA step, FedSQL, and procedures. You will also use the native CAS programming language (CASL) to process in-memory data. These skills prepare you for the SAS Viya Programming certification exams.

Frequently Asked Questions

When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

More questions? Visit the Learner Help Center.

Build employee skills, drive business results

Discover Coursera for Business

CASL Programming for Distributed Computing in SAS® Viya®

About this Course

What you will learn

Skills you will gain