Grow Your Career with a SAS® Credential. Master the skills required for the SAS® Advanced Programming Professional certification.

4.9

stars

197 ratings

Peter Styliadis +2 more instructors

3,896 already enrolled

Offered By

SAS Advanced Programmer Professional CertificateSAS

What you will learn

Process data using Structured Query Language 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

About this Professional Certificate

5,168 recent views

When you complete this professional certificate program, you will have experience in SAS programming using SAS 9 and will be able to process data using Structured Query Language in the SAS environment, use the SAS macro facility to design, write, and debug dynamic macro programs, and use advanced DATA step techniques and procedures to manipulate data. These skills prepare you for the SAS Advanced Programming Professional certification exam.

Applied Learning Project

Two projects are included as honors lessons in this professional certificate program. Each project will demonstrate your comprehensive knowledge of the learned SAS programming skills. In the first project, you use SQL to analyze to analyze passenger claims at United States airports. In the second project, you use the SAS macro language to automate reporting and analysis of analysis of supplier sales.

Shareable Certificate

Earn a Certificate upon completion

100% online courses

Start instantly and learn at your own schedule.

Flexible Schedule

Set and maintain flexible deadlines.

Intermediate Level

Prior SAS programming knowledge is required, which can be acquired by completing the SAS Base Programmer Professional Certificate program.

Approximately 5 months to complete

Suggested pace of 4 hours/week

English

Subtitles: English, Arabic, French, Portuguese (European), Italian, Vietnamese, German, Russian, Spanish

Shareable Certificate

Earn a Certificate upon completion

100% online courses

Start instantly and learn at your own schedule.

Flexible Schedule

Set and maintain flexible deadlines.

Intermediate Level

Prior SAS programming knowledge is required, which can be acquired by completing the SAS Base Programmer Professional Certificate program.

Approximately 5 months to complete

Suggested pace of 4 hours/week

English

Subtitles: English, Arabic, French, Portuguese (European), Italian, Vietnamese, German, Russian, Spanish

What is a Professional Certificate?

Build the Skills to Get Job Ready

Whether you’re looking to start a new career, or change your current one, Professional Certificates on Coursera help you become job ready. Learn at your own pace, whenever and wherever it’s most convenient for you. Enroll today and explore a new career path with a 7 day free trial. You can pause your learning or end your subscription at any time.

Hands-On Projects

Apply your skills with hands-on projects and build a portfolio that showcases your job readiness to potential employers. You'll need to successfully finish the project(s) to earn your Certificate.

Earn a Career Credential

When you complete all of the courses in the program, you'll earn a Certificate to share with your professional network as well as unlock access to career support resources to help you kickstart your new career. Many Professional Certificates have hiring partners that recognize the Professional Certificate credential and others can help prepare you for a certification exam. You can find more information on individual Professional Certificate pages where it applies.

There are 3 Courses in this Professional Certificate

Course1

Course 1

Structured Query Language (SQL) using SAS

4.9

stars

173 ratings

•

45 reviews

Course Description

In this course, you learn about Structured Query Language (SQL) and how it can be used in SAS programs to create reports and query your data. “By the end of this course, a learner will be able to…” ● Query and subset data. ● Summarize and present data. ● Combine tables using joins and set operators. ● Create and modify tables and views. ● Create data-driven macro variables using a query. ● Access DBMS data with SAS/ACCESS technology.

Course2

Course 2

SAS Macro Language

4.8

stars

93 ratings

•

17 reviews

In this course, you learn advanced techniques within the DATA step and procedures to manipulate data.

Course3

Course 3

Advanced SAS Programming Techniques

4.9

stars

59 ratings

•

14 reviews

In this course, you learn advanced techniques within the DATA step and procedures to manipulate data.

“By the end of this course, a learner will be able to…” ● Use additional functions (LAG, FINDC/FINDW, and COUNT/COUNTC/COUNTW). ● Perform pattern matching using PRX functions. ● Process repetitive code, rotate data, and perform table lookups using arrays. ● Perform table lookups and sort data using hash and hash iterator objects. ● Create numeric templates using the FORMAT procedure. ● Create custom functions using the FCMP procedure.

Instructors

Offered by

SAS

Through innovative software and services, SAS empowers and inspires customers around the world to transform data into intelligence. SAS is a trusted analytics powerhouse for organizations seeking immediate value from their data. A deep bench of analytics solutions and broad industry knowledge keep our customers coming back and feeling confident. With SAS®, you can discover insights from your data and make sense of it all. Identify what’s working and fix what isn’t. Make more intelligent decisions. And drive relevant change.

Frequently Asked Questions

What is the refund policy?
If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.
Can I just enroll in a single course?
Yes! To get started, click the course card that interests you and enroll. You can enroll and complete the course to earn a shareable certificate, or you can audit it to view the course materials for free. When you subscribe to a course that is part of a Certificate, you’re automatically subscribed to the full Certificate. Visit your learner dashboard to track your progress.
Is this course really 100% online? Do I need to attend any classes in person?
This course is completely online, so there’s no need to show up to a classroom in person. You can access your lectures, readings and assignments anytime and anywhere via the web or your mobile device.
What background knowledge is necessary?
Prior SAS programming knowledge is required, which can be acquired by completing the SAS Programming specialization.
Do I need to take the courses in a specific order?
We recommend you take them in this order:
Structured Query Language (SQL) Using SAS
SAS Macro Language
Advanced SAS Programming Techniques
What will I be able to do upon completing the Specialization?
You will have completed the course work to prepare you for the SAS Advanced Programming Professional certification.

More questions? Visit the Learner Help Center.