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 +2 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

  •   Data Integration
  •   Debugging
  •   Data Access
  •   Data Validation
  •   Data-Driven Decision-Making
  •   Data Processing
  •   Data Manipulation
  •   Statistical Programming
  •   Query Languages
  •   SAS (Software)
  •   Database Management Systems
  •   Data Transformation

    • Professional Certificate - 3 course series

    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.

    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.

    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.

    “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 Macro Language

    Advanced SAS Programming Techniques

    ©2025  ementorhub.com. All rights reserved