There is a new version of this course. Please see SAS® Stored Processes: Advanced Techniques.

This course provides information about how to create advanced stored processes that prompt the user for input and create different types of output.

The self-study e-learning includes::

• Annotatable course notes in PDF format.
• Virtual Lab time to practice.

Learn how to

• Create and register stored processes from SAS programs.
• Design dynamic stored processes that prompt users to enter parameter values.
• Create different types of stored process output.

Who should attend

Power users who use SAS Enterprise Business Intelligence or SAS Office Analytics

Formats available	Standard Duration
e-Learning:	14 hours/180 day license	System Requirements

This course builds on the knowledge gained by attending the Creating Stored Processes Using SAS® 1: Essentials course. That knowledge is required. To be completely successful in this course, an understanding of SAS programming and the SAS macro language is required. You can gain the necessary SAS programming knowledge by completing the SAS® Programming 1: Essentials course and the SAS® Macro Language 1: Essentials course.

This course addresses SAS Analytics Platform, SAS Stored Process Server software.

Investigating SAS Stored Process Programming Concepts

• Exploring SAS Stored Processes and the Platform for SAS Business Analytics.
• Discussing the course environment and scenario.
• Recognizing the stored process metadata and program elements.
• Constructing a stored process using a SAS program.

Prompting the User for Information

• Investigating the SAS prompting framework.
• Working with prompt macro variables.
• Using multi-value prompts.
• Working with shared prompts.
• Controlling user selections.

Working with Stored Process Output

• Investigating programming techniques.
• Enhancing stored process output.
• Chaining stored processes.
• Creating different output formats.
• Emailing stored process output.

Extending Stored Process Functionality

• Using SAS tables as input data.
• Running a stored process from SAS program code.
• Using a Microsoft Excel worksheet as input data.

Learning More

• SAS resources.
• Beyond this course.