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.
• Use an input data source for the stored process.

Who should attend

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

Formats available	Standard Duration (duration can vary, see event schedule for details)
Classroom:	2 days
Live Web Classroom:	4 half-day session(s)	System Requirements
e-Learning:	14 hours/180 day license

This course builds on the knowledge gained by completing the SAS Office Analytics: Getting Started course or the SAS Office Analytics: Fast Track course. That knowledge is required. To be completely successful in this course, an understanding of SAS programming and the SAS macro language is also 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 Office Analytics software.

Investigating SAS Stored Process Programming Concepts

• Exploring SAS Stored Process fundamentals.
• Constructing a stored process using a SAS program.
• Working with dependent prompts.

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.

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.

Appendix A

• Emailing stored process output.