SPDSSOBS Macro Variable

Specifies the number of the starting row in a user-defined range of a table.

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

Syntax

Required Argument

Details

Example

Syntax

SPDSSOBS=n

Required Argument

n

the number of the start row.

Details

By default, the server processes entire tables 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 specify the end of a user-defined range using the SPDSEOBS macro variable, but do not specify the beginning of the range using SPDSSOBS, the server sets SPDSSOBS to 1. 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

Print the Inventory.OldAutos table, skipping rows 1-999, and beginning with row 1000. You should submit the SPDSSOBS macro variable statement before the PROC PRINT statement in your job.

%let SPDSSOBS=1000;

The statement above specifies the starting row with SPDSSOBS, but does not declare an ending row for the range using SPDSEOBS. When the program executes, SAS will begin printing at row 1000 and continues until the final row of the table is reached.

proc print data=inventory.oldautos;
run;

SPDSSOBS Macro Variable

Syntax

Required Argument

n

Details

Example

See Also