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 ...

What Is Sql Server Business Intelligence Edition? Database management and business intelligence software solution, Microsoft SQL Server Business Intelligence (BI) Edition is designed to work at all ...