Online Course – SAS Certified Professional Certificate in SAS Advanced Programmer

Advance your career with SAS® certification. Gain the skills required to become a certified SAS® Advanced Programming Professional.

Suggested by: Coursera (What is Coursera?)

Start your Coursera.com free trial today
קורס אונליין - תעודה מקצועית מוסמכת בSAS Advanced Programmer של SAS

Professional Certificate

Intermediate level

No prior knowledge required

Time to complete the course

7-day free trial

No unnecessary risks

Skills you will acquire in the course

  • Experience in SAS programming using SAS 9
  • Data processing using SQL in the SAS environment
  • Using the SAS Macro Facility to design, write, and debug dynamic macro programs
  • Advanced DATA step techniques and procedures for data manipulation
  • Preparation for the SAS Advanced Programming Professional Certification Exam
  • Analyzing passenger claims at US airports using SQL
  • Automate supplier sales reporting and analysis using SAS macro language

What you will learn in the course

Courses for which the course is suitable

  • Data Analyst
  • Software developer
  • SAS programmer
  • Information Systems Analyst
  • SQL expert
  • Report developer
  • Data Project Manager
  • Business Analyst
  • Automated solutions developer
  • Sales Data Specialist

Professional Certificate – 3-course series

After completing this professional certificate program, you will have experience programming SAS using SAS 9 and will be able to process data using SQL 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.

Hands-on Learning Project

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

Details of the courses that make up the specialization

Structured Query Language (SQL) Course 1

• 26 hours • 4.9 (261 ratings)

Course Details

What will you learn?

  • Perform queries and divide data into groups.
  • Summarize and present data.
  • Combine tables using joins and group operators.
  • Create and edit tables and views.
  • Create data-based macro variables using a query.
  • Access DBMS data using SAS/ACCESS technology.

SAS Macro Language Course 2

• 20 hours • 4.8 (142 ratings)

Course Details

What will you learn?

  • Perform text replacement in SAS code.
  • Use macro variables and macro functions.
  • To automate and customize SAS code generation.
  • Build SAS code conditionally or recursively.
  • Write self-correcting data programs.

Advanced SAS Programming Techniques Course 3

• 17 hours • 4.8 (88 ratings)

Course Details

What will you learn?

  • Use additional functions (LAG, FINDC/FINDW, and COUNT/COUNTC/COUNTW).
  • Perform template matching using PRX functions.
  • Process recursive code, rotate data, and perform table lookups using arrays.
  • Perform table lookups and sort data using hash objects and hash iterators.
  • Create numeric formats using the FORMAT procedure.
  • Create custom functions using the FCMP procedure.

Related products