SAS Programming

Standard Course
£1,200.00 +VAT
per delegate
Course duration: 3 Days

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

Who is it for?

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

  • The SAS Programming course builds on the fundamental concepts of SAS and assumes the delegate already has a working knowledge of the following:
    • Using either the SAS Display Manager, SAS Enterprise Guide or SAS Studio to:
      • Develop and submit programs
      • Debug messages in the log
      • View output generated
    • Understand the structure of a SAS data set including column attributes such as column type and length
    • Write DATA step code to:
      • Perform conditional processing using the IF statement
      • Create variables using expressions and functions
      • Read data using the SET statement
      • Import data using the INFILE and INPUT statements
      • Merge data using the MERGE statement
    • Familiarity with the following SAS procedures:
      • Proc SORT
      • Proc PRINT
      • Proc FORMAT
    • Use data set options such as KEEP, DROP, RENAME and WHERE
    • Use of BY-group processing (i.e. using a BY statement in DATA and Proc steps)
    • Understand when and how to use Informats and Formats
    • Understand how to work with SAS Dates and Times
  • If you would like further advise on whether this course is suitable for you please call +44 (0) 1993 848010

What you will learn

  • Course Objectives
  • Refresher on SAS and the SAS Environment
  • DATA Step Processing Logic
  • Compilation and Execution
  • Workshop Session

  • Functions and Call Routines
  • Formatting Techniques
  • Workshop Session

  • Data Set Options
  • Select Statements
  • Loops
  • Arrays
  • Workshop Session

  • SET Applications
  • Sampling from SAS Data Files (Optional)
  • Workshop Session

  • MERGE Applications
  • UPDATE Applications
  • Workshop Session

  • Data Summarisation
  • Data Transposition
  • DATA Step Methods (Optional)
  • Workshop Session

  • Introduction
  • Macro Variables
  • Workshop Session

  • Utility Procedures
  • System Options and Utilities
  • Autoexec Files
  • Workshop Session

SAS Programming Course Dates

Our courses are live instructor-led and can be attended virtually or at our office.

  • Wednesday 17 January 2024 - Friday 19 January 2024
    Book now
  • Wednesday 10 April 2024 - Friday 12 April 2024
    Book now
  • Tuesday 9 July 2024 - Thursday 11 July 2024
    Book now
  • Tuesday 8 October 2024 - Thursday 10 October 2024
    Book now
Back to Training

Talk to us about how we can help