Services

SAS Training Courses

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