support & services / Education

SAS Programming Essentials for Experienced SAS Enterprise Guide Users - EGP143

This course is for experienced SAS Enterprise Guide users who want to gain extra value from the product by understanding the code that it generates and methods of enhancing that code. The course will serve as a transition into the programming world of SAS and serves as a prerequisite for the SAS Programming 2: Data Manipulation Techniques course.

  Download course description as PDF     Register now  


2 days - Classroom

Learn how to

  • analyse the way in which SAS Enterprise Guide and SAS programs work together
  • evaluate the structure and syntax of a SAS program
  • manipulate SAS data sets using the DATA step
  • read delimited text files using the DATA step
  • merge tables and isolate matching and non-matching rows using the DATA step
  • customise task output by modifying the code that is generated by SAS Enterprise Guide.

Who should attend:

SAS Enterprise Guide users who are interested in learning about writing SAS programs and modifying the SAS code generated by SAS Enterprise Guide


Before attending this course you should have completed the SAS Enterprise Guide 1: Querying and Reporting course or have equivalent experience.

Course Contents

Why Learn SAS Programming?

  • course logistics
  • reviewing SAS Enterprise Guide basics
  • benefits of understanding SAS programming

SAS Programming Basics

  • introduction to SAS programs
  • SAS programming concepts
  • diagnosing and correcting syntax errors
  • accessing SAS libraries
  • accessing relational databases (self-study)

Reading SAS Data Sets

  • comparing the DATA step with the Filter and Query task
  • DATA step basics
  • DATA step processing
  • conditional processing
  • additional operators and formats (self-study)

Reading Raw Data Files

  • reading delimited data
  • examining data errors
  • retaining values in the PDV (self-study)

Combining SAS Data Sets

  • merging data using the DATA step
  • concatenating data
  • appending data (self-study)

Enhancing Code Generated by Tasks

  • understanding the generated code
  • interacting with the generated code
  • getting help (self-study)

Controlling Output Content

  • enhancing titles and footnotes
  • using run-time prompts with code
  • conditional highlighting

Controlling Output Types

  • the Output Delivery System
  • customising HTML output
  • customising RTF output
  • customising PDF output

Learning More

  • SAS resources
  • beyond this course

Software Addressed

This course addresses the following software product(s): SAS Enterprise Guide.