SAS Programming for SAS Enterprise Guide Users

Description

This course will serve as a transition in to the programming world of SAS for Experienced Enterprise Guide Users

Learn how to

• Understand and work with the code generated by SAS Enterprise Guide
• Use the DATA step to perform additional data manipulation tasks
• Use Parameters with SAS code
• Include additional information in titles and footnotes
• Gain extra control over output types, including page numbering and page orientation
• Implement data dependent 'conditional' highlighting of data.

Prerequisite Skills

Before attending this course, you should have taken the Querying and Reporting Using SAS Enterprise Guide course or completed the Getting Started Tutorial within SAS Enterprise Guide.

SAS Modules Used

SAS Enterprise Guide

Who should attend

Experienced SAS Enterprise Guide users

Course Topics

Why Learn SAS Programming?

• Understand how SAS Enterprise Guide works
• Understand the benefits of learning SAS Programming

SAS Programming Basics

• SAS Programming Concepts
• Diagnosing and Correcting Syntax Problems
• Accessing Data via SAS Libraries

Reading SAS Data Sets

• Comparing DATA step with Filter and Query
• DATA Step Basics
• DATA Step Processing
• Conditional Processing

Reading Raw Data Files

• Reading Delimited Data
• Examining Data Errors
• Retaining Values in the PDV

Combining SAS Data Sets

• Merging data using the DATA step
• Concatenating Data
• Appending Data

Enhancing Code Generated by Tasks

• Understanding the Generated Code
• Interacting with the Generated Code
• Getting Help

Controlling Output Types

• The Output Delivery System
• Customising HTML Output
• Customising RTF Output
• Customising PDF Output

Controlling Output Content

• Enhancing Titles and Footnotes
• Using Run-time Parameters with Code
• Conditional Highlighting