Amadeus cookies policy - you'll see this message only once.

Amadeus use cookies on this website. They help us to know a little bit about you and how you use our website, which improves the browsing experience and marketing - both for you and for others. They are stored locally on your computer or mobile device. To accept cookies, continue browsing as normal. Or, go to the privacy policy for more information.

Fast Track Fundamentals and Programming

Course Length - 5 Days

This course serves as a five day boot camp, fast tracking attendees who have little to no knowledge of SAS to the point where they can confidently work with the SAS programming language. After the course, attendees will be able to use SAS software to read their data, manage, manipulate and summarise their data, solve problems, use conditional logic, use iterative processing, create formats, combine files and produce tables and listings of data.

Daily Course Times: 9:15 - 16:45.

Audience

This fast track course is designed for Computer Users who wish to learn the key principles of programming within the SAS System.



Prerequisites

There are no prerequisites for this course.

Topics

FT1 Introduction

  • What is SAS?
  • SAS Software and Solutions
  • Introduction to the SAS Environment
  • Using the Display Manager System (DMS)
  • Using SAS Enterprise Guide
  • Working with SAS Programs in Enterprise Guide
  • Using SAS Studio
  • SAS System Walkthrough

FT2 Writing SAS Programs

  • Working with SAS Data Libraries
  • Accessing Other Data Sources
  • Structure of a SAS Program
  • Rules of the SAS Language
  • Table Structures
  • Interpreting the SAS Log
  • Cancelling Submitted Code

FT3 Importing Data into SAS

  • Reading Data
  • Importing Text Files
  • Accessing PC Files and Databases
  • Using the Import/Export Wizards

FT4 Programming with the DATA Step

  • Creating SAS Variables
  • Reading SAS Data Sets
  • Conditional Processing
  • Creating Multiple Subsets
  • Missing Values
  • Common DATA Step Statements

FT5 Manipulating Data

  • WHERE, KEEP, DROP & RENAME Options and Statements
  • Functions
  • Accumulators

FT6 Formats and Labels

  • Formats and Informats
  • Proc FORMAT
  • Labels

FT7 Combining SAS Tables

  • Sorting
  • Appending
  • Merging

FT8 Dates and Times

  • How Dates and Times are Stored in SAS
  • Date and Time Informats / Formats
  • Date and Time Functions

FT9 Data Analysis

  • Proc FREQ
  • Proc MEANS

FT10 Summarising and Transposing Data

  • Data Summarisation
  • Data Transposition

FT11 Reporting

  • Controlling SAS
  • Titles and Footnotes
  • Proc PRINT

FT12 Enhancing Output Using ODS

  • Introduction to ODS
  • Capturing SAS Output
  • Styles in ODS
  • DATA Step Processing Logic
  • Compilation & Execution

FT13 Data Handling

  • Functions and Call Routines
  • Formatting Techniques

FT14 DATA Step Processing

  • > DATA Step Options
  • > Select Statements
  • > Loops
  • > Arrays

FT15 Reading Data From SAS Files

  • SET Applications

FT16 Combining SAS Files

  • MERGE Applications
  • UPDATE Application
  • Table Lookups

FT17 Reading From/Writing to External Files

  • Review of Simple Methods
  • Format Modifiers
  • Files with Delimiters
  • Importing Data from Microsoft Excel