Create a Stored Process to Use for Indicator Data

Use the following general steps to create a SAS stored process that you can use as a source of indicator data in SAS BI Dashboard.
Note: These stored processes do not produce visual output. If you want to use a stored process to produce an image for the custom graph indicator, see Example: Creating a Custom Graph That Uses a Stored Process.
  1. Write the code for the stored process that does the following things:
    1. creates a SAS data set in the SAS Work library
    2. publishes the data to a SAS Package file using the SAS Publishing Framework
    3. sets the macro variable _ARCHIVE_FULLPATH to the path of the archive file that the stored process generates
    Note: The stored process must not:
    • include the %STPBEGIN and %STPEND macros
    • produce HTML output. SAS BI Dashboard does not support the display of HTML content.
  2. In SAS Management Console, register the stored process in the SAS metadata, designate it as creating a package, and then specify the target data.
    For more information about how to specify the target data, see the SAS Management Console online Help.
  3. Save the stored process metadata registration.
The stored process is now ready to use in indicator data.
Tip
It is recommended that these stored processes be stored in a descriptive folder indicating that the stored processes are for use as a data source in SAS BI Dashboard. Doing so eliminates confusion about mixed types of stored processes and makes it easy to find the correct stored process types.
Copyright © SAS Institute Inc. All rights reserved.