STARTOBS= Table Option

Specifies the starting row number in a user-defined range of rows to be processed.

Valid in: SELECT statement
Category: Observation Control
Restriction: Use with input data sets only
Data source: SPD Engine data set, SPD Server tables

Syntax

STARTOBS= n

Arguments

n

is the number of the starting row.

Details

The software processes the entire data set unless you specify a range of rows with the STARTOBS= and ENDOBS= options. If the ENDOBS= option is used without the STARTOBS= option, the implied value of STARTOBS= is 1. When both options are used together, the value of STARTOBS= must be less than the value of ENDOBS=.
In contrast to the Base SAS software options FIRSTOBS= and OBS=, the STARTOBS= and ENDOBS= options can be used for WHERE clause processing in addition to table input operations. When STARTOBS= is used in a WHERE expression, the STARTOBS= value represents the first row on which to apply the WHERE expression.

Example

The following code shows how the STARTOBS= table option is specified in the FedSQL SELECT statement:
select * from spdslib.table1(startobs=3 endobs=4);

See Also

Table Options:
Last updated: February 23, 2017