Fast Track Fundamentals and Programming

This course serves as a, 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.

-------------------------------------------------------------
Target Audience

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

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

-------------------------------------------------------------

Fast Track Fundamentals and Programming

Fast Track Fundamentals and Programming

Uplatz

IT Training

IT Training

General