SAS Programming
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.
Prerequisites
This course is a significant step up from the SAS Fundamentals training course; we would recommend at least 6 months experience of using the SAS System on a regular basis.
Objectives
After the course, attendees will have a thorough knowledge of the internals of the SAS System, be able to write advanced data steps, combine and transpose SAS files and deal with many kinds of data manipulation problems, as well as being able to write more efficient programs.
Topics
P1 Refresher
- Course Objectives
- Refresh on SAS and the SAS Environment
- Writing SAS Programs
- The Data Step and Data Manipulation
- Analysis and Reporting
- Workshop Session
P6 Combining SAS Files
- Overview
- Appending SAS Files
- MERGE Applications
- UPDATE Applications
- Table Lookups
- Workshop Session
P2 Data Step Internals
- Data Step Processing Logic
- Compilation & Execution
- Workshop Session
P7 Summarising Data
- Data Summarisation
- Data Transposition
- DATA Step Methods
- Workshop Session
P3 Data Handling
- Functions and Call Routines
- Formatting Techniques
- Workshop Session
P8 Reading External Files
- Review of Simple Methods
- Format Modifiers
- Read, Test and Read in the Rest
- Files with Repeating Groups
- Workshop Session
P4 Data Step Processing
- Dataset Options
- Loops
- Arrays
- Select Statements
- Workshop Session
P9 Managing the SAS Environment
- Data Libraries
- Password Protection
- Audit Trail
- System Options and Utilities
- Batch Processing
- Workshop Session
P5 Reading Data From SAS Files
- Overview
- SET Applications
- Sampling from SAS Data Files
- Workshop Session
P10 Advanced Reading of External Files (Reference)
- Multiple Input Files
- Reading Variable Length Data
- Files with Delimiters
- Reading with Transposition
- Workshop Session
Public Booking
Date
Next Month
| September 2010 | October 2010 | November 2010 |
|---|---|---|
| 22nd - 24th | 18th - 20th | 17th - 19th |
