SPDSEOBS Macro Variable

Specifies the number of the last row of a user-defined range that you want to process in a table.

Valid in:	SPD Server
Default:	The default setting of 0 processes the entire table.
Interaction:	Corresponding table option is ENDOBS=.

Syntax

Required Argument

Details

Example

Syntax

SPDSEOBS=n

Required Argument

n

the number of the end row.

Details

The server processes the entire table by default unless you specify a range of rows. You can specify a range using the macro variables SPDSSOBS and SPDSEOBS, or you can use the table options, STARTOBS= and ENDOBS=.

If you use the range start macro variable SPDSSOBS without specifying an end range value using the SPDSEOBS macro variable, the server processes to the last row in the table. If you specify values for both SPDSSOBS and SPDSEOBS macro variables, the value of SPDSEOBS must be greater than SPDSSOBS. The SPDSSOBS and SPDSEOBS macro variables specify ranges for table input processing as well as WHERE clause processing.

Example

In order to create test tables, you configure the server to subset the first 100 rows of each table in your job. Submit the macro variable statement for SPDSEOBS at the beginning of your job.

%let SPDSEOBS=100;

SPDSEOBS Macro Variable

Syntax

Required Argument

n

Details

Example

See Also