Creating a Stored Process
A stored process is a stored SAS source programs. A client can
then use the name of the process to execute the program and receive the results.
The SAS Integration Technologies Administrator provides a graphical user interface that allows you
to create or modify a stored process. For general instructions, see Using IT Administrator.
To create a new stored process using IT Administrator:
Open IT Administrator.
Select Applications in the Manager Bar.
Select the Stored Process Paths folder in the
tree view.
- Select the node representing the stored process path for the new stored
process. If the path is a folder, open the folder and select any stored
process node beneath the folder.
- If you are creating the first stored process under the selected stored
process path, you must select File
New
Stored Process in order to
create the process. Otherwise, click the
New button (
).
The New Stored Process window appears requesting property information for the
new stored process.
- Enter the name and description of the process. This
information identifies the process in the directory.
In the SAS Stored Process section, enter the following
- Descriptive Label
- A short label for the stored process. If you specify a value
for this field, you must also specify a value for the File field.
- File
- The name of the stored SAS program. If you specify a value
for this field, you must also specify a value for the Descriptive Label field.
- Portal JSPe
- The java stored page used to access the program
In the Parameters field, enter the parameters that are
passed to the SAS program upon execution. You can have more
than one parameter set.
Valid parameters are:
- DATA_SOURCE
- Specifies the distinguished name of a data source used to generate
a list of valid values for the parameter. Used together with the REPORT_QUERY parameter.
- DEFAULT_VALUE
- Specifies the default value for the parameter.
- DESCRIPTION
- Provides a description of the parameter.
- LABEL
- Specifies the label to display when the user sees the parameter.
- NAME
- Specifies the name of the parameter.
- REPORT_QUERY
- An SQL statement used together with DATA_SOURCE
to generate a list of valid values for the parameter.
- REQUIRED
- Specifies whether the parameter is required (value is true)
or not required (value is false).
- VALUES
- List the possible values for the parameter. If VALUES is not specified,
DATA_SOURCE and REPORT_QUERY are used to generate the list.
- When you are finished entering information in the fields, click OK. The new stored process appears in
the tree view.
If the OK button remains gray, check the Descriptive
Label and File fields. You must either enter values in both fields or
neither field. If you enter a value in one field but not the other, the
OK button will remain grayed.
To modify or view details about a stored process using IT Administrator:
Open IT Administrator.
Select Applications in the Manager Bar.
Expand the Stored Process Paths folder, then select
the stored process whose details you want to modify or view.
The properties appear in the properties area.
The properties area displays these fields
- Description
- A description of the stored process
- File
- The name of the stored SAS program
- Portal JSP
- The java stored page used to access the program
- Descriptive Label
- A short description of the process
- Parameters
- The parameters that are passed to the SAS program upon execution. You may
have more than one set of parameters for each stored process. To add a
parameter set, select the Add button. The Add Value dialog
box appears, in which you can add the new parameter set. Select a
parameter set and select the Edit button to change the parameter
values, or Remove to remove the set.
When you are finished, select the Save button (
)
to save the changes
to the server. If you attempt to navigate to another object, the
administrator application will prompt you to save any changes you made to
the process.
