SAS Data Integration Studio 4.9

For Users

To use the stored process feature efficiently, you should be familiar with stored process

parameters, input streams, and result types. For a detailed discussion of stored processes,

see SAS Stored Processes: Developer's Guide.

Deploying Jobs as Stored Processes

Problem

You want to make a job available to any application that can execute a SAS stored

process.

Solution

Deploy the job as a stored process. You can deploy an existing job as a version 1.0 or

version 2.0 stored process. For more information about the differences between the

versions, see “Working with Stored Processes” on page 43.

Note that when you deploy a job as a stored process, the generated code for the stored

process always begins with these lines:

*ProcessBody;

%stpbegin;

If you want to specify code that should come before these two lines when a job is

deployed as a stored process, then set the Stored process pre-process code option for

the job. To access this option, display the properties window for the job and select

Options ð General section. Specify the desired code in the Stored process pre-

process code option.

Tasks

Deploy a Job as a Version 1.0 Stored Process

You might want to deploy a job as a version 1.0 stored process in order to run it on an

older server (a server with a version prior to SAS 9.3). Perform the following steps:

1. In the Inventory tree or the Folders tree on the SAS Data Integration Studio desktop,

right-click the job for which you want to generate a stored process. Then, select

Stored Process ð New 9.2 from the pop-up menu. The first window of the Stored

Process

wizard is displayed.

238 Chapter 10 • Deploying Jobs

Display 10.3 General Tab

2. In the first window, enter a descriptive name for the stored process metadata. You

might want to use a variation of the job name. Enter other information as desired. For

details about the fields in this window, select Help. Click Next to access the

Execution tab of the wizard.

3. Specify a SAS server, a source repository, a source filename, any input stream, and

any output type (result type) for the new stored process. The following display shows

some sample values for this window.

Deploying Jobs as Stored Processes 239

Display 10.4 Execution Tab

Click Next to access the Parameters tab, where you can specify any parameters that

you need for the stored process.

4. Click Next to access the Data tab, where you can specify any data sources and

targets that are used by the stored process.

5. Click Finish. A stored process is generated for the current job and is saved to the

source repository. Metadata about the stored process is saved to the metadata server.

A metadata object for the stored process is added to the Stored Process folder in the

Inventory tree.

After the job has been deployed, it can be executed with any application that can execute

a SAS stored process.

Deploy a Job as a Version 2.0 Stored Process

You might want to deploy a job as a version 2.0 stored process in order to run it on a

SAS 9.3 or later server. Perform the following steps:

1. In the Inventory tree or the Folders tree on the SAS Data Integration Studio desktop,

right-click the job for which you want to generate a stored process. Then, select

Stored Process ð New 9.3 from the pop-up menu. The New 9.3 selection is

appropriate for any version 2.0 stored process, whether it will run on a SAS 9.3

server or a later server. The first window of the Stored Process wizard is displayed.

2. In the first window, enter a descriptive name for the stored process metadata. You

might want to use a variation of the job name. Enter other information as desired. For

details about the fields in this window, select Help. Click Next to access the

Execution tab of the wizard.

3. Specify a SAS server, a source repository, a source filename, any input stream, and

any output type (result type) for the new stored process. For more information about

the additional servers available for version 2 stored processes, see “Working with

Stored Processes” on page 43.

240 Chapter 10 • Deploying Jobs