In SAS Enterprise Guide, when you use a WHERE clause on a compressed data set in the data grid, the data set is correctly filtered. However, No data might be displayed when you try to scroll to the bottom of the output data, as shown in the following image:
In addition, an error similar to the following might occur in the SAS Enterprise Guide log:
[Error] Record id is not in where statement history.
This problem might occur in SAS® Enterprise Guide® versions 8 and earlier. In versions earlier than version 8, SAS Enterprise Guide might return a pop-up message error, preventing the filtering of the data set properly. Starting with version 8, the filter is applied correctly. However, when scrolling, the output data for some values might display No data.
To avoid this issue, use the COMPRESS=NO option when you create your data set. Alternately, you could use a Query Builder to filter your compressed data sets instead of the WHERE clause.
This issue has been fixed in SAS® Enterprise Guide® 8.6.