SAS Training

Getting Started with the SAS® System Course

Audience

New Users who require an Introduction to the SAS System and have not had taken any Computer Programming courses.

Objectives

This course is for beginners in the SAS System. The course is designed to be an easy introduction to the SAS System and covers some programming. It is intended as a forerunner to the Fundamentals course for those who have little experience of the SAS System, computers or programming.

Prerequisites

There are no pre-requisites for this course; however, it is not a course that is suited to Programmers or those already with SAS System Knowledge.

Duration

2 days.

The SAS Data Analysis Environment

Introduction
A Walk through the SAS System
Using some sample programs
Making changes to the samples
Printing programs and results
Finding your way around the SAS
System
Workshop Session

Getting Data with the Data Step

Writing your own programs
Importing Data with the Data Step
Accessing SAS Data files
Using SAS Procedures
Workshop Session

Working with your Data

Sorting Observations and Arranging
Variables
Creating New SAS Data Files
Subsetting Existing SAS Data Files
Defining New Variables
Workshop Session

Gaining Information from your Data

Introduction
The REPORT Window
Saving Report Programs
Other Methods of Analysing your Data
Tabulation Interface System
Workshop Session

SAS® Fundamentals Course

Audience

This course is designed for computer users as an introduction to the SAS System.

Objectives

This course is our Essential Introduction to the SAS System. The course covers all you need to know to get started with SAS quickly and easily. After the course, attendees will be able to use SAS software to read their data, access, manage and manipulate their data, solve problems, save programs and datasets, use conditional logic, combine files, produce tables and listings of data, and use data analysis techniques.

Prerequisites

Attendees will need some knowledge of their own computer systems and be able to use a keyboard and a mouse.

Duration

3 days.

Introduction to SAS

What is SAS?
SAS System Walkthrough
The SAS Environment
Workshop

SAS Libnames

What is Libname?
How to Assign Libnames
Accessing Other Data
Workshop

Writing SAS Programs

Background to Steps
Statements
Naming Conventions
SAS Programs
Table Structures
Saving Work
Workshop

Importing Data Into SAS

Program Method
Different Text File Structures
Viewing Data Using Explorer
Accessing Other Data
Workshop

Manipulating Data

Overview of Data Step Statements
How the Data Step Works
Programming with the Data Step
Where, Keep, Drop and Rename
Functions
Accumulators
Macro Variables
Workshop

Formats and Labels

Formats
Informats
Labels
Workshop

Combining SAS Tables

Sorting
Concatenating
Merging
Workshop

Dates and Times

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

Reporting (optional)

Controlling SAS
Proc Print
Proc Format
Proc Tabulate
Proc Report
Workshop

Enhancing Output Using ODS

Introduction to ODS
Capturing SAS Output
Workshop

Data Analysis (optional)

Proc Freq
Proc Means
Proc Univariate
Workshop

SAS® Programming Course

Audience

SAS users who wish to extend their knowledge of SAS software. The course builds on the tools and techniques taught in the SAS Fundamentals course.

Objectives

After the course, attendees will have a thorough knowledge of the internals of the SAS System, be able to write advanced data steps and deal with many kinds of data manipulation problems, combine and transpose SAS datasets, and apply efficiency techniques to their programs.

Prerequisites

At least 3-6 months experience of using the SAS System.

Duration

3 days.

The SAS Data Model

The SAS Data Model
The SAS Data Library Model
Managing the Data Library
Autoexec Files, Options and Utlilities
Workshop

Data Step Internals

Data Step Processing Logic
Compilation, Initialisation & Execution
Data Set Options
Workshop

Reading External Files 1 (optional)

Review of Simple Methods
Format Modifiers
Read, Test and Read in the Rest
Files with Repeating Groups
Workshop

Data Step Processing

Loops
Arrays
Functions
Workshop

Reading External Files 2 (optional)

Multiple input Files
Reading Variable Length Data
Files with Delimiters
Reading with Transposition
Workshop

Summarising Data

Data Summarisation
Data Transposition
Data Step Mehods
Workshop

Reading SAS Data Sets

Overview
Set Applications
Merge Applications
Workshop

Further Techniques

Proc SQL
Data from Other Software (optional)
Efficiencies Techniques
Workshop

Accessing VSAM Files (optional)

Introduction
Reading VSAM Files
Writing VSAM Files
Error Testing

SAS® Report Writing Course

Audience

SAS Users who wish to create tables and reports of their data, both with standardised procedures and bespoke Programs.

Objectives

This course covers the use of Proc Print, Proc Report, Proc Tabulate and the Data Step to produce text reports. Other procedures such as Proc SQL and Proc Forms are also discussed. The course teaches all manner of textual report writing techniques, including data manipulation methods that are essential for complex reports.

Prerequisites

To take this course, you should have taken the Fundamentals of the SAS System Course.

Duration

3 days.

Introduction

Report Writing Tools
Tools of the Trade (Optional)
SAS System Options
Workshop Session

Data Listing and Summaries

Using Proc Print
Creating the Data Set
Other Procedures
Summarising Data (Optional)
Transposing Data (Optional)
Workshop Session

Creating Tables

Proc Tabulate
Types of Variables
Types of Tables
Workshop Session

Enhancing Tables

Statistics in the Table
Percentages
Enhancing the Table
Workshop Session

Data Step Reports

Structure
Enhancing the Report
Data Manipulation (Optional)
Workshop Session

Proc Report

Basics
Computed Variables
Grouping Data
Breaks in the Report
Workshop Session

Complex Tables

Tabulate Options
Summaries and Percentages
Tables from Multiple Choice Data
Workshop Session

Data Step Control

File and Put Options
Whole Page Reports
Templates
Workshop Session

SAS® Advanced Techniques and Efficiencies Course

Audience

SAS Programmers who wish to write efficient SAS Programs and fine-tune their existing Programs.

Objectives

This course is designed to enhance existing SAS programming skills and improve the efficiency of your programs. Many different efficiency techniques are studied in depth through practical examples.

Prerequisites

To take this course, you should have taken the Fundamentals of the SAS System course and have at least 6 months SAS programming experience.

Duration

1 day.

Efficiency Techniques

Benchmarking
CPU, I/O and Memory
Reducing Disk Space

Data Storage Methods and Compression

SAS Engines
Space Reduction
Data Set Compression
Workshop Session

Indexing Techniques

When to use indexes
Creating and Deleting Indexes
Index Advantages and Disadvantages
Workshop Session

SAS Data Set Modification

Data Library Structure
Multi-Engine Architecture
Proc Access
Stored Program Facility
Data Step Views

Table Lookup Techniques

Lookups using Formats
Lookups using Indexes
Lookups using Merges
Lookups using Arrays
Lookups using SQL Joins
Lookups using Macros
Workshop Session

SAS Data Set Modification

The Where Clause
Keep and Drop
Other Data Set Options
Workshop Session

Sorting Techniques and Efficiencies

Working with Duplicate
Controlling Secondary Sort Orders
Using the Sort Flag
SAS Sort Vs the Hot Sort
Workshop Session

SAS® Macro Course

Audience

SAS Programmers seeking to extend their Programming Skills.

Objectives

This course covers the SAS Macro Language in depth. The theory and methods of the Macro facility are discussed through examples and applications. You will be able to write your own Macros, understand the structure of the SAS Macro Language and deal with the various functions available in the Macro Language.

Prerequisites

To take this course, you should have taken the SAS Fundamentals course and have at least 6 months SAS programming experience.

Duration

2 days.

Introduction

Common Coding Tasks
General Strategy
Workshop

Variable Code

Macro Variables
Resolution Considerations
Macro Variables vs Data Step Variables
Workshop

Code Bundles

Definition of a Macro
Passing Parameters
Compilation and Execution Phases
Workshop

Behind the Scenes

Symbol Tables
Rules
Nested Macros
Global and Local Variables
Workshop

Code Generation

Directing Macro Execution
String Manipulation
Debugging
Workshop

The Data Step Interface

Functions and Call Routines
SYMGET
Call SYMPUT
Workshop

Special Characters

Evaluations
The Quoting Functions
Workshop

Working With Macros

The Autocall Library and System Options
Writing Successful Macros
Examples and Utilities
Workshop

Windows and Menus (optional)

INPUT
MVS Windows Definition %window
MVS %DISPLAY
Examples
Workshop

SAS® SQL Course

Audience

SAS Programmers who wish to know the benefits and role of SQL Programming within the SAS System.

Objectives

This course covers Proc SQL in detail , concentrating on the use of SQL for existing SAS Programmers. Traditional SAS Data steps and Proc steps are compared with using Proc SQL and efficiency issues are discussed.

Prerequisites

To take this course, you should have taken the SAS Fundamentals course and have some experience of SAS programming.

Duration

1 day

Introduction

Concepts
The SAS Data Model

Selecting Data

The Select Statement
Controls and Enhancements
Analysis on Groups
Nested Subqueries
Syntax Summary
Workshop

Combining Data

Inner Joins
Outer Joins
Complex Queries
Set Operations
Workshop

Creating Data

Creating Tables, Views and Indexes
Changing Data in Tables
Changing the Structires of Tables
Further Topics
Workshop

Using SAS/STAT® Software for Applied Statistics Course

Audience

For Statisticians who would like to learn how to run statistical procedures in the SAS System.

Objectives

This course is designed to teach users how to perform analyses using base SAS software and SAS/STAT software. Several statistical topics are covered as they apply to SAS software. Topics include statistical interference, analysis of variance, linear regression, and analysis of frequency data. The following procedures are covered: FREQ, CORR, REG, NPAR1WAY, GLM, TTEST, SUMMARY, UNIVARIATE, MEANS, ANOVA, FACTOR, PRINCOMP and CLUSTER.

Prerequisites

To take this course, you should have taken the Fundamentals of the SAS System course or have equivalent experience.

Duration

3 days.

Introduction to Statistics

Statistical Techniques Covered
Distributions
Sampling
Descriptive Statistics
Proc Summary
Data from Other Packages
Using SAS/INSIGHT
Working with Existing Data Sets
Workshop Session

Hypothesis Testing

Tests Concerning Means
Tests for Paired Observations
Workshop Session

Correlation and Regression

Introduction
Correlation
Linear Regression
Multiple Regression
Multivariate Regression
Workshop Session

Analysis of Variance

Introduction
Proc Univariate
Proc Anova
Proc Ttest
Proc Glm
Randomised Block Designs
Proc Npar1way
Workshop Session

Frequency Analysis

Chi Square Distribution
Frequency Analysis
Chi Square Distributions
Questionnaire Analysis
Analysis of Stratification
Workshop Session

Multivariate Analysis

Factor Analysis
Principal Components Analysis
Discriminant Analysis
Cluster Analysis
Workshop Session

Using SAS/GRAPH® Software Course

Audience

SAS System users.

Objectives

This course covers SAS/GRAPH software procedures and other graphic aspects of the SAS System. The course covers all the areas in SAS/GRAPH software that you need to produce high quality presentation graphics. The course can be tailored at no extra charge to reflect the way that you use SAS/GRAPH software. Emphasis can be placed on the procedures you use and the techniques that your company encourages. Please call to discuss this with one of our trainers.

Prerequisites

To take this course, you should have taken the Fundamentals of the SAS System course or have equivalent experience.

Duration

2 days.

Introduction

Procs and Catalogs
Which Device ?
Softcopy and Hardcopy
Options

Text Graphics

Slide Protection
Incorporating Procedure Output
Data Step Graphics
Workshop Session

Plots

Proc Gplot
Line Control
X*Y=Z and Axis Control
Legends and Enhancements
Workshop Session

Charts

Introduction to Charts
Bar Charts
Pie Charts
Workshop Session

Maps

Mapping
Customised Maps
Enhancing the Maps
Other forms of Maps
Workshop Session

3-D Graphics

Contour Plots
3-D Plots
Workshop Session

Storing and Templating

Graphics Replay
Graphics Catalog Management
Templating
Line Mode
Workshop Session

Annotation

Introduction
Using Annotate Data Sets
Annotate Macros
Tips and Techniques
Workshop Session

Utilities

Proc Gtestit
Proc Gdevice
Proc Goptions

SAS Training

Intro to SAS® System Course
SAS® Fundamentals Course
SAS® Programming Course
SAS® Report Writing Course
SAS® Advanced Techniques and Efficiencies Course
SAS® Macro Course
SAS® SQL Course
Using SAS/STAT® for Applied Statistics Course
Using SAS/GRAPH® Course