SAS 8 - Online Course

This series introduces users to the SAS 8 system, the basic data concepts and the structure of the SAS programming language. It discusses the basic statements used when coding SAS programs, using the SAS log to troubleshoot coding errors, and the different modes for executing SAS. The series also covers optional statements used to modify data, and statements and options available to program features in the DATA step. Creating specialized output and basic statistical procedures are also covered. Additional topics examined include using Display Manager to run SAS jobs interactively, SAS data libraries, using SQL in SAS, and combining and updating SAS data sets.

This series is for end users, programmers and business professionals who are new to SAS. This online course contains 9 lessons and should take approximately 38 hours to complete.

Lesson 1: Introduction (3.0) hours

Introduction teaches you how to describe the SAS System, examine data to be used with SAS, define terms related to SAS, and describe the structure and language of SAS. This course provides a preview of the SAS System and describes some of its software features and components. It also covers basic data concepts and the structure of the SAS programming language. Topics include SAS Preview, Data Basics, and SAS Language.

Lesson 2: Using SAS (4.0) hours

Using SAS teaches you how to code basic DATA and PROC steps in a SAS program, interpret a basic SAS log, select a mode for executing SAS, use Display Manager mode to write and submit a SAS program, and save and access SAS programs in Display Manager. This course discusses the basic statements used when coding SAS programs and explains how to use the SAS log to troubleshoot coding errors. It also presents the different modes for executing SAS. Topics include Using SAS Statements, Analyzing SAS Logs, and Executing the SAS System.

Lesson 3: Data Manipulation (4.0) hours

Data Manipulation teaches you how to select variables for the output data set, use an assignment statement to create variables, code SAS expressions, work with dates, process selected observations, create subsets of observations, and troubleshoot problems using SAS logs. This course covers optional SAS statements used to modify data so that more complex data analysis tasks can be performed. Topics include Reviewing the Course Program, Using Variables, Using Expressions, Working with Dates, Working with Observations, and Analyzing SAS Logs.

Lesson 4: DATA Step Programming (4.0) hours

DATA Step Programming teaches you how to sort a data set and establish sorted variable groups, use a previously created SAS data set, use observations in calculations, create total variables, use DO groups to control processing, produce reports using the DATA step, and analyze SAS logs with problems. This course describes statements and options available to program various features in the DATA step. Topics include Working with Sorted Data, Accumulating Totals, Writing Output, and Analyzing SAS Logs.

Lesson 5: Results (5.0) hours

Results teaches you how to use printing procedures to tailor reports, employ plotting and charting procedures to graphically represent SAS data sets, use SAS procedures to perform statistical analysis, use PROC REPORT to prepare reports that combine both summary and detail data, and analyze SAS logs with problems. This course describes SAS procedures used to create more informative and specialized output as well as some basic statistical procedures. Topics include Printing Basic Output, Simple SAS Statistics, PROC REPORT, and Analyzing SAS Logs.

Lesson 6: Display Manager System (4.0) hours

Display Manager System teaches you how to describe the features and components of Display Manager, manipulate the window environment with commands and function keys, enter, edit and submit a SAS program, save and retrieve programs, view and manipulate program output, use SAS Text Editor and Display Manager commands to modify text, and manage SAS files using Display Manager windows. This course explains how to use Display Manager, a full-screen facility that allows you to create and run SAS jobs interactively. Topics include Understanding Display Manager, Managing the Windowing Environment, Using Display Manager Windows, Using the SAS Text Editor, and Managing SAS Files.

Lesson 7: Data Libraries (5.0) hours

Data Libraries teaches you how to describe the model SAS uses to organize, reference and store SAS files, explain the SAS data set model and the use of indexes and passwords, use SAS procedures and Display Manager windows to manage and modify SAS data library files, and use SAS procedures and Display Manager windows to copy, move and delete SAS data library members. This course explains the model that SAS uses to store and access data in SAS files. It shows how to use SAS procedures and Display Manager windows to manage SAS data libraries and their members. Topics include Data Library Model, SAS Data Sets, Getting Information, Modifying Data Library Files, and Managing Data Library Members.

Lesson 8: Inputting Data and PROC SQL (4.0) hours

Inputting Data and PROC SQL teaches you how to describe various input styles used with the INPUT statement, use the INPUT and INFILE statements to handle external files, explain the basics of using SQL with SAS, and use PROC SQL to query data sets and generate reports. This course describes ways to create and manipulate SAS data sets, including an introduction to using the SQL procedure in SAS. Topics include Input Styles, Reading External Files, Introduction to SQL, and Using PROC SQL.

Lesson 9: Combining and Updating Data Sets (5.0) hours

Combining and Updating Data Sets teaches you how to create new data sets through concatenating, interleaving or merging observations, update a master data set with values from a transaction data set, manipulate a SAS data set in place, read a data set twice, determine the source of an observation, combine portions of data sets, read only certain observations, and access observations nonsequentially. This course presents various methods for combining and updating existing SAS data sets. Topics include Concatenating Data Sets, Interleaving and Merging Data Sets, Updating with UPDATE, Updating with MODIFY, and Using Other Techniques.