Viewing Stored Process Reports :: SAS(R) Web Report Studio 4.2: User's Guide

About Stored Process Reports

A stored process is a SAS program that is stored on a server and that can be executed as requested by client applications such as SAS Web Report Studio. The embedded SAS code can contain instructions for rendering report elements as part of a larger report or for rendering a complete report that includes queries, prompted filters, titles, images, and statistical analyses. When a stored process is viewed directly in SAS Web Report Studio, it is a stored process report. Stored process reports contain only one section and are automatically refreshed. All users can run a shared stored process.

Note: Stored processes can also be included as part of a larger saved report. For more information, see Including Stored Process Output.

A stored process might be prompted, which means that users must answer prompts before the report is rendered. Authorized users can schedule a stored process report.

View a Stored Process Report

To run a stored process, you can select one of the last four viewed stored processes from the File menu, use the Open dialog box, or use the File Management window.

Note: Your data source administrator determines what data you are authorized to view.

To use the Open dialog box or the File Management window, complete these steps:

Perform one of these tasks:
- Select FileOpen to display the Open dialog box.
- Click File Manage Files on the Welcome window or in either Edit or View mode.
  The Open dialog box and the File Management window contain a Search for files section and a list of reports, stored processes, and folders.
  
  The File Management Window with Stored Processes Listed
Double-click a stored process to view it. To search for a stored process, complete these steps. For searching tips, see Searching for Reports and Stored Processes.
1. If the Search for files section is not visible, click .
2. In the Search for field, type the text for which you want to search.
3. In the Search what drop-down list, choose whether you want to search for the text in the Name, Description, or Keywords field.
  
  Note: You cannot search the content of a stored process.
4. In the Search where drop-down list, select a folder name.
5. (Optional) To also search for stored processes in folders that are contained in the folder you are searching, select Search subfolders.
6. (Optional) To limit your search by time, select Search for Files Modified in the Date/time limits drop-down list. Then specify the time frame by using the fields that are below the drop-down list.
7. Click Search.
  
  If there are any stored processes that match your criteria, they are shown.
  
  Note: After a search, the list also includes Path information for each located stored process. To clear the search results, select an option in the Location drop-down list.
If necessary, respond to prompts and then click View Report.
(Optional) To view a log for the stored process, select HelpView Log.

Example Report: Sales Forecast for Orion USA

The following example of a stored process report uses the predictive capabilities of SAS to give executives a glimpse into the company's financial future. After the user enters preferences for the country, forecast variable (cost, profit, or sales), and the number of months to forecast, SAS Web Report Studio displays a line plot by month, including confidence intervals, and a supporting list table with values for the year, month, actual sales, forecast, lower 95%, and upper 95%. The prompt window for this stored process is shown in Prompt Window for the Stored Process Report Shown in Display 5.6.

Prompt Window for the Stored Process Report Shown in Display 5.6

Example of Stored Process Report

Tip

Some stored process reports might support chart tips, tooltips, and drilling. Chart tips contain data details and appear when you move the mouse over particular areas on a graph. For example, moving the mouse over the bars in a bar chart displays the data values associated with the bars. A tooltip is a small pop-up informational element displayed when the user positions the mouse over a chart element. Stored process output can include hyperlinks.

Other than changing prompt values, you cannot modify the output of a stored process from within SAS Web Report Studio. For information about how to insert a stored process into a report, see Insert a Stored Process. If you insert a stored process into a report, you can perform some layout design tasks that are independent of the stored process report. For example, you can add images, headers, and footers.