|
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.
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.
At least 3-6 months experience of using the SAS System.
3 days.
|
The SAS Data Model
The SAS Data Library Model
Managing the Data Library
Autoexec Files, Options and Utlilities
Workshop
|
Data Step Processing Logic
Compilation, Initialisation & Execution
Data Set Options
Workshop
|
|
Review of Simple Methods
Format Modifiers
Read, Test and Read in the Rest
Files with Repeating Groups
Workshop
|
Loops
Arrays
Functions
Workshop
|
|
Multiple input Files
Reading Variable Length Data
Files with Delimiters
Reading with Transposition
Workshop
|
Data Summarisation
Data Transposition
Data Step Mehods
Workshop
|
|
Overview
Set Applications
Merge Applications
Workshop
|
Proc SQL
Data from Other Software (optional)
Efficiencies Techniques
Workshop
|
|
Introduction
Reading VSAM Files
Writing VSAM Files
Error Testing
|
|
|
