Course

Credit Type:
Course
ACE ID:
SASW-0002
Version:
1
Organization:
Location:
Online
Length:
20 weeks (80 hours)
Minimum Passing Score:
80
ACE Credit Recommendation Period:
Credit Recommendation & Competencies
Level Credits (SH) Subject
Upper-Division Baccalaureate 3 Software Engineering
Description

Objective:

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

The course objective is to gain experience in SAS programming using SAS 9 and 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 learners for the SAS Advanced Programming Professional certification exam.

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:

  • Course Overview and Data Setup Essentials
  • PROC SQL Fundamentals
  • SQL Joins
  • Subqueries
  • Set Operators
  • Using and Creating Macro Variables in SQL
  • Accessing DBMS Data with SAS/ACCESS
  • Case Study (Honors) and Certification Practice Exam
  • Introduction
  • SAS Macro Facility
  • Storing and Processing Text
  • Working with Macro Programs
  • Developing Macro Applications
  • Case Study (Honors) and Certification Practice Exam
  • Course Overview, Review, and Data Setup
  • Using Advanced Functions
  • Defining and Processing Arrays
  • Defining and Processing Hash Objects, and Using Utility Procedures
Instruction & Assessment

Instructional Strategies:

  • Audio Visual Materials
  • Computer Based Training
  • Lectures
  • Practical Exercises

Methods of Assessment:

  • Case Studies
  • Examinations
  • Quizzes
Supplemental Materials
Equivalencies