seq()

The seq( function returns sequential numbers (1, 2, 3, etc.).


Parameters

No parameters.


Description

The seq() function returns sequential numbers (1, 2, 3, etc.). This function works in conjunction with repetitive operations like formulafill, arrayfilter(, characterfilter( etc.

When it is used with the formulafill, find or select statements, the seq( function returns a sequential number for each applicable record (the first selected record is 1, the second is 2, etc.). A record is applicable if the formula is applied to it, for example, selected records for formulafill, or selectwithin, and all records for select.

When it is used with filter operations (arrayfilter, characterfilter, etc.), the seq( function returns a sequential number for each element in the array being processed (the first array element is 1, the second is 2, the third is 3, etc.).

When it is used at any other time, the seq( function returns the number 1.

This procedure selects the first 10 records in the database:

select seq()<=10

The procedure below will select every 5th record in the database.

select (seq() mod 5)=0

By changing the 0 in this formula to 1, 2, 3, or 4 you can select different sets of data, but still 20% of the database each time.


See Also


History

VersionStatusNotes
10.0No ChangeCarried over from Panorama 6.0