Overview

This sample shows you how to prepare an existing stored process for use with an information map. Preparation requires these three main steps:

1. Register the stored process
2. Create the table that is associated with the stored process
3. Register the structure of the table that is used in the stored process

After you complete these steps, the stored process is ready to be associated with an information map.

Note: This sample was written using SAS Management Console 9.1.3 and SAS Information Map Studio 3.1. For a sample for use with version 4.2, see Sample 39432.

Note: For a sample that explains how to create a stored process by using SAS Enterprise Guide, and then associating that stored process with an information map, see Sample 26175

Note: To perform the steps in this sample, you must have the ability to perform tasks in SAS^® Management Console.

About the Sample Stored Process

As the input table for the stored process, this sample uses the SASHELP.CLASS table. If you want to follow along with the sample, copy and save the code shown below. For this example, the stored process is named stpclass.sas. Make note of the physical location. You will need it later when you register the stored process in metadata.

Note: As part of preparing the stored process, you will make temporary modifications to the code.

*ProcessBody;
%stpbegin;

%let workpath=%sysfunc(pathname(work));
libname biout "&workpath";

data biout.class;
  set sashelp.class;
run;

%stpend;

Note: The *PROCESSBODY, %STPBEGIN, and %STPEND statements are required in order to create a stored process that can be used in SAS^® Web Report Studio.

Register the Stored Process

1. In SAS Management Console, under the BI Manager plug-in, navigate to the location where you want to register the stored process. A typical location is BIP Tree ► ReportStudio ► Shared ► Reports ► StoredProcesses.
2. Right-click on the folder and select New Stored Process to launch the New Stored Process wizard. The second wizard page is the most important. On this page, you provide the following information:
   1. For the SAS Server, select the SAS Workspace Server on which to run the stored process (typically, this value is SASMain - Logical Workspace Server).

      Note: If you do not specify a workspace server, then the stored process will not be available to select in SAS Information Map Studio.

   2. For the Source code repository, select from the existing list, or click Manage to select the physical location where you stored the sample stored process (e.g., c:/storedprocesses).
   3. For the Source file, enter the full name of the stored process. In this sample, the stored process is named stpclass.sas.
   4. For the Output, select None.

Create the Table Used in the Stored Process

In order to associate a stored process with an information map, the stored process must have an associated table. That table must exist so that you can register its structure in metadata (discussed later). There are several ways to create this table. For this sample, you can submit the following code, which will output a table with one observation. You can submit the code in an interactive Base SAS session or in a SAS Enterprise Guide code node.

libname biout "c:\temp";

data biout.class;
  set sashelp.class (obs=1);
run;

Register the Table Structure in Metadata

The structure of the table that is used in the stored process (in this sample, BIOUT.CLASS) must be registered in metadata. Structural information includes column names, formats, informats, lengths, and data types. At this point, the sample table has one observation.

Tip: In order to register the table, only the table structure is needed, so, technically, the table could be empty.

1. Back in SAS Management Console, right-click on SAS Libraries in the Data Library Manager plug-in and select New Library to launch the New Library wizard.
2. On the first wizard page, select SAS Base Engine Library.
3. On the second wizard page, enter BIOUT as the name of the library. (The table must be called BIOUT because that is the name of the library used in the sample stored process.)
4. On the third wizard page, enter BIOUT as the libref and enter the path where you saved the table. In this sample, the table was saved to c:\temp.
5. On the fourth wizard page, assign the library to a server, typically, SASMain.
6. After you finish registering the new library, right-click on the library name, select Import Tables, and import the CLASS table that contains one observation.

Associate the Stored Process with an Information Map

Now, you are ready to associate the stored process with the information map.

1. Open SAS Information Map Studio.
2. Select Insert ► Table.
3. Navigate to the BIOUT.CLASS table and click OK.
4. Move all of the columns in the CLASS table to the Information Map pane.
5. Select Tools ►Stored Processes.
6. Select the Use the selected stored process option, and then select the stored process. In this sample, the stored process is named stpclass.

   Note: If your stored process is not in the list, then view its Execution properties in SAS Management Console and verify that you selected to run the stored process on a SAS Workspace Server.

7. Select Tools ► Test.
8. Select all of the data items to include in the test query, and click Run Test.

   If the test results include all of the rows in the CLASS table (and not just one observation), then the stored process has executed successfully.

Test the information map

1. Select Tools ► Test.
2. Select all of the data items to include in the test query, and click Run Test.

   If the test results include all of the rows in the CLASS table (and not just one observation), then the stored process has executed successfully.

Additional Documentation

For more information about SAS stored processes, see the SAS 9.1.3 Integration Technologies: Developer's Guide.

For more information about using stored processes with SAS Web Report Studio, see "Making Stored Processes Available to SAS Web Report Studio" on page 124 in the SAS® 9.1.3 Intelligence Platform Web Application Administration Guide.

For more information about SAS Information Map Studio, see the SAS Information Map Studio documentation page.

For more information about SAS Management Console, see the SAS Management Console documentation page.

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

Operating System and Release Information