BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
StringPiggy
Calcite | Level 5

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Sam_SAS
SAS Employee

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

6 REPLIES 6
MichelleHomes
Meteorite | Level 14

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

//Contact me to learn how Metacoda software can help keep your SAS platform secure - https://www.metacoda.com
StringPiggy
Calcite | Level 5

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

Sam_SAS
SAS Employee

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

StringPiggy
Calcite | Level 5

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

Sam_SAS
SAS Employee

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

StringPiggy
Calcite | Level 5

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

Thanks to everyone that had replied.

CandySmiley Happy

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 6 replies
  • 1485 views
  • 2 likes
  • 3 in conversation