topic Re: How to use text input for multiple selections in SAS VA 7.3 in SAS Visual Analytics

How to use text input for multiple selections in SAS VA 7.3

Messham — Tue, 28 May 2019 09:39:59 GMT

Is it possible to use the text input control to filter a table using mutliple values? My example is an item code, and I want users to be able to search for multiple item codes with the results displayed together in the report. Currently, if I run this with one text input code, it filters down the table, but if i try multiple (spaced with space, comma or semi-colon) it doesn't work.

Re: How to use text input for multiple selections in SAS VA 7.3

PetriRoine — Tue, 28 May 2019 10:25:18 GMT

Hello @Messham

So if the end user types into Text Input control f.ex. ID10005; ID10015; ID20001 and I need to use these all to search matching item codes I would consider the following approach:

Create f.ex. 5 new calculated items and parse the string from the Text Input to these new calculated items.

Then utilize Contains() and OR functions.

Not a scalable solution, but maybe adequate?

Best regards,

Petri Roine

Re: How to use text input for multiple selections in SAS VA 7.3

Messham — Tue, 28 May 2019 10:39:11 GMT

Thank you for your solution - there are possibly thousands of codes so I don't think this is a solution. But I appreciate your help 🙂

Re: How to use text input for multiple selections in SAS VA 7.3

PetriRoine — Tue, 28 May 2019 10:55:33 GMT

Ok.

I'm not sure if I understood correctly as in this approach the total number of item codes is irrelevant. The key question is how many item codes would a single user search at any given time i.e. how many codes would they type into that Input Text control object. In my approach end user could search simultaneously five different codes. I guess maybe around ten would be maximum sensible amount in this approach.

If you meant that they need to enter thousands of item codes into that Input Text to be searched from the full spectrum of item codes - then yes, this is not the solution. Typing in thousands of codes is laborious, maybe they could copy-paste, but there's no sense creating that many help variables.

If however the end users most likely enter only a few item codes into that Input Text object to be searched, then this approach should do the trick.

Anyways, you definitely know the best your case, what works and what doesn't. I hope you find a fitting solution

Best regards,

Petri

Re: How to use text input for multiple selections in SAS VA 7.3

Messham — Tue, 28 May 2019 11:09:11 GMT

Maybe I misunderstood your solution.

Your solution says;

So if the end user types into Text Input control f.ex. ID10005; ID10015; ID20001 and I need to use these all to search matching item codes I would consider the following approach:

Create f.ex. 5 new calculated items and parse the string from the Text Input to these new calculated items.

What if the next user wants to search ID10004; ID101; ID20002; ID20012; ID351 - do I have to put all of the possible combinations into the solution?

Re: How to use text input for multiple selections in SAS VA 7.3

PetriRoine — Tue, 28 May 2019 12:06:38 GMT

The end user can type what ever codes they want - the codes (search strings) aren't fixed.

The number of codes (search strings) user can type in the Text Input to be searched is fixed. In my example the max number to be searched was five. That's why I had five new calculated items. Actually to be 100% correct the user can type in as many codes (search strings) as they want, but the maximum number of codes (search strings) to be processed is fixed.

I propose you try this and see how it works.

Br,

Petri

Re: How to use text input for multiple selections in SAS VA 7.3

Sam_SAS — Tue, 28 May 2019 13:39:48 GMT

Petri's solution is a clever one, although things arguably should be much simpler in VA. If you could assign a multi-value parameter to a text input control, for example, it would be much easier.

To spell things out a little more:

Create a character parameter and assign it to a text input control. In my example I'll call it InputParm. Users can input a delimited set of inputs like "Sedan; Hybrid"
Create a calculated item for each input you want to support. I will create two here, to support two inputs, but you can expand on this as much as you like.

a. Create an calculated item for the first input parameter, I am naming it Parm1.
GetWord('InputParm'p, 1)
b. Create the second calculated item, Parm2.
GetWord('InputParm'p, 2)
Now, create an advanced filter to compare these values to the category item in your data:

IF ( GetLength('InputParm'p) > 0 )
RETURN ( ( LowerCase('Type'n) Contains LowerCase('Parm1'n) ) OR ( LowerCase('Type'n) Contains LowerCase('Parm2'n) ) )
ELSE ( 1 = 1 )

You can omit the LowerCase() operator if you want the search to be case sensitive. You could also substitute '=' for Contains if you want exact matches only. This filter expression should accept 0, 1, or 2 inputs from the text input control: If you support more inputs, you can just keep adding OR clauses as needed.

No filter specified:

Two Type values specified:

Let us know if this helps,

Sam

Re: How to use text input for multiple selections in SAS VA 7.3

gizemetus — Wed, 18 Mar 2020 14:16:38 GMT

The filter does not work when using =. how can we do for numerical data?

Thank You!

Re: How to use text input for multiple selections in SAS VA 7.3

Sam_SAS — Wed, 18 Mar 2020 14:31:06 GMT

What do you mean when you say the filter does not work? Does the expression editor show an error message?

Re: How to use text input for multiple selections in SAS VA 7.3

gizemetus — Thu, 19 Mar 2020 07:47:45 GMT

Hi Sam . Actually, No error Only showing warning icon and it do not filter. this is a my query. when I use "contains" correct running . STOK_ID is numeric data but I converted character data.

IF ( GetLength('InputParm'p) > 0 )
RETURN ( ( LowerCase('STOK_ID'n) = LowerCase('Parm1'n) ) OR ( LowerCase('STOK_ID'n) = LowerCase('Parm2'n) ) )
ELSE ( 1 = 1 )

Re: How to use text input for multiple selections in SAS VA 7.3

Sam_SAS — Thu, 19 Mar 2020 14:56:34 GMT

@gizemetus, what does your expression for Parm1 look like? Are you using the Format() operator to convert the numeric to character?

If you are using Format(), this sometimes adds blanks to the start of the value, so " 4" does not match "4". Try the RemoveBlanks() operator to solve this.

Re: How to use text input for multiple selections in SAS VA 7.3

Sam_SAS — Thu, 19 Mar 2020 18:18:17 GMT

Oops, the expression for Parm1 shouldn't matter, but the RemoveBlanks() operator still might help.

You might also try changing your stock ID variable to character in the data preparation stage.

Re: How to use text input for multiple selections in SAS VA 7.3

gizemetus — Mon, 23 Mar 2020 17:19:16 GMT

Hi Sam,

I tried "remove blanks" function and I did. it's running report's filter. " thank you so much. Really!

Re: How to use text input for multiple selections in SAS VA 7.3

Sam_SAS — Mon, 23 Mar 2020 17:31:11 GMT

That is great to hear! Thanks for letting us know 🙂

Re: How to use text input for multiple selections in SAS VA 7.3

sushviper1 — Wed, 26 Mar 2025 07:16:29 GMT

Hi @Sam_SAS ,

I tried above solution and created calculated filter along with advance filter , my input textbox having alphanumeric value like ABC123 . so i kept input textbox as Character . In advance filter i used below code

IF (GetWord('Loan Account No'n)>0)

RETURN (( UpperCase('Loan Account No'n) Contains UpperCase('Parm1'n) ) OR ( UpperCase('Loan Account No'n) Contains LowerCase('Parm2'n) ))

ELSE (1=1)

this showing me an error as Expected : Numeric constant ,numeric, date or datetime . i dont know how to resolve this issue .

Re: How to use text input for multiple selections in SAS VA 7.3

Sam_SAS — Wed, 26 Mar 2025 14:08:19 GMT

@sushviper1 wrote:

Hi @Sam_SAS ,

I tried above solution and created calculated filter along with advance filter , my input textbox having alphanumeric value like ABC123 . so i kept input textbox as Character . In advance filter i used below code

IF (GetWord('Loan Account No'n)>0)

RETURN (( UpperCase('Loan Account No'n) Contains UpperCase('Parm1'n) ) OR ( UpperCase('Loan Account No'n) Contains LowerCase('Parm2'n) ))

ELSE (1=1)

this showing me an error as Expected : Numeric constant ,numeric, date or datetime . i dont know how to resolve this issue .

Hello,
I think the main issue is with your IF condition -- GetWord() will return a string but you are comparing it to a number. Did you mean to use GetLength()?
Your RETURN clause has UpperCase(), but I think that should be UpCase(). Unless the name was different before VA 7.5.

Let us know if that helps!

Sam

Re: How to use text input for multiple selections in SAS VA 7.3

sushviper1 — Thu, 27 Mar 2025 06:30:38 GMT

"Loan Account no" contain alphanumerical values .

Re: How to use text input for multiple selections in SAS VA 7.3

Sam_SAS — Mon, 31 Mar 2025 14:38:25 GMT

If the account number only contains number characters, you can use the TreatAs() operator to cast the values to numeric. If you have values like "12344A", then expression syntax cannot evaluate whether that is greater than zero.

Re: How to use text input for multiple selections in SAS VA 7.3

sushviper1 — Wed, 09 Apr 2025 09:31:55 GMT

Hi @Sam_SAS so could you please provide a solution to overcome this issue ?

Re: How to use text input for multiple selections in SAS VA 7.3

Sam_SAS — Wed, 09 Apr 2025 14:04:01 GMT

@sushviper1 In your expression you are trying to compare a character value to a numeric one. The app cannot evaluate whether a character string is "greater than" zero.

It would be helpful if you could provide an example value from your Loan account number column.