SAS Advanced Programming Professional Subscription
|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:
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
SAS Programming: Getting StartedSHOW 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
SAS® SQL 1: EssentialsSHOW MORE ﹀This course teaches you how to process SAS data using Structured Query Language (SQL).
SAS® Macro Language 1: EssentialsSHOW 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.
SAS® Programming 3: Advanced TechniquesSHOW 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.
SAS Advanced Programming Professional Certification PreparationSHOW 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
Practice Exam: SAS Certified Clinical Trials Programming ProfessionalSHOW 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
SAS® Macro Language 2: Advanced TechniquesSHOW 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.
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.
High-Performance Data Manipulation with SAS® DS2SHOW 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
Accelerating SAS® Code on the SAS® Viya® PlatformSHOW 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.
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.
SAS Viya Programming Certification PreparationSHOW 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
SAS® Viya® and Python Integration FundamentalsSHOW 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.
Working with SAS® Viya® JobsSHOW 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 Viya
- SAS Studio
|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.
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.”