topic Re: Manipulating the default Execution options page in Developers

Manipulating the default Execution options page

PaulSmeekens — Mon, 24 Jul 2006 06:43:52 GMT

Is there a way to manipulate the execution options page that you get as a default when running SAS Stored Processes. We typically want to override some of the defaults (display result in a new window [NO]) and hide some of the choices "Show SAS Log", "Show Execution time", "Show execution trace", etc.

Although there is mention in the documentation that this page can be manipulated I can not seem to find the way to do this.

Any help will be greatly appreciated.

Paul Smeekens
OZ zorgverzekeringen

Re: Manipulating the default Execution options page

deleted_user — Tue, 01 Aug 2006 15:13:27 GMT

We are also very interested in being able to adjust the available execution options. We would like to surface stored processes and parameter metadata in the BI Portal, but do not want to allow all those execution options to all users. Any documentation on how to accomplish this would be greatly appreciated.

Ryan Cherland
Univ of Kansas

Re: Manipulating the default Execution options page

Vince_SAS — Thu, 24 Aug 2006 16:22:53 GMT

Currently you can hide some, but not all of these items by adding input parameters with names that correspond to the items. For example, the input parameter named "_ODSDEST" corresponds to item labeled "Output type".

Here is a list of the things you can hide, and the properties of the input parameters you need to add in order to hide them:

To hide the "Output type" item:

Label:
SAS variable name: _ODSDEST
Visible: No
Type: String
Default value:

To hide the "ODS style" item:

Label:
SAS variable name: _ODSSTYLE
Visible: No
Type: String
Default value:

To hide the "Graphics device" item:

Label:
SAS variable name: _GOPT_DEVICE
Visible: No
Type: String
Default value:

To hide the "Show SAS Log", "Show execution time", and "Show execution trace" items:

Label:
SAS variable name: _DEBUG
Visible: No
Type: String
Default value:

This must be done for each individual stored process.

We hope to have better support for customization in a future release.

Vince DelGobbo
SAS R&D

Re: Manipulating the default Execution options page

RMP — Tue, 17 Oct 2006 14:57:07 GMT

Paul,

You can easily create a customised JSP to mimic the options page. When a stored process is run a search is made for a similar named jsp. If this is found then this jsp is displayed instead of the default execution options screen.
I can send some examples if needed.

Richard

Re: Manipulating the default Execution options page

Cynthia_sas — Thu, 26 Oct 2006 14:38:16 GMT

This Tech Support note outlines how to avoid getting the execution options page: one way is to generate a custom jsp and another way is to make a URL display portlet:
http://support.sas.com/techsup/unotes/SN/018/018281.html
cynthia