Amadeus cookies policy - you'll see this message only once.

Amadeus use cookies on this website. They help us to know a little bit about you and how you use our website, which improves the browsing experience and marketing - both for you and for others. They are stored locally on your computer or mobile device. To accept cookies, continue browsing as normal. Or, go to the privacy policy for more information.

Accept and close

SAS Programming

Course Length - 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.

 

Public Course price:
£1,050.00 plus VAT per delegate
View On-Site course prices »

Course outline Public course dates Organise On-Site Training

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

Ideally the delegate will have attended the SAS Fundamentals course or have an equivalent level of competence. This course is a significant step up from the SAS Fundamentals training course; we recommend that attendees have three to six months of regular SAS programming experience to gain the most benefit from this course.

IMPORTANT: 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.

Topics

P1 DATA Step Internals

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

P2 Data Handling

  • Functions and Call Routines
  • Formatting Techniques
  • Workshop Session

P3 DATA Step Processing

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

P4 Reading Data from SAS Files

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

P5 Combining SAS Files

  • MERGE Applications
  • UPDATE Applications
  • Table Lookups
  • Workshop Session

P6 Summarising and Transposing Data

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

P7 Reading From/Writing to External Files

  • Review of Simple Methods
  • Format Modifiers
  • Files with Delimiters
  • Importing Data from Microsoft Excel
  • Read, Test and Read in the Rest (Optional)
  • Reading Files with a Constant Number of Repeating Groups (Optional)
  • Creating Reports using DATA_NULL_Steps (Optional)
  • Workshop Session

P8 Managing the SAS Environment

  • Data Libraries
  • Password Protection (Optional)
  • System Options and Utilities
  • Autoexec Files
  • Batch Processing
  • Workshop Session

P9 Advanced Reading of External Files (Optional)

  • Reading Variable Length Data
  • Reading with Transposition
  • Reading Files with a Varying Number of Repeating Groups
  • Further Examples of Using the Trailing @ Sign
  • Multiple Input Files
  • Workshop Session