Creating, Distributing, and Using SAS Stored Processes(SBISP)

Duration

2 days

Description

This course defines SAS Stored Processes and demonstrates how to create and use them. In the course, SAS Enterprise Guide and the SAS windowing environment are used to create stored processes. The course also illustrates how SAS Stored Processes can be executed from the SAS Add-In for Microsoft Office, SAS Web Report Studio, and the SAS Information Delivery Portal.

Prerequisite Skills

Familiarity with SAS programming is required. You can gain the necessary SAS knowledge by completing the SAS Programming I: Essentials course. To fully exploit the capabilities of stored processes, an understanding of the SAS macro language and SAS Enterprise Guide is helpful but not required. This knowledge can be acquired by completing the courses SAS Macro Language and Querying and Reporting Using SAS Enterprise Guide, respectively.

Course Topics

Introduction to the SAS Intelligence Platform

• SAS business intelligence overview
• understanding SAS business intelligence applications and personas

Introduction to the Orion Star Data

• overview
• introduction to stored process data and tasks

Overview of SAS Stored Processes

• what is a stored process?
• stored process uses and clients
• other examples of using a SAS Stored Process

Manually Creating and Registering SAS Stored Processes

• creating and registering a SAS Stored Process
• introducing input parameters
• working with input parameters

Creating and Running Stored Processes with SAS Enterprise Guide

• overview of SAS Enterprise Guide
• creating a stored process with SAS Enterprise Guide
• other features for stored processes in SAS Enterprise Guide

Advanced Stored Process Topics

• creating transient and permanent package results
• viewing result packages with SAS Package Reader
• using ODS options when creating a stored process manually
• understanding streaming results (self-study)

Other Methods of Working with Stored Processes (Self-Study)

• creating a stored process from a SAS Data Integration Studio job
• using stored processes to populate SAS Information Maps

Booking

Please contact the Education Team at SAS for the latest information on all SAS courses or to put your name on our specialised course waiting list.