SAS Web Report Studio can render stored processes only when they conform to a specific set of rules. In some cases, if the stored process includes unsupported syntax, there is no output in SAS Web Report Studio. In other cases, you see an error message. This SAS Note contains key points that you should be aware of when displaying stored process output in SAS Web Report Studio.

Tip: As an alternative to SAS Web Report Studio, you can use the SAS^® Stored Process Web Application, which is specifically designed to display output from stored processes. For more information, see "Using the SAS^® Stored Process Web Application Pages" in the SAS Stored Processes: Developer's Guide.

• The stored process must begin with a *ProcessBody statement, and the code must be enclosed within %STPBEGIN and %STPEND macros in order to ensure that the Output Delivery System (ODS) is used to generate the output. The general form is:

  *processbody; %stpbegin; title "Sports & Outdoors Sales"; proc print data=sashelp.orsales; run; %stpend;

  Output that is generated in other ways, such as with PUT statements, is not supported.

• The stored process must produce package output. Streaming output is not supported, which means that the _WEBOUT fileref is also not supported.

  Note: Package output takes longer to render than streaming output. The SASREPORT output format that SAS Web Report Studio creates is an XML representation of the report. SAS Web Report Studio must unpack the transient package to a temporary cache location, read the XML output for the stored process, and render the XML into a viewable form.

• You cannot use the _ODSDEST macro variable to control the format of the output. So, for example, you cannot specify that the output should be PDF or PostScript.

• You cannot control the result type by explicitly setting the _RESULT input parameter. So, for example, you cannot specify PACKAGE_TO_EMAIL.

• By default, the ACTIVEX device driver is used for graphs in stored process output. When the stored process is run in SAS Web Report Studio, the ACTXIMG device driver is substituted so that a static image is created. Similarly, if the JAVA device driver is specified, the JAVAIMG device driver is substituted automatically.

• In tabular output created by stored processes, SAS Web Report Studio might display URLs as plain text or it might display unlinked values, depending on how the link is specified. (For more information, see SAS Note 39443.)
• The ODS Layout statement is not supported.

For information about making stored processes available in SAS Web Report Studio, see the topic "Making Stored Processes Available to SAS Web Report Studio" in the SAS Intelligence Platform: Web Application Administration Guide.

Note: The sample stored processes that are shipped with the SAS^® BI Server and SAS^® Enterprise BI Server are not designed to work with SAS Web Report Studio. For more information, see SAS Note 48136.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Web Report Studio	Microsoft Windows 2000 Advanced Server	3.1		9.1 TS1M3 SP4
		Microsoft Windows 2000 Datacenter Server	3.1		9.1 TS1M3 SP4
		Microsoft Windows 2000 Server	3.1		9.1 TS1M3 SP4
		Microsoft Windows 2000 Professional	3.1		9.1 TS1M3 SP4
		Microsoft Windows NT Workstation	3.1		9.1 TS1M3 SP4
		Microsoft Windows Server 2003 Datacenter Edition	3.1		9.1 TS1M3 SP4
		Microsoft Windows Server 2003 Enterprise Edition	3.1		9.1 TS1M3 SP4
		Microsoft Windows Server 2003 Standard Edition	3.1		9.1 TS1M3 SP4
		Microsoft Windows XP Professional	3.1		9.1 TS1M3 SP4
		Windows Vista	3.1		9.1 TS1M3 SP4
		Windows Vista for x64	3.1		9.1 TS1M3 SP4
		64-bit Enabled AIX	3.1		9.1 TS1M3 SP4
		64-bit Enabled Solaris	3.1		9.1 TS1M3 SP4
		HP-UX IPF	3.1		9.1 TS1M3 SP4

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

SAS Web Report Studio can render stored processes only when they conform to a specific set of rules. This SAS Note contains key points that you should be aware of when displaying stored process output in SAS Web Report Studio.

Type:	Usage Note
Priority:

Date Modified:	2019-05-16 09:33:21
Date Created:	2012-09-07 15:25:39