You could use the MONOTONIC() function in a query. This undocumented SQL feature allows you to add a sequential number (1 on first row, 2 on second, 3 and so on). If you have conditions in a WHERE statement, the numered rows are only the selected ones.
I hope it solves your problem.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.