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.

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.

Structured Query Language (SQL) using SAS 

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

Course Learning Objectives: (3+ per course)
“By the end of this course, a learner will be able to…”
●	Perform text substitution in SAS code.
●	Use macro variables and macro functions.
●	Automate and customize the production of SAS code.
●	Conditionally or iteratively construct SAS code.
●	Write self-modifying, data-driven programs.

SAS Macro Language

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.

SAS Advanced Programmer Professional Certificate

About the Program

Description

Deliverables

0 Credits

Academic Excellence

Outcomes

IBM Data Analytics with Excel and R$375

Google Business Intelligence$375

IBM Data Science$375

IBM Data Analyst$375

Google Data Analytics$375

Google Advanced Data Analytics$375

Microsoft Power BI Data Analyst$375

IBM Business Intelligence (BI) Analyst$375

Tableau Business Intelligence Analyst$375

Applied Generative AI Specialization$5,350