Course Details

Previous Page

Base SAS 9 Programming: Data Structures

Target Audience
Expected Duration
Lesson Objectives
Course Number

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.

Target Audience
Learners interested in programmatically working with data in SAS systems.


Expected Duration (hours)

Lesson Objectives

Base SAS 9 Programming: Data Structures

  • 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
  • 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
  • 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
  • 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
  • create and process an array and merge data sets in SAS
  • Course Number: