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

SAS/ACCESS views and DATA step views are similar to PROC SQL views in that they are both data definitions of member type VIEW. SAS/ACCESS views describe data in DBMS tables from other software vendors ...

SQL (Structured Query Language) is a programming language used to communicate with and manipulate databases. Learn its history and when to use it.

Even if generative AI hides SQL behind the curtain, it will continue to play a critical role in how we interact with and use data.