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.
Purchase this digital subscription to:
Digital courses
Unlimited access to digital courses and books.
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 LESS ︿

SAS Advanced Programming Professional Certification

2
  • COURSE

    SAS® SQL 1: Essentials
    SHOW LESS ︿
  • COURSE

    SAS® Macro Language 1: Essentials
    SHOW LESS ︿
  • COURSE

    SAS® Programming 3: Advanced Techniques
    SHOW LESS ︿
  • COURSE

    SAS Certified Professional: Advanced Programming Using SAS 9.4
    SHOW LESS ︿
    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.

    ENROLL

SAS Clinical Trials Programming Professional Certification

3
  • COURSE

    SAS Certified Professional: Clinical Trials Programming Using SAS 9.4
    SHOW LESS ︿
    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.


    ENROLL
  • COURSE

    Practice Exam: SAS Certified Clinical Trials Programming Professional
    SHOW LESS ︿
    Practice Exam: SAS Certified Clinical Trials Programming Professional

    ENROLL

Additional Programming Topics

4
  • COURSE

    Modern Data Science with SAS® Viya® Workbench: Unified Development with SAS®, Python, and R
    SHOW LESS ︿
  • COURSE

    SAS® Macro Language 2: Advanced Techniques
    SHOW LESS ︿
  • COURSE

    Improving SAS Program Efficiency
    SHOW LESS ︿
  • COURSE

    Efficiency Tips for Database Programming in SAS®
    SHOW LESS ︿
  • COURSE

    High-Performance Data Manipulation with SAS® DS2
    SHOW LESS ︿
  • COURSE

    SAS® Grid Computing for Programmers
    SHOW LESS ︿

SAS Viya Programming Certification

5
  • COURSE

    SAS® Viya Overview
    SHOW LESS ︿
  • COURSE

    Accelerating SAS® Code on the SAS® Viya® Platform
    SHOW LESS ︿
  • COURSE

    High-Performance Data Processing with CASL in SAS® Viya®
    SHOW LESS ︿
  • COURSE

    SAS Viya Programming Certification Preparation
    SHOW LESS ︿
    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.

    ENROLL

Additional Viya Programming Topics

6
  • COURSE

    SAS® Viya® and Python Integration Fundamentals
    SHOW LESS ︿
  • COURSE

    Working with SAS® Viya® Jobs
    SHOW LESS ︿
  • COURSE

    Working with SAS Viya Jobs: Advanced
    SHOW LESS ︿

Knowledge Badge

7
  • COURSE

    SAS SQL Essentials Knowledge Badge
    SHOW LESS ︿
    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.

    ENROLL

SAS Products Covered

  • Base SAS
  • SAS/ACCESS
  • SAS Viya
  • SAS Grid Computing
  • SAS Studio


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