Summer Fast Track: SAS(R) Advanced Programming

Course code: SFTPRA

This course is for users who want to learn more advanced functionality for writing SAS programs, with a focus on applying efficiency techniques, using SAS macro code, and processing SAS data using Structured Query Language (SQL). The "fast track" format for this offering combines the SAS Programming 3: Advanced Techniques, SAS Macro Language 1: Essentials, and SAS SQL 1: Essentials courses. The course provides an introduction to SQL processing, and access to the e-learning version of the Essentials course is provided so that students can study the subject matter independently.
4 800 EUR

5 808 EUR including VAT

Selection of dates
Do you have a question?
+420 731 175 867

and certified lecturers

recognized certifications

Wide range of technical
and soft skills courses

Great customer

Making courses
exactly to measure your needs

Course dates

Starting date: Upon request

Type: Upon request

Course duration: 52h 30min

Language: en

Price without VAT: 4 800 EUR


Type Course
Language Price without VAT
Upon request Upon request 52h 30min en 4 800 EUR Register
G Guaranteed course

Didn't find a suitable date?

Write to us about listing an alternative tailor-made date.


Target group

Experienced SAS programmers

Course structure

Introduction to SAS Programming 3

  • Overview of SAS Foundation.
  • Course logistics.
  • Creating the course data.

Efficient SAS Programming

  • Identifying computer resources related to efficiency.

Controlling I/O Processing and Memory

  • SAS DATA step processing.
  • Controlling I/O.
  • Reducing the length of numeric variables.
  • Compressing SAS data sets.
  • Using SAS views.

Accessing Observations

  • Access methods.
  • Accessing observations by number.
  • Creating an index.
  • Using an index.

DATA Step Arrays

  • Introduction to lookup techniques.
  • One-dimensional arrays.
  • Multidimensional arrays.
  • Loading a multidimensional array from a SAS data set.

DATA Step Hash and Hiter Objects

  • Introduction.
  • Hash object methods.
  • Loading a hash object from a SAS data set.
  • DATA step hiter object.

Combining Data Horizontally

  • DATA step merges and SQL procedure joins.
  • Using an index to combine data.
  • Combining summary and detail data.
  • Combining data conditionally.

User-Defined Functions and Formats

Combining Raw Data Files Vertically

Introduction to SAS Macro

  • Overview of SAS Foundation.
  • Course logistics.
  • Purpose of the macro facility.
  • Program flow.

Macro Variables

  • Introduction to macro variables.
  • Automatic macro variables.
  • Macro variable references.
  • User-defined macro variables.
  • Delimiting macro variable references.
  • Macro functions.

Macro Definitions

  • Defining and calling a macro.
  • Macro parameters.

DATA Step and SQL Interfaces

  • Creating macro variables in the DATA step.
  • Indirect references to macro variables.
  • Creating macro variables in SQL.

Macro Programs

  • Conditional processing.
  • Parameter validation.
  • Iterative processing.
  • Global and local symbol tables.

Supplemental Materials: Program Flow

Introduction to SAS SQL Procedures


This course is not appropriate for beginning SAS software users. Before attending this course, you should have at least several months of SAS programming experience, or you should have completed the SAS Programmierung 2: Datenmanagement course and master the topics introduced during that course.

Do you need advice or a tailor-made course?


product support

ComGate payment gateway MasterCard Logo Visa logo