Using Stored Processes

SAS Stored Processes can be used in many different client applications. The following list gives a brief overview of each so that you can determine which client best suits your needs.

SAS Add-In for Microsoft Office

The SAS Add-In for Microsoft Office is a Component Object Model (COM) add-in that extends Microsoft Office by enabling you to dynamically execute stored processes and embed the results in Microsoft Word documents, Microsoft Excel spreadsheets, and Microsoft PowerPoint presentations. Additionally, within Excel you can use the SAS add-in to access and view SAS data sources or any data source that is available from your SAS server, and analyze SAS or Excel data by using analytic tasks. For more information, refer to the SAS Add-In for Microsoft Office Online Help, which is located within the product.

SAS BI Web Services

SAS BI Web Services provide a Web service interface to SAS Stored Processes. Web services can be hosted on a Java servlet container or Windows IIS. SAS BI Web Services implement the Discover and Execute Web methods specified by the XML for Analysis standard. The Discover method returns the metadata for a stored process, and the Execute method calls the SAS Stored Process Server to invoke a stored process.

SAS Data Integration Studio

SAS Data Integration Studio enables its administrators to publish jobs as stored processes. SAS Data Integration Studio can generate code that converts a job into a stored process, which is saved to a file and can be executed later by the SAS Stored Process Server. Metadata about the stored process is saved in the current metadata repository. Refer to the SAS Data Integration Studio product Help for more information.

SAS Enterprise Guide

SAS Enterprise Guide provides an integrated solution for authoring, editing, and testing stored processes. You can create stored processes from existing or new SAS code and create stored processes automatically from SAS Enterprise Guide tasks. Metadata registration and source code management are handled from one interface. SAS Enterprise Guide also has the capability to execute stored processes, which enables you to modify and test your stored process without leaving the SAS Enterprise Guide environment. Refer to the SAS Enterprise Guide product Help for more information.

SAS Information Delivery Portal

The SAS Information Delivery Portal provides integrated Web access to SAS reports, stored processes, information maps, and channels. If you have installed the SAS Information Delivery Portal, you can make stored processes available to be executed from the portal without the need for additional programming. The SAS Information Delivery Portal includes the SAS Stored Process Web Application.

SAS Information Map Studio

Stored processes can be used to implement information map data sources. Stored processes can use the full power of SAS procedures and the DATA step to generate or update the data in an information map. Refer to the SAS Information Map Studio product Help for more information about stored process information maps.

SAS Stored Process Web Application

The SAS Stored Process Web Application is a Java Web application that can execute stored processes and return results to a Web browser. The SAS Stored Process Web Application is similar to the SAS/IntrNet Application Broker and has the same general syntax and debug options as the Application Broker. See the Building Web Applications section for examples of this component. The SAS Stored Process Web Application is included with the SAS Web Infrastructure Kit, a component of SAS Integration Technologies.

SAS Web Report Studio

You can use SAS Web Report Studio to execute stored processes and to include stored processes or stored process results in a report. Refer to the SAS Web Report Studio product Help for more information.

Stored Process Service

The Stored Process Service is a Java application programming interface (API) that enables you to execute stored processes from a Java program. This API is commonly used in JSP pages, but can also be used from servlets, custom tagsets and other Java applications. The Stored Process Service API is part of SAS Foundation Services; you must deploy SAS Foundation Services in order to use the Stored Process Service API. For more information, see the Stored Process Service package description in the Foundation Services class documentation.