05-21-2018 06:03 AM
I am trying to filter a table in SAS VA based on values from a different table. For example, let:
Name Age Sex
Pete 21 M
Rose 23 F
Hank 45 M
I would like to be able to select "dog", from table B, through a filter and retrieve information about Pete and Hank from table A. Does anyone know if this is possible in SAS VA?
05-21-2018 06:16 AM
You can build an interaction so when you click on one of the names the details for that name is shown.
I.e, you filter table b on dog and get two rows. Then you click on one of the names and filter table1.
If you want the two names at once, I think you need to join data in the data prep so you get all in the same table.
05-21-2018 06:31 AM
05-21-2018 08:49 AM
No it shouldn't be a problem.
I have a similiar report (with two tables) where I filter one table upon department and then I select one contract from the first table and in the second I show the details for that contract.
My tables are ~5 Gb.
In my case every click sows just 5-10 rows with details, maybe you get to many there?