Creating, Distributing and using SAS® Stored Processes

Duration

2 days

Description

This course defines SAS Stored Processes and demonstrates how to implement them. A variety of SAS products are used to create SAS Stored Processes. The course also illustrates how SAS Stored Processes can be used with SAS Add-In to Microsoft Office and in SAS Information Delivery Portal.

Prerequisite Skills

You should have attended SAS Essentials: An Introduction to SAS Programming or have an equivalent level of knowledge. In addition, an understanding of SAS Macro Language and SAS Enterprise Guide would be beneficial. You can gain this knowledge by attending the SAS Macro Language course and the Introduction to SAS Enterprise Guide course.

SAS Modules Used

SAS Add-In for Microsoft Office, SAS Enterprise Guide, SAS Information Delivery Portal, SAS Intelligence Platform, SAS Management Console, SAS Data Integration Studio.

Course Topics

Introduction to the SAS Enterprise Intelligence Platform

• SAS Business Intelligence overview
• understanding SAS Business Intelligence applications and personas.

Introduction to the Course Data

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
• introduction to stored process data and tasks.

Other Methods of Working with Stored Processes

• using ODS options when creating a stored process manually
• understanding streaming results
• other output forms for stored processes.

SAS Data Integration Studio and Stored Processes

• understanding how a stored process is created within SAS Data Integration Studio
• executing a stored process created from a SAS Data Integration Studio job.