The solution is to use SQL views, materialized views, or create a new table that contains only the filtered data the user needs.

When executed, a PROC SQL view's output can be a subset or superset of one or more underlying files. Beginning in Version 7, you can reference a simple PROC SQL view to update its underlying data. SAS ...

Just use SQL views instead of select statements and then treat the views the same as tables, and we’re done. Views have more limitations than select statements, but for most use cases, they’ll ...