Overview

This sample demonstrates how to display a SAS Stored Process in a SAS^® Information Delivery Portal page by using a URL display portlet. The sample uses the application feature of the portal in order to enable the stored process to execute without additional authentication. The steps vary slightly between SAS 9.1.3 and SAS 9.2, so choose the appropriates set of steps below.

• SAS 9.2 - Using the STPRun directive
• SAS 9.1.3 - Using the Portal application method

CAUTION: This example will allow a stored process to be executed when the Portal page is displayed. The results are not cached, and the stored process will be executed each time the Portal page is displayed or refreshed. If the stored process takes long to display, this could result in poor performance of the Portal page. Any stored process that you want to use in a Portal page should be designed so that it will execute quickly. Additionally, adding multiple URL display portlets to the same page will result in slower performance, as each stored process must be executed and returned to the Portal page.

In addition, the SAS BI Portlets release now provides a SAS Stored Process portlet that can be used to display stored process output in SAS 9.2.

SAS 9.2 - Using the STPRun directive

Copy the URL to Launch the Stored Process

1. Open the SAS Stored Process Web Application directly. To do this, enter the following URL, and replace the server and port with the values for your server.

http://server:port/SASStoredProcess



2. Click the List Available Stored Processes link.

3. Navigate the treeview to the stored process that you want display in the portal. Right-click on the link in order to open the stored process, and then select Copy Shortcut.



4. Paste the URL into a text editor. The URL should look similar to this:

http://server:port/SASStoredProcess/do?_action=form,properties,execute,nobanner,newwindow&_program=%2FProducts%2FSAS+Intelligence+Platform%2FSamples%2FSample%3A+Shoe+Sales+by+Region

5. In the URL from the previous step, locate the _program parameter and its value. In the previous example, that value is:

_program=%2FProducts%2FSAS+Intelligence+Platform%2FSamples%2FSample%3A+Shoe+Sales+by+Region

Copy this value to use in the URL that you will create. To create the URL, you will use either the STPRun or the STPRunParameters directive, depending on whether the stored process requires input parameters. For more information on the new directives, see SAS Note 37516

• If the stored process does not require input parameters, then use the STPRun directive. The URL will look like the following, just replace the _program value with the one for your stored process:

  http://server:port/SASPortal/Director?_directive=STPRun&_program=%2FProducts%2FSAS+Intelligence+Platform%2FSamples%2FSample%3A+Shoe+Sales+by+Region

  Note: The directive is case sensitive, so type it exactly as shown here.

• If the stored process does require input parameters, then use STPRunParameters directive. This value will either display a custom input form, if a custom form exists, or it will display the default properties page. For the best display in a portlet, a custom input form should be used. The URL would look similar to this:

http://server:port/SASPortal/Director?_directive=STPRunParameters&_program=%2FProducts%2FSAS+Intelligence+Platform%2FSamples%2FSample%3A+Shoe+Sales+by+Region

Note: The directive is case sensitive, so type it exactly as shown here.

Create a New URL Display Portlet

1. While logged into the portal, open the page that you want to add the portlet.
2. Select Options ► Edit Content.



3. Click the Add Portlets button.
4. In the drop-down list for Portlet type, select URL Display Portlet.
5. Enter a name for the portlet, and then click the Add button to create it.
6. Click the Done button, then the OK button in order to return to the portal page.
7. Click the Edit Content icon on the new URL display portlet.
8. For the URL, enter the URL that you created previously.
9. Make sure to select the Show URL content inside an I-Frame option. (This feature will not work without an I-Frame).
10. Change the I-Frame height so that the I-Frame is the size that you want. If the I-Frame is not large enough, scroll bars will appear in the portlet.



11. Click Save to return to the portal page and display the portlet.

SAS 9.1.3 - Using the Portal application method

Copy the URL to Launch the Stored Process

1. Open the SAS Stored Process Web Application directly. To do this, enter the following URL, and replace the server and port with the values for your server.

http://server:port/SASStoredProcess/Welcome.htm



2. Click the List Available Stored Processes link. If prompted, enter the authentication information.

3. Navigate the treeview to the stored process that you want display in the portal. Right-click on the link in order to open the stored process, and then select Copy Shortcut.



4. Paste the URL into a text editor. The URL should look similar to this:

http://server:port/SASStoredProcess/do?_action=data&_program=SBIP%3A%2F%2FFoundation%2FSamples%2FStored+Processes%2FSample%3A+Shoe+Sales+by+Region%28StoredProcess%29

5. Modify the action parameter in the URL, depending on whether the stored process requires input parameters.
• If the stored process does not require input parameters, then change the value for _action to execute. For example:

http://server:port/SASStoredProcess/do?_action=execute&_program=SBIP%3A%2F%2FFoundation%2FSamples%2FStored+Processes%2FSample%3A+Shoe+Sales+by+Region%28StoredProcess%29

• If the stored process does require input parameters, then change the value for _action to form,properties. This value will either display a custom input form, if it exists, or it will display the default properties page. For the best display in a portlet, a custom input form should be used. The URL would look similar to this:

http://server:port/SASStoredProcess/do?_action=form,properties&_program=SBIP%3A%2F%2FFoundation%2FSamples%2FStored+Processes%2FSample%3A+Shoe+Sales+by+Region%28StoredProcess%29

Create a New Application in the SAS Information Delivery Portal

1. Log in to the SAS Information Delivery Portal.
2. Create a new application by selecting Options ► Create New Content.
3. Select Application, and then click the Create button.
4. For the name, enter [Your stored process name] application link.
5. For the URL, paste in the URL for your stored process (which you copied previously).



6. Click Create, and then Done twice in order to return to the portal page.

Copy the URL Link to Your New Portal Application

1. In the portal window, click Search.
2. Select Application as the content type, and enter * as the keyword.
3. In the search results, right-click on the application that you created earlier, and select Copy Shortcut.



4. After copying the shortcut, click the application to verify that it works. The stored process should open in a new window.
5. Click the ◄ Portal Page link to return to the portal page.

Create a New URL Display Portlet by Using the URL to the Application Link

1. While logged into the portal, open the page that you want to add the portlet.
2. Select Options ► Edit Content.



3. Click the Add Portlets button.
4. In the drop-down list for Portlet type, select URL Display Portlet.
5. Enter a name for the portlet, and then click the Add button to create it.
6. Click the Done button, then the OK button in order to return to the portal page.
7. Click the Edit Content icon on the new URL display portlet.



8. For the URL, enter the URL that you copied for the new portal application.
9. Make sure to select the Show URL content inside an I-Frame option. (This will not work without an I-Frame).
10. Change the I-Frame height so that the I-Frame is the size that you want. If the I-Frame is not large enough, scroll bars will appear in the portlet.



11. Click Save to return to the portal page and display the portlet.

Additional Documentation

For a list of available documentation for SAS Information Delivery Portal, see http://support.sas.com/documentation/onlinedoc/portal/index.html.

For documentation for the SAS Stored Process Web Application, see

• SAS 9.2 Stored Processes: Developer's Guide
• SAS 9.1.3 Stored Processes: Developer's Guide

---

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.

This sample demonstrates how you can use the URL display portlet in order to display the output of a SAS Stored Process in a SAS Information Delivery Portal page.

Type:

Sample

Date Modified:	2010-02-17 14:23:06
Date Created:	2008-05-19 14:52:23

Operating System and Release Information

Product Family	Product	Host	Product Release		SAS Release
			Starting	Ending	Starting	Ending
SAS System	SAS Information Delivery Portal	Microsoft® Windows® for x64	2.0		9.1 TS1M3 SP4
		Microsoft Windows 2000 Advanced Server	2.0		9.1 TS1M3 SP4
		Microsoft Windows 2000 Datacenter Server	2.0		9.1 TS1M3 SP4
		Microsoft Windows 2000 Server	2.0		9.1 TS1M3 SP4
		Microsoft Windows 2000 Professional	2.0		9.1 TS1M3 SP4
		Microsoft Windows NT Workstation	2.0		9.1 TS1M3 SP4
		Microsoft Windows Server 2003 Datacenter Edition	2.0		9.1 TS1M3 SP4
		Microsoft Windows Server 2003 Enterprise Edition	2.0		9.1 TS1M3 SP4
		Microsoft Windows Server 2003 Standard Edition	2.0		9.1 TS1M3 SP4
		Microsoft Windows XP Professional	2.0		9.1 TS1M3 SP4
		Windows Vista	2.0		9.1 TS1M3 SP4
		64-bit Enabled AIX	2.0		9.1 TS1M3 SP4
		64-bit Enabled Solaris	2.0		9.1 TS1M3 SP4
		HP-UX IPF	2.0		9.1 TS1M3 SP4