SAS Advanced Programmer Professional Certificate

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

Instructors: Peter Styliadis

9,587 already enrolled

Included with Coursera Plus

Learn more

3 course series

Earn a career credential that demonstrates your expertise

4.8

(334 reviews)

Intermediate level

Recommended experience

Flexible schedule

2 months, 10 hours a week

Learn at your own pace

Build toward a degree

Learn more

3 course series

Earn a career credential that demonstrates your expertise

4.8

(334 reviews)

Intermediate level

Recommended experience

Flexible schedule

2 months, 10 hours a week

Learn at your own pace

Build toward a degree

Learn more

What you'll 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

Skills you'll gain

Details to know

Shareable certificate

Add to your LinkedIn profile

Industry certification

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Prepare for a career as a Business Intelligence Analyst

Receive professional-level training from SAS
Demonstrate your technical proficiency
Earn an employer-recognized certificate from SAS
Prepare for an industry certification exam

Explore this role

$125,888

median entry-level salary for Business Intelligence Analyst¹

74,264

job openings for Business Intelligence Analyst in United States¹

Professional Certificate - 3 course series

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.

Structured Query Language (SQL) using SAS

Course 126 hours

What you'll learn

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.

SAS Macro Language

Course 220 hours

What you'll learn

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

Advanced SAS Programming Techniques

Course 317 hours

What you'll learn

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.

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Build toward a degree

When you complete this Professional Certificate, you may be able to have your learning recognized for credit if you are admitted and enroll in one of the following online degree programs.¹

This Professional Certificate has ACE® recommendation. It is eligible for college credit at participating U.S. colleges and universities. Note: The decision to accept specific credit recommendations is up to each institution.

Learn more

Instructors

Peter Styliadis

SAS

5 Courses20,971 learners

Offered by

SAS

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

New to Data Analysis? Start here.

10 Small Business Bookkeeping Tips

November 29, 2023

Article

What Is Business Accounting? (And How to Manage Yours)

November 20, 2024

Article

Accounting Degrees: Courses, Careers, Salaries

September 3, 2024

Article

Double-Entry Accounting: What It Is and How It Works

January 21, 2025

Article

Open new doors with Coursera Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Learn more

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Explore degrees

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Learn more

Frequently asked questions

Prior SAS programming knowledge is required, which can be acquired by completing the SAS Programming specialization.

We recommend you take them in this order:

Structured Query Language (SQL) Using SAS
SAS Macro Language
Advanced SAS Programming Techniques

You will have completed the course work to prepare you for the SAS Advanced Programming Professional certification.

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.

Goals

Subjects

SAS Advanced Programmer Professional Certificate

What you'll learn

Skills you'll gain

Details to know

See how employees at top companies are mastering in-demand skills

Prepare for a career as a Business Intelligence Analyst

Professional Certificate - 3 course series

Structured Query Language (SQL) using SAS

What you'll learn

SAS Macro Language

What you'll learn

Advanced SAS Programming Techniques

What you'll learn

Earn a career certificate

Build toward a degree

Bachelor of Information Technology

Instructors

Offered by

Why people choose Coursera for their career

New to Data Analysis? Start here.

10 Small Business Bookkeeping Tips

What Is Business Accounting? (And How to Manage Yours)

Accounting Degrees: Courses, Careers, Salaries

Double-Entry Accounting: What It Is and How It Works

Open new doors with Coursera Plus

Advance your career with an online degree

Join over 3,400 global companies that choose Coursera for Business

Frequently asked questions

More questions

SAS Advanced Programmer Professional Certificate

What you'll learn

Skills you'll gain

Details to know

See how employees at top companies are mastering in-demand skills

Prepare for a career as a Business Intelligence Analyst

Professional Certificate - 3 course series

Structured Query Language (SQL) using SAS

What you'll learn

SAS Macro Language

What you'll learn

Advanced SAS Programming Techniques

What you'll learn

Earn a career certificate

Build toward a degree

Bachelor of Information Technology

Instructors

Offered by

Why people choose Coursera for their career

New to Data Analysis? Start here.

10 Small Business Bookkeeping Tips

What Is Business Accounting? (And How to Manage Yours)

Accounting Degrees: Courses, Careers, Salaries

Double-Entry Accounting: What It Is and How It Works

Open new doors with Coursera Plus

Advance your career with an online degree

Join over 3,400 global companies that choose Coursera for Business

Frequently asked questions

What background knowledge is necessary?

Do I need to take the courses in a specific order?

What will I be able to do upon completing the Specialization?

More questions