I have somehow a dumb question, but understand if what we need to obtain is somehow feasible or not.
We have some tables Y1..Yn that all have in common a certain ID (possibly not unique) and a table X that hase the ID associated informations.
What we need/would like to obtain is this:
in one report, prepare a lot of objects that act as filters to identify some IDs (the filters come from all the tables Yn, and do not filter by ID, they just identify some IDs).
in another report (or page) having a table objects that show the ID from the X table filtered for just the IDs (possibly hundres of) identified by the "filter report".
Is this obtainable in some way? Actually we have mange to filter the second table just by mapping the two tables by all the columns we use to filter, but se last table does not have them all, since they would cause duplications on data...
Thanks for any support!!! 🙂
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.