Creating, Distributing, and Using SAS Stored Processes

Duration: 2.0 days Course fee: $1,150 EPTO units: 2.2 CEUs: 1.2

This course teaches you how to create SAS programs that can be distributed to many users and run within many applications. This course requires the SAS Intelligence Platform.

Learn how to

use the SAS Management Console or SAS Enterprise Guide to create and register stored processes
design stored processes to use input parameters and set parameter constraints
execute stored processes within the SAS Add-In for Microsoft Office, SAS Enterprise Guide, and SAS Web Report Studio
create transient and permanent result packages.

Who should attend

Business analysts, report designers, and programmers

Expand/Collapse All Expand All Collapse All Print version

Prerequisites

Familiarity with SAS programming is required. You can gain the necessary SAS knowledge by completing the SAS Programming 1: 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 1: Essentials and Querying and Reporting Using SAS Enterprise Guide, respectively.

Course Contents

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

Appendix: SAS Business Intelligence Training

Software

This course addresses SAS Add-In for Microsoft Office, SAS Enterprise Guide, SAS Information Delivery Portal, SAS Intelligence Platform, SAS Management Console.

Course Materials

Students receive a hardcopy of the course notes.

Share Your Thoughts

Are there additional topics you'd like for this course to address? Would you like for this course to be offered at another training facility? Let us know by adding to our Interest List.

This page was created using SAS software.

Learning Center

Stay in Touch

Not sure what course to take?

Submit Your Course Requests

On-site Pricing