About this course

Course code TPEGP171
Duration 2 Days

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.

Prerequisites

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

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

Delegates will 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.

Outline


Why Learn SAS Programming?

  • course logistics
  • reviewing SAS Enterprise Guide basics
  • benefits of understanding 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)
  • 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

2 Days

Duration

This is a QA approved partner course

Delivery Method

Delivery method

Classroom

Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.