Skip to main Content

SAS Programming CPD

Select a delivery option

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 with the added support of our Continuous Professional Development Program.

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. The SAS Programming CPD course is part of our Continuous Professional Development Program (CPD) detailed below.

The Continuous Professional Development program has 5 elements:

1. ASSESS knowledge in preparation for the SAS Programming course.

  • Optional pre course tests and questionnaires are available to access your level of expertise prior to the training
  • Optional discussion with one of our trainers to make sure your course selection is appropriate for your needs

2. LEARN SAS Programming from our highly qualified SAS certified instructors who bring real world experience to the classroom.

  • Amadeus instructors use proven effective learning methods with a practical approach during the training sessions
  • Bring along your questions and code problems to the course instructors

3. REINFORCE knowledge through hands on workshops during the SAS Programming training session and receive course material that is packed full of examples and SAS techniques

  • The training course is interactive and we encourage delegate participation. The days are split into live SAS demonstration sessions, lectures and workshops
  • You will receive your own set of Amadeus colour course material at the beginning of the course which is written from many years experience and is recognised as valuable reference material to use back in the workplace

4. SUPPORT is provided by our instructors during the SAS Programming course and through live revision sessions following the training. Free resources are also available to download.

  • You can register for the SAS Programming CPD two hour live revision webinar session up to four months following your course attendance to help reinforce your new SAS knowledge
  • Free resources are available to you following the course including: Tips and Techniques, Podcasts and Technical Papers

5. VALIDATE and measure the effectiveness after the SAS Programming course back in the work place

  • Optional post course tests are available to access your level of expertise after the training
  • Optional consultancy service to validate your code back in the workplace

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

Select a delivery option