Using SAS Tables

Changing the Sequence of Reading Rows in SCL Programs

When an application displays a subset of a SAS table, you may want to let users display and scroll through all rows that meet the search conditions. To do this, you can use a set of SCL functions that reread table rows. For example, when a program displays the first row that meets the conditions, SCL provides functions that you can use to mark the row. Then a user can continue to search the rest of the SAS table for any other rows that meet the search conditions, counting them along the way. After finding the last row that meets the search conditions, the user can redisplay the first row in the subset (the row that was marked earlier). The following sequence of steps implements this technique:

Use the NOTE function to mark a row in the subset for later reading.
Use the POINT function to return to the marked row after you have located all rows that meet the search conditions.
Use the DROPNOTE function to delete the NOTE marker and free the memory used to store the note after the program finishes using the noted row.

Top of Page