Course

Course Summary

Credit Type:

Course

ACE ID:

SASW-0002

Organization:

SAS Institute Inc.

Location:

Online

Length:

20 weeks (80 hours)

Dates Offered:

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

Minimum Passing Score:

80%

Supplemental Materials

Other offerings from SAS Institute Inc.

SAS Programmer Professional Certificate

(SASW-0001)

View All Courses