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

Stacey Syphus +1 more instructor

Offered By

Distributed Programming in SAS® Viya® for Data Analysts SpecializationSAS

About this Course

4,253 recent views

Welcome to the SAS 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 to modify existing Base SAS programs to execute in SAS Viya. The programs you create will leverage the power of SAS Cloud Analytic Services (CAS) to access, manage, and analyze in-memory tables. 
This is an advanced course, intended for learners with SAS programming experience. To be successful,  you should be able to access data via SAS libraries, read and prepare data with the DATA step, query data using PROC SQL, and summarize data with the MEANS and FREQ procedures. This foundational knowledge can be acquired in the Coursera SAS Programmer specialization.

By the end of the course, you will be able to:
- Load data into SAS Cloud Analytic Services
- Modify DATA step and SQL procedure code to execute in CAS
- Use CAS-enabled procedures
- Write CASL code to execute CAS actions

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 1 of 3 in the

Distributed Programming in SAS® Viya® for Data Analysts Specialization

Advanced Level

You should be familiar with the SAS programming language, including SAS libraries, DATA step, PROC SQL, and the MEANS and FREQ procedures.

Approx. 13 hours to complete

English

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

Try Coursera for Business

What you will learn

Load data into SAS Cloud Analytic Services
Modify DATA step and SQL procedure code to execute in CAS
Use CAS-enabled procedures and CAS actions

Skills you will gain

CASL
SAS Viya
SAS Programming
SAS Studio

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 1 of 3 in the

Distributed Programming in SAS® Viya® for Data Analysts Specialization

Advanced Level

You should be familiar with the SAS programming language, including SAS libraries, DATA step, PROC SQL, and the MEANS and FREQ procedures.

Approx. 13 hours to complete

English

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

Try Coursera for Business

Instructors

Stacey Syphus

Peter Styliadis

Senior Technical Training Consultant

SAS Education

13,763 Learners

5 Courses

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

12 minutes to complete

Specialization Overview

12 minutes to complete

1 video (Total 2 min), 1 reading

1 hour to complete

Course Overview and Logistics

1 hour to complete

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

1 hour to complete

Introduction to SAS Viya

1 hour to complete

11 videos (Total 20 min)

11 videos

Module Overview37sSAS Viya in the SAS Platform1mSAS Viya Programming Interfaces1mSAS Viya Servers and Processing Environments1mDemo: Running a SAS Program in SAS Studio5mThe CAS Language and CAS Actions2mParallel Processing in CAS1mCompute Server or CAS?1mServer Strengths2mProcessing Code in CAS59sDemo: Connecting to a CAS Server Using a Snippet1m

2 practice exercises

Activity - Start a CAS Session15mReview of Introduction to SAS Viya30m

Week2

Week 2

4 hours to complete

Loading Data into SAS Cloud Analytic Services (CAS)

4 hours to complete

22 videos (Total 36 min)

22 videos

Module Overview41sSAS Libraries1mAccessing Data through Caslibs32sCaslib Attributes2mAssigning Library References to a Caslib1mPredefined Caslibs17sDemo: Accessing Caslibs3mCASUTIL Procedure53sManually Adding Caslibs2mSetting the Default Caslib27sDemo: Defining a New Caslib4mLoading Files into In-Memory Tables1mLoading Client-Side Data Source Files46sDemo: Loading Client-Side SAS Data into CAS5mLoading Other Client-Side Data Source Files17sIn-Memory Table Scope1mLoading Server-Side Data Source Files2mAccessing Database Tables2mEnding a CAS Session33sSaving In-Memory Tables48sDemo: Saving a SASHDAT File in a Caslib1mDropping In-Memory Tables16s

11 practice exercises

Activity - Create a SAS Library and Add a Folder Shortcut15mActivity - View Caslib Files and Tables15mActivity - Create a Caslib and Compare it to a SAS Library15mREQUIRED Activity - Create an Autoexec File to Start a CAS Session15mActivity - Promote an In-Memory Table1mPractice: Load a Client-Side SAS Data Set and Excel File into CAS Using a Snippet30mQuestion - Loading DBMS Data5mActivity - Compare Load Time for SASHDAT Files15mActivity - Delete a Table from a Caslib15mPractice: Save a Copy of the In-Memory Table as a SASHDAT File30mReview of Loading Data into CAS30m

Week3

Week 3

4 hours to complete

Modifying Base SAS Programs to Run in SAS Cloud Analytic Services (CAS)

4 hours to complete

19 videos (Total 36 min)

19 videos

Module Overview1mDATA Step Processing in CAS2mDemo: Modifying a DATA Step to Run in CAS4mSingle- or Multi-Threaded Processing2mDemo: Summarizing in CAS with the Sum Statement2mDATA Step with By-Group Processing1mDemo: By-Group Processing in CAS2mDATA Step Restrictions in CAS4mComparing the SQL and FEDSQL Procedures1mDemo: Executing SQL Queries in CAS Using PROC FEDSQL1mAdditional Differences Between PROC SQL and PROC FEDSQL50sPROC FEDSQL in CAS46sAltering In-Memory Tables1mDemo: Creating an In-Memory Table Using PROC FEDSQL4mColumn Data Types29sCHAR Data Columns1mVARCHAR Data Columns1mNumeric Data Types33sMapping Data Types2m

10 practice exercises

Activity - Examine Threads Used with a DATA Step15mActivity - Compare Single- and Multiple-Threaded Process15mActivity - Threads for By-Group Processing15mActivity - Add Detailed Log Messages15mPractice: Modify a DATA Step to Run in CAS (Creating New Variables)30mActivity - Convert PROC SQL to PROC FEDSQL15mPractice: Modify a Simple SQL Query to Run in CAS Using FedSQL30mQuestion - Character Value Storage5mActivity - Compare CHAR and VARCHAR Column Lengths15mReview of Modifying Base SAS Programs to Run in CAS30m

Week4

Week 4

4 hours to complete

Using CAS-Enabled Procedures and CAS Actions

4 hours to complete

16 videos (Total 26 min)

16 videos

Module Overview51sSAS Procedures in SAS Viya33sSAS Foundation Procedures1mSAS Foundation Procedures: Workarounds for CAS2mCAS-Enabled Base SAS Procedures1mPROC MDSUMMARY29sDemo: Producing Descriptive Statistics in CAS Using PROC MDSUMMARY2mAdditional CAS-Enabled Base SAS Procedures1mWhat is CASL?1mCAS Action Sets1mWhy Learn CASL?35sLoading Data to Memory1mDemo: Using a CAS Action to Load a Table into Memory2mExploring Data1mPreparing and Analyzing Data2mDemo: Summarizing Data and Benchmarking CASL3m

10 practice exercises

Activity - Procedures that use CAS15mActivity - Run PROC MEANS in CAS15mPractice: Use the MDSUMMARY Procedure to Generate Statistics in CAS30mActivity - View CASL History15mActivity - Explore CAS Action Documentation15mActivity - Load Excel File to a Table15mActivity - Generate Frequency Report15mActivity - Compute Summary Statistics15mPractice: Use CAS Actions to Load an Excel File and Generate Frequency Counts30mReview of Using CAS-Enabled Procedures and CAS Actions 30m

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.
What is the refund policy?
If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.
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

SAS® Programming for Distributed Computing in SAS® Viya®

About this Course

What you will learn

Skills you will gain