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

How do I select more than 1,000 items when filtering

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

How do I select more than 1,000 items when filtering

Hello, I'm quite new to SAS VA, and recently I've been trying to use filters.

When I'm trying to select the IDs that I needed, I want to select all 1972 items, so that I can link this filter to another data source, but it seems like I can only select up to 1,000

SASQ.png

So I'm wondering how can I select more than 1,000 items, because I really don't want to select them by typing the rest 972 IDs.

Thanks a lot!


Accepted Solutions
Solution
‎05-27-2015 02:12 PM
SAS Super FREQ
Posts: 275

Re: How do I select more than 1,000 items when filtering

Hi Candy,

I think the ideal workaround (if possible) would be for you to work with your data administrator to join your "gender" variable into the other data source, but maybe that is not a possibility for you.

Within VA, you can actually have a filter that selects more than 1,000 specific values:

filter1000.png

The trick is how to select those values when the selector list will only show you the top 1000. If you use the search conditions at the top of the selector window, then you can use a condition like "Begins with 6" to display a subset of the values. You can click the "add all" button for each subset of values until they are all selected.

I think that should work for you! Can you let us know?

Thanks,

Sam

View solution in original post


All Replies
Super User
Posts: 1,205

Re: How do I select more than 1,000 items when filtering

Hi,

I assume you are wanting to select all of the IDs to Link a Global Filter to another data source as described at SAS(R) Visual Analytics 7.1: User's Guide ?


As the dialogs are limited to 1000 items for basic filters and your IDs appear as numbers perhaps you could use the TreatAs _Number_ function and use the between operator to capture all your id values instead.

Kind Regards,

Michelle

New Contributor
Posts: 4

Re: How do I select more than 1,000 items when filtering

Thanks for the tip, but the problem is that the IDs are already filtered, so they are not in continuous order.

And the reason I didn't use report to link them is I needed this to do diagrams that aren't available in the SAS VAs reports (like decision tree or see the path behavior)

Smiley Happy

SAS Super FREQ
Posts: 275

Re: How do I select more than 1,000 items when filtering

Hello,

Are your ID values filtered as part of the data preparation? Could you do something similar in the data preparation for the second data source, possibly storing the filtered values in a new column?

Thanks,

Sam

New Contributor
Posts: 4

Re: How do I select more than 1,000 items when filtering

Hi,

I have two data sources that I cannot edit, they already prepared the data, so the functions that I can use are explore the data and put it in a report.

I filtered the IDs is because I only want to see for example female IDs only.

The only column that I could use to link both data sources is the ID column.

So that's why I'm stuck with the situation that I want to select more than 1,000 items for my filter.

May there be a chance maybe it's not possible yet to do it in VA?

Thanks again~

Candy

Solution
‎05-27-2015 02:12 PM
SAS Super FREQ
Posts: 275

Re: How do I select more than 1,000 items when filtering

Hi Candy,

I think the ideal workaround (if possible) would be for you to work with your data administrator to join your "gender" variable into the other data source, but maybe that is not a possibility for you.

Within VA, you can actually have a filter that selects more than 1,000 specific values:

filter1000.png

The trick is how to select those values when the selector list will only show you the top 1000. If you use the search conditions at the top of the selector window, then you can use a condition like "Begins with 6" to display a subset of the values. You can click the "add all" button for each subset of values until they are all selected.

I think that should work for you! Can you let us know?

Thanks,

Sam

New Contributor
Posts: 4

Re: How do I select more than 1,000 items when filtering

Thank you Sam, I used the workaround trick and it worked!

Thanks to everyone that had replied.

CandySmiley Happy

Post a Question
Discussion Stats
  • 6 replies
  • 452 views
  • 2 likes
  • 3 in conversation