• Online, Self-Paced
Course Description

Combining loops and arrays opens up some of the more powerful features of SAS programming. This course covers various do loop types, and introduces arrays in SAS. It goes on to cover further techniques for restructuring and combining data including match merges. Finally, it takes a brief look at SQL database connectivity in SAS. This course is one of a series that prepares you for the SAS certification exam, SAS Certified Base Programmer for SAS 9.

Learning Objectives

Iterative DO Loops

  • start the course
  • create a simple DO loop in SAS
  • create a DO WHILE loop in SAS
  • create a DO UNTIL loop in SAS
  • create a nested DO loop in SAS
  • reduce redundant code in a SAS program by creating a DO loop

SAS Arrays

  • describe the characteristics of arrays in SAS
  • create an array in SAS
  • process all the elements of an array in a SAS program
  • create variables in an array in SAS
  • perform calculations using arrays and the keyword OF in SAS
  • assign initial values in an ARRAY statement in SAS

Restructuring and Combining Data Sets

  • use the TRANSPOSE procedure to manipulate data sets in SAS
  • use the TRANSPOSE procedure to rotate data sets in SAS
  • perform a match-merge on SAS data sets
  • control a match-merge with OUTPUT, DROP, KEEP, FIRST and LAST
  • merge data sets with no common variable by using a series of separate DATA steps
  • use SAS/ACCESS LIBNAME to match-merge a SAS data set with an Excel workbook
  • use RENAME to match-merge data sets with same-named variables

Proc SQL

  • describe PROC SQL and use it to connect to a data set
  • use PROC SQL to query a table in SAS
  • use PROC SQL to join tables in SAS

Practice: Array Processing & Merges

  • create and process an array and merge data sets in SAS

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.