topic Choose character variables and find a piece of string in SAS Programming

Choose character variables and find a piece of string

MargoBlue — Fri, 26 Jul 2019 16:13:57 GMT

I choose any table - I can change it any time. The table has numeric and character variables. I would like to have possibility to search and find any text in character columns, for example by prompt manager, and show all rows for typed text.

Could you give me some tips how I should start? I thought about prompts one for type the text, and the second one to choose character variables (but they can change if I change the table).

Thank you in advance.

Re: Choose character variables and find a piece of string

PeterClemmensen — Fri, 26 Jul 2019 16:16:14 GMT

I think this is what you want

http://support.sas.com/kb/33/078.html

Re: Choose character variables and find a piece of string

Reeza — Fri, 26 Jul 2019 16:17:20 GMT

Here is a reference that illustrates how to refer to variables and datasets in a short cut list:
https://blogs.sas.com/content/iml/2018/05/29/6-easy-ways-to-specify-a-list-of-variables-in-sas.html

You can refer to the _character_ for all variables.

Using something like the following should get you started. X will concatenate all character variables into a single string that you cna then search with FIND/INDEX. Not sure what you want to do after that.

x = catx("|", of _character_);
y = find("ValueToFind", x);

@MargoBlue wrote:

I choose any table - I can change it any time. The table has numeric and character variables. I would like to have possibility to search and find any text in character columns, for example by prompt manager, and show all rows for typed text.

Could you give me some tips how I should start? I thought about prompts one for type the text, and the second one to choose character variables (but they can change if I change the table).

Thank you in advance.