ENDOBS= LIBNAME Statement Option

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

Valid in: SPD Server LIBNAME Statement

Syntax

ENDOBS=n

Required Argument

n

the number of the end row.

Details

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

Comparisons

In contrast to the Base SAS software options FIRSTOBS= and OBS=, the STARTOBS= LIBNAME option and ENDOBS= LIBNAME option 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 statement is active.
libname mydatalib sasspds 'conversion_area'
   server=husky.5105
   user='siteusr1'
   prompt=yes
   startobs=200
   endobs=500;

See Also

SPD Server macro variables:
SPD Server table options:
Last updated: February 8, 2017