STARTOBS= LIBNAME Statement Option

Specifies the start row number in a user-defined range for processing.

Valid in:

SPD Server LIBNAME Statement

Syntax

STARTOBS=n

Required Argument

n

the number of the start row.

Details

By default, the server processes the entire table unless the user specifies a range of rows with the LIBNAME statement options STARTOBS= and ENDOBS=. If the ENDOBS= LIBNAME statement option is used without the STARTOBS= LIBNAME statement option, the implied value of STARTOBS=LIBNAME statement option is 1. When both options are used together, the value of the STARTOBS= LIBNAME statement option must be less than the value of the ENDOBS= LIBNAME statement option.

In contrast to the Base SAS software options FIRSTOBS= and OBS=, STARTOBS= and ENDOBS= can be used for WHERE clause processing in addition to table input operations.

Example

Specify for the server to process only row numbers 200–500 while the LIBNAME is active.

libname mydatalib sasspds 'conversion_area'
   server=husky.5105
   user='siteusr1'
   prompt=yes
   startobs=200
   endobs=500;

STARTOBS= LIBNAME Statement Option

Syntax

Required Argument

n

Details

Example

See Also