SAS Programming

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

SAS Programming Course Dates

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