SAS Advanced Programming Professional Subscription
For programmers, statistical programmers, and data analysts who want to learn advanced programming techniques, how to process data using Structured Query Language (SQL), and use the SAS macro facility.
Unlock digital courses
Unlimited access to digital courses and books in this subscription.
Prepare for certification
Unlimited access to certification preparation materials.
Shareable digital badges
Earn a digital badge for each completed course.
Hands-on learning and practice
Get Full access to SAS software to practice as you learn.
About this Subscription
The SAS Advanced Programming Professional subscription includes everything that you need to master advanced SAS programming and data analytics techniques while working towards your SAS Advanced Programming Professional certification. It builds on the skills taught in the SAS Programming Learning Subscription which is the appropriate place for new SAS programmers to begin. This subscription includes additional topics, such as efficiency tips for database programming and high-performance data manipulation with SAS DS2. It also addresses programming on the SAS Viya platform, including leveraging the power of SAS Cloud Analytic Services (CAS) for accelerated processing using SAS steps, CASL, and Python.
Learn how to:
Process data using Structured Query Language (SQL) in the SAS environment.
Use the SAS macro facility to design, write, and debug dynamic macro programs.
Use advanced DATA step techniques and procedures to manipulate data.
Use advanced coding techniques such as arrays, hash objects and the FCMP procedure.
Tune SAS programs accessing relational database tables for optimized execution.
Use DS2 for advanced, high-performance data manipulation.
Understand how SAS code is processed on the SAS Viya platform.
Run SAS®9 programs on the SAS Viya platform.
Accelerate SAS code using SAS Cloud Analytic Services (CAS) on the SAS Viya platform.
Process data in CAS using the native CAS programming language (CASL).
Process data in CAS using Python and the SAS Wrapper for Analytics Transfer (SWAT) package.
Create, design, manage, and run SAS Viya jobs from SAS Studio.
Before taking courses in this subscription, it’s recommended that you complete SAS Programming 1: Essentials , which is available in instructor-led or free online e-learning. You might also be interested in additional courses included in the SAS Programming Learning Subscription.
Courses Included in Subscription
SAS Programming Overview
1
COURSE
SAS Programming: Getting Started
SHOW MORE ﹀
This journey will help you get started developing code in SAS. This collection of free learning assets provide a tour of what is possible with programming in either SAS 9 or SAS Viya.
SAS Advanced Programming Professional Certification
2
COURSE
SAS® SQL 1: Essentials
SHOW MORE ﹀
This course teaches you how to process SAS data using Structured Query Language (SQL).
COURSE
SAS® Macro Language 1: Essentials
SHOW MORE ﹀
This course focuses on using the SAS macro facility to design, write, and debug macro programs, with an emphasis on understanding how programs that contain macro code are processed.
COURSE
SAS® Programming 3: Advanced Techniques
SHOW MORE ﹀
This course is for SAS programmers who want to learn advanced techniques within the DATA step and procedures. The course builds on the concepts that are presented in the SAS Programming 2: Data Manipulation Techniques course.
CERTIFICATION PREP
SAS Certified Professional: Advanced Programming Using SAS 9.4
SHOW MORE ﹀
Once you've earned your SAS Certified Specialist: Base Programming Using SAS 9.4 credential, you can extend your programming knowledge to prepare for the SAS 9.4 Advanced Programming - Performance-Based Exam. You will learn how to work with SQL, the SAS Macro facility, and use advanced coding techniques such as arrays, hash objects, and PROC FCMP.
SAS Clinical Trials Programming Professional Certification
3
CERTIFICATION PREP
SAS Certified Professional: Clinical Trials Programming Using SAS 9.4
SHOW MORE ﹀
In preparation for this exam, you will demonstrate knowledge of the clinical trials process and data structures, apply statistical procedures to analyze clinical trials data, utilize macro programming for clinical trials data, and report clinical trials results. You will also learn to access, manage and transform clinical trials data.
This Certification requires a pre-requisite certification. You must hold a SAS Certified Specialist: Base Programming Using SAS 9.4 and/or the SAS Certified Professional: Advanced Programming Using SAS® 9.4.
CERTIFICATION PREP
Practice Exam: SAS Certified Clinical Trials Programming Professional
SHOW MORE ﹀
Welcome to the practice exam for the SAS® SAS Certified Professional: Clinical Trials Programming Using SAS 9.4 credential. Successful candidates should be able to do the following:
Demonstrate knowledge of the clinical trials process and data structures.
Access, manage and transform clinical trials data.
Apply statistical procedures to analyze clinical trials data.
Utilize macro programming for clinical trials data.
Modern Data Science with SAS® Viya® Workbench and Python
SHOW MORE ﹀
This course showcases how to manage a data science project using both SAS and Python to predict customer churn for a fictitious online personal styling service. Using SAS Viya Workbench, you’ll explore how to access, transform, and analyze data from cloud object storage and data lakehouses, then build machine learning models in both SAS and Python. By the end, you’ll be equipped to handle data exploration, model deployment, and integrate version control with GitHub in a modern cloud environment.
COURSE
SAS® Macro Language 2: Advanced Techniques
SHOW MORE ﹀
This course covers macro quoting functions, macro storage, and macro techniques for advanced data access, table lookup operations, advanced parameter validation, and macro windows.
COURSE
Efficiency Tips for Database Programming in SAS®
SHOW MORE ﹀
This class teaches you how to tune your SAS programs for faster execution, especially those that access relational database tables using SAS/ACCESS interfaces or SAS Viya data connectors.
COURSE
High-Performance Data Manipulation with SAS® DS2
SHOW MORE ﹀
This course teaches DS2 programming. DS2 is a fourth-generation SAS language, designed for advanced data manipulation. It blends DATA step and SQL syntax using modern programming structures and can process multiple rows of data in parallel in Base SAS and in supported massively parallel processing environments such as Hadoop, Teradata, and SAS Cloud Analytic Services (CAS). A brief introduction to SAS Viya and Cloud Analytic Services is included. The self-paced e-learning includes: Annotatable course notes in PDF format and virtual lab time to practice.
COURSE
SAS® Grid Computing for Programmers
SHOW MORE ﹀
This course provides an introduction to the SAS Grid environment and teaches how to submit SAS workload to the grid from a variety of different SAS products and user interfaces. The course includes hands-on exercises that run SAS applications with SAS Grid Manager and convert existing SAS programs to run on the grid.
SAS Viya Programming Certification
5
COURSE
SAS® Viya Overview
SHOW MORE ﹀
This course provides an overview of SAS Viya, including platform architecture, applications, and code development. Each demonstration is designed for learners to follow along and experience how SAS Viya supports every phase of the analytics lifecycle in a single integrated platform.
COURSE
Accelerating SAS® Code on the SAS® Viya® Platform
SHOW MORE ﹀
This course is for SAS programmers who want to learn how to run code on the SAS Viya platform. In the course, you first learn how you can easily run traditional SAS code in SAS Viya like you have in SAS 9. Then you learn how to modernize your SAS code to take advantage of SAS Cloud Analytic Services (CAS) on the platform to boost program performance. CAS is a high-performance in-memory analytic engine that performs massively parallel processing (MPP) on data of any size, working with multiple machines, CPUs, and threads for lightning-fast results. The course focuses on how to access, manage, analyze, and manipulate in-memory tables on the distributed CAS server using traditional SAS code as well as new coding techniques. This course is not intended for beginning SAS software users.
COURSE
High-Performance Data Processing with CASL in SAS® Viya®
SHOW MORE ﹀
In this course, you learn how to leverage SAS Cloud Analytic Services (CAS), the high-performance server that provides the run-time environment for data management and analytics on the SAS Viya platform. You learn how to access, explore, prepare, analyze, and summarize data using the native CAS programming language (CASL). CASL is a new scripting language designed to support the entire analytics life cycle.
CERTIFICATION PREP
SAS Viya Programming Certification Preparation
SHOW MORE ﹀
SAS certifications are globally recognized, so having them on your résumé proves you've received in-depth training from industry experts. These materials will help prepare you to earn the SAS Viya Programming Associate Certification and the SAS Viya Programming Specialist Certification.
Additional Viya Programming Topics
6
COURSE
SAS® Viya® and Python Integration Fundamentals
SHOW MORE ﹀
In this course, you learn to use the SWAT (SAS Wrapper for Analytics Transfer) package to take advantage of the SAS Cloud Analytic Services (CAS) engine in SAS Viya for massively parallel processing (MPP) using familiar Python syntax. You learn about SAS Viya and the CAS engine, how to leverage the strengths of the CAS engine and your local Python client, how to connect Python to CAS, and how to access and load data into CAS's MPP environment. You then learn to explore, analyze, and prepare the data on the CAS server, taking advantage of the distributed processing power using familiar Pandas API and CAS actions from the SWAT package. Lastly, you learn how to return summarized results from the CAS server to your local Python client for additional processing and visualization using native Python packages.
COURSE
Working with SAS® Viya® Jobs
SHOW MORE ﹀
This course provides information about how to create, design, manage, and run SAS Viya jobs from SAS Studio.This e-learning course includes virtual lab time to practice.
SAS Products Covered
Base SAS
SAS/ACCESS
SAS Viya
SAS Grid Computing
SAS Studio
SAS Visual Analytics
SAS Visual Statistics
Digital Badges
Earn a digital badge for each course that you complete and for each credential that you earn. Show off your achievements on your resume and in your social channels to highlight your skills and connect with potential employers.
“I think the self-paced training was the BEST I’ve ever taken. The videos were short and segmented correctly to keep my attention and the activities and quizzes were just enough to help my confidence.”
