Star icon
Most Popular
Trending Arrow Icon
Trending

SAS Advanced Programmer Professional Certificate

blur

Learn Path Description

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.

Skills You Will Gain

Courses In This Learning Path

blur
icon

Total Duration

24 hours

icon

Level

Beginner

icon

Learn Type

Certifications

Structured Query Language (SQL) using SAS

Course Description

This course teaches you Structured Query Language (SQL), and how it can used in SAS programs for creating reports and querying your data. This course will teach you how to query and subset data, summarize and present data and combine tables using joins or set operators. You'll also learn how to create and modify tables and views and how to use data-driven macro variables using a question.

blur
icon

Total Duration

19 hours

icon

Level

Intermediate

icon

Learn Type

Certifications

SAS Macro Language by Coursera

This course teaches advanced techniques in the DATA step as well as data manipulation procedures.

Course Learning Objectives: (3-6 per course) A learner will be capable of performing text substitution in SAS codes, using macro variables and macro operations, automate and customize production of SAS codes, Conditionally or Iteratively construct SAS codes, and write self-modifying, data driven programs.

blur
icon

Total Duration

17 hours

icon

Level

Intermediate

icon

Learn Type

Certifications

Advanced SAS Programming Techniques

This course teaches advanced techniques in the DATA step as well as data manipulation procedures.

"By the end of this course, a learner will be able to Use additional functions (LAG, FINDC/FINDW, and COUNT/COUNTC/COUNTW). Use PRX functions to perform pattern matching. Rotate data, process repetitive code, and perform table-lookups with arrays. Perform table lookups, sort data with hash and iterator objects. Use the FORMAT procedure to create numeric templates. Use the FCMP procedure to create custom functions.

blur