Hello - I would like to ask for advice on how to accomplish a task.
I have a file that lists account numbers in sequential order. There are approximately 70,000,000 records in this file and it is produced weekly. I often receive requests to fetch account numbers where I know what the first six digits of the account number are. I will often receive requests for multiple criteria (e.g. list all accounts where the first six digits is equal to 123456, 234567, 345678, etc…).
Since I know the account numbers are listed in numeric order, once all the criteria has been searched (123456, 234567, 345678, etc…), how to I tell SAS to stop searching the rest of the file? Using the provided example, once the account numbers start with 345679, I no longer need to continue searching the current file and can move on to the next input file.
Anyone have any suggestions?
Thanks!
I have a file that lists account numbers in sequential order. There are approximately 70,000,000 records in this file and it is produced weekly. I often receive requests to fetch account numbers where I know what the first six digits of the account number are. I will often receive requests for multiple criteria (e.g. list all accounts where the first six digits is equal to 123456, 234567, 345678, etc…).
Since I know the account numbers are listed in numeric order, once all the criteria has been searched (123456, 234567, 345678, etc…), how to I tell SAS to stop searching the rest of the file? Using the provided example, once the account numbers start with 345679, I no longer need to continue searching the current file and can move on to the next input file.
Anyone have any suggestions?
Thanks!