The easiest would be to define the filter in the Data Builder interface.
Another option would be to pre-process data in a SAS batch program, and store store the intermediate table in a staging area, or in a SASHDAT location (if you are in distributed environment).
... View more