Course

Credit Type:
Course
ACE ID:
SASW-0002
Version:
2
Organization:
Location:
Online
Length:
2 months at 10 hours a week
Minimum Passing Score:
80
ACE Credit Recommendation Period:
Credit Recommendation & Competencies
Level Credits (SH) Subject
Upper-Division Baccalaureate 3 SAS Advanced Programmer
Description

Objective:

This course is offered through Coursera, which is an ACE Authorized Instructional Platform.

The certificate objective is to deepen learners’ expertise in SAS programming using SAS 9. By the end of this program, students will be proficient in processing data using Structured Query Language (SQL) within the SAS environment, creating and debugging dynamic macro programs using the SAS macro facility, and applying advanced DATA step techniques and procedures for complex data manipulation tasks. These high-level programming skills align with the requirements of the SAS® Advanced Programming Professional certification exam, supporting learners in advancing their analytics careers.

To reinforce mastery of advanced concepts, learners complete two hands-on projects featured as honors lessons. The first project challenges students to apply SQL techniques to analyze real-world airport passenger claims data. In the second project, learners utilize the SAS macro language to automate the reporting and analysis of supplier sales performance, simulating enterprise-level data tasks.

This certificate is ideal for learners who have foundational knowledge of SAS and are looking to advance their skills for roles in data engineering, analytics, or business intelligence.

Learning Outcomes:

  • 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

General Topics:

  • Accessing DBMS Data with SAS/ACCESS
  • Essentials
  • PROC SQL Fundamentals
  • SQL Joins
  • Set Operators
  • Subqueries
  • Test Case Study Results
  • Using and Creating Macro Variables in SQL
  • Developing Macro Applications
  • SAS Macro Facility
  • Storing and Processing Text
  • Working with Macro Programs
  • Defining and Processing Arrays
  • Defining and Processing Hash Objects
  • Using Advanced Functions
  • Using Utility Procedures
Instruction & Assessment

Instructional Strategies:

  • Audio Visual Materials
  • Classroom Exercise
  • Computer Based Training
  • Discussion
  • Lectures
  • Project-based Instruction

Methods of Assessment:

  • Examinations
  • Other
  • Quizzes
  • Peer review graded projects with rubric
Supplemental Materials
Equivalencies