Stored Processes

A stored process is a SAS program that is stored centrally on a server. A client application can then execute the program and receive and process the results. Stored processes enable you to centrally maintain and manage code, give you better control over changes, enhance security and application integrity, and ensure that every client executes the latest version of code that is available.

Stored processes are like other SAS programs except that they have an additional feature that enables customization of the program's execution. This feature enables the invoking application to supply parameters at the time that the stored process is invoked. For example, if you have a stored process that analyzes monthly sales data, you could create a MONTH variable in the stored process. At execution time, the user could supply the parameter MONTH=MAY to analyze May sales data.

You can use stored processes for Web reporting, analytics, building Web applications, delivering packages to clients or the middle tier, and publishing results to channels or repositories. Stored processes can access any SAS data source or external file and can create new data sets, files, or other data targets supported by the SAS System.

You can use the following clients to invoke stored processes:

• the Stored Process Service application programming interface (API)
• the Stored Process Web Application
• the Information Delivery Portal

Stored processes can generate output files in a variety of formats. They can also produce streaming output for Web applications, as well as package output for publishing.

Note: With SAS Integration Technologies 9, stored processes can operate either on a SAS Workspace (IOM) Server to produce packages, or on a SAS Stored Process Server to produce streaming results. IOM Direct Interface stored processes, which were introduced with SAS Integration Technologies 8, operate on a Workspace (IOM) Server and produce packages only.

Stored Processes Documentation

For information about how to create a stored process and invoke it in a client application, refer to the Stored Processes section of the SAS Integration Technologies: Developer's Guide.

For information about how to create the metadata to define a stored process, refer to either of the following:

• Administering Stored Processes in the SAS Integration Technologies: Administrator's Guide
• Administering Stored Processes in the SAS Integration Technologies: Administrator's Guide (LDAP Version)