topic Re: SAS VA last name text input search in SAS Visual Analytics

SAS VA last name text input search

anamika009 — Fri, 10 May 2019 16:16:04 GMT

i have created a text input on SAS VA report where user can search last name. i have assigned category last name to the input box so as the user types last name it shows the last name starts with that word.

client don't want this they want to be able to search last name that contains this specific word and filters the results. (like wildcard search)

e.g

when searching in “Last_Name” if I search “Hutterian” I only get the records where “hutterian” is the first word in the cell – not records like “Clear Lake Hutterian” or “Three Hills Hutterian”

please help!

Re: SAS VA last name text input search

Madelyn_SAS — Fri, 10 May 2019 16:22:15 GMT

You can achieve this by:

Re: SAS VA last name text input search

anamika009 — Fri, 10 May 2019 17:00:16 GMT

Hi Madelyn!

Thank you so much for your quick response!

I have followed the instructions and created the parameter and assigned it as a role to last name input box. I have also created the filter but its not working for me. Do i also assign the category under roles?

Please see attached file.

Re: SAS VA last name text input search

Madelyn_SAS — Fri, 10 May 2019 17:45:39 GMT

Yes, the data item should be in the Category role and its parameter should be in the Parameter role.

Re: SAS VA last name text input search

anamika009 — Fri, 10 May 2019 18:38:24 GMT

Hi Madelyn,

Thank you again!

data item (last_name) is in the category role and parameter in parameter role but its still not working. Please help!

Re: SAS VA last name text input search

Madelyn_SAS — Fri, 10 May 2019 20:48:19 GMT

I was actually incorrect. The Text Input control should have only the parameter assigned to the Parameter role. Here is an example:

Report has a Text Input control with Origin Parameter assigned to the Parameter role.
List table has these data items: Origin, Make, Invoice. Some valid values for Origin are Asia, Europe, USA.
List table has an Advanced Filter (Filters pane) with this expression:

( UpCase('Origin'n) Contains UpCase('Origin Parameter'p) )

I enter a lowercase letter a in the Text Input control and press ENTER. This is important because the value is not registered until you press ENTER.

The list table is filtered to show USA and Asia.

Re: SAS VA last name text input search

ASHISH2525 — Mon, 13 May 2019 08:17:18 GMT

Hi Anamika,

This is may be you were looking for.

Regards,

Ashish

( UpCase('Task name'n) Contains UpCase('Task name Parameter'p) )

Re: SAS VA last name text input search

anamika009 — Tue, 14 May 2019 15:32:36 GMT

Thank you so much Ashish!!

I have the similar code but its just not working for me. I have SAS VA 8.2.

Also if i don't have the category assigned for Last_Name i see an error sign on the input box.

Please see screenshots.

Please help!!!

Re: SAS VA last name text input search

ASHISH2525 — Tue, 14 May 2019 15:58:28 GMT

Anamika !

Please share the screenshot how you created this parameter ?
Did you apply the filter on list table it self ?

Regards,
Ashish

Re: SAS VA last name text input search

anamika009 — Tue, 14 May 2019 16:09:45 GMT

Hi Ashish!

Thank you once again for your quick response!

I have created the parameter by going into LAST_NAME category and adding a parameter from there.

I have applied the filter on the LAST_NAME T'ext_Input' box not the list table.

Please see the screenshots.

Re: SAS VA last name text input search

Madelyn_SAS — Tue, 14 May 2019 16:12:31 GMT

The filter needs to be on the list table.

Re: SAS VA last name text input search

ASHISH2525 — Tue, 14 May 2019 16:13:06 GMT

You have to apply the filter on list table only.

Re: SAS VA last name text input search

anamika009 — Tue, 14 May 2019 16:23:33 GMT

Hi Ashish!!!!

You are great thank you sooooo much for this and yes it solved the issue and i am getting the results i want!!

God Bless!!!! 🙂

Re: SAS VA last name text input search

ASHISH2525 — Tue, 14 May 2019 16:29:26 GMT

Cheers !!

Good to hear that.