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.
START FREE TRIAL
Purchase this digital subscription to:
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

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.
    • Report clinical trials results.
    • Validate clinical trials data reporting.

    Enroll


Additional Programming Topics

4

  • COURSE

    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.

Knowledge Badge

7

  • KNOWLEDGE BADGE

    SAS SQL Essentials Knowledge Badge
    SHOW MORE ﹀
    To earn the SAS SQL Essentials Knowledge Badge, you must pass an open-book multiple-choice assessment covering how to process SAS data using Structured Query Language (SQL).You will demonstrate knowledge of querying and subsetting data, summarizing and presenting data, and combining tables using joins and set operators. You will also display your knowledge of SQL to create and modify tables and views, to create macro variables with PROC SQL, and to access DBMS data with SAS/ACCESS technology. This badge is intended for programmers and business analysts using the SAS SQL procedure.

SAS Products Covered

  • Base SAS
  • SAS/ACCESS
  • SAS Viya
  • SAS Grid Computing
  • SAS Studio
  • SAS Visual Analytics
  • SAS Visual Statistics


Digital Badges

Earn badges as you complete courses, pass knowledge assessments or certification exams. Then showcase your achievements to colleagues potential employers, and your social networks.

Certification Preparation

When you complete the courses in this subscription, you will have the demonstrated skills necessary to prepare you to earn the SAS Certified Professional: Advanced Programming Using SAS 9.4 credential and the SAS Certified Professional: Clinical Trials Programming Using SAS 9.4 credentials.

“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.”

Tony Mayo, SAS Customer