Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Filter a list table by the selection in an other list table

Reply
New Contributor
Posts: 3

Filter a list table by the selection in an other list table

Hello everyone,

 

I am using SAS Visual Analytics 7.2 and I have a question about the filter interaction between a list table and a list. My list table filters my list that contains one of the columns/variables from the list table. Now, when I use this list to filter a second list table that also contains the column/variable from the list, the second list table is not only filtered by the chosen value from the list, but the entire selected row in the first list table is passed through as a filter. I will try to explain my problem with a simple example. Let the first list table be given by:

 

Name          Age           Sex

Pete            21               M

Rose           23               F

Hank           45               M

Jenny          67               F 

James         23               M

 

Now, this list table is linked to a list containing the variable Sex, and when I select the first row of the list table (Pete), I want to obtain the value for the variable Sex of that row, which is M, and use this as a filter for the second list table that for example looks like this:

 

Name          Age           Sex

Holly           33               F

Pete            21               M

Rose           23               F

Hank           45               M

Jenny          67               F 

James         23               M

 

I want to use the selection in the first list table to filter on the variable Sex in the second list table. So, if I select the row for Pete in the first list table, I want to have all the rows with Sex equal to M in the second list table. My idea was to place a list containing the variable Sex between the two list tables. Then by selecting Pete in the first list table, which is linked to the list, I have that in the list for Sex only M is selected. Then, I would think that by linking this list to my second list table, it would filter the second list table on Sex = M, however, it filters on all the information on the row for Pete, hence it only shows the exact same row (Pete) in the second list table, instead of all rows with Sex = M. Now, my question: Is it possible to select a row in a list table, and use only the value of one particular column/variable of that row which can be used to filter another list table (containing this same column/variable). 

 

I hope my explanation is clear enough and you guys know a solution.

 

Thanks in advance.

 

Mick

SAS Super FREQ
Posts: 830

Re: Filter a list table by the selection in an other list table

I have no longer VA7.2 available, with VA7.4 you can do what you want.

 

ListTable1 filters List1

Assign a Character list parameter to List1

Enable Required checkbox, will select one value be default

Use the Character list parameter in a filter on ListTable2

 

See below

 

RegionCapture.png

New Contributor
Posts: 3

Re: Filter a list table by the selection in an other list table

Posted in reply to Bruno_SAS

Hi Bruno,

 

Thank you for your quick answer. I have searched for the Character List Parameter in VA 7.2, but could not find it. Therefore, I searched for the additionial options in VA 7.4 and found this: "Parameters have been enhanced. You can now have parameters with multiple values, which enables you to use them in a list control." I guess this is the update I would need to be able to use the Character List Parameter.

 

Thanks again,

 

Mick

SAS Super FREQ
Posts: 830

Re: Filter a list table by the selection in an other list table

Yes Character list parameters are new with VA7.4.

You will get a lot more additional functionality when you upgrade to VA7.4, so it is worthwile the effort.

Ask a Question
Discussion stats
  • 3 replies
  • 320 views
  • 0 likes
  • 2 in conversation