Providing software solutions since 1976
Training & Bookstore
When using 6 or more WHERE ALSO statements in a DATA Step, SAS will return either incorrect results, a Read Access Violation ERROR, or SAS will terminate.
To circumvent the problem you will need to ensure you use 5 or less WHERE ALSO statements in the DATA Step by combining multiple WHERE ALSO statements.
Another circumvention is to use 1 WHERE clause with multiple AND conditions in the DATA Step instead of using the WHERE ALSO statements.
A fix for this issue for Base SAS 9.21_M3 is available at: