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:
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 is part of the SAS Academy for Data Science 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(R) Programming II: Manipulating Data with the DATA Step course.

    • COURSE

      SAS Advanced Programming Professional 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 Advanced Programming Professional credential.

    SAS Clinical Trials Programming Professional Certification

    3
    • CERTIFICATION REVIEW

      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.



    Additional Programming Topics

    4
    • 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.
      • Virtual lab time to practice.


    SAS Viya Programming Certification

    5
    • 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.

    • COURSE

      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 Studio


    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.

    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