topic Re: Where Expression to quickly and accurately find a name (character) in a table in SAS Procedures

Where Expression to quickly and accurately find a name (character) in a table

req41273 — Mon, 10 Jun 2019 17:17:46 GMT

What is the correct Where expression to quickly and accurately find a name in the data while in the attached window? Example, I need to find a provider name of Stallings...what expression would I type? Please see attachment

thanks

Where Expression to quickly and accurately find a name (character) in a table

req41273 — Mon, 10 Jun 2019 17:17:44 GMT

thanks

Where Expression to quickly and accurately find a name (character) in a table

req41273 — Mon, 10 Jun 2019 17:17:48 GMT

thanks

Re: Where Expression to quickly and accurately find a name (character) in a table

ballardw — Mon, 10 Jun 2019 17:51:30 GMT

Some things to you need to provide:

Is CASE important? Matching both Stallings and STALLINGS or not?

Is composite content important? Is "JohnStallings" yes one word on purpose, supposed to be a match for "Stallings"?

Do you need to search more than one variable?

Please do not post identical posts on this forum. It generally will not get a quicker or better answer.

Re: Where Expression to quickly and accurately find a name (character) in a table

req41273 — Mon, 10 Jun 2019 18:23:46 GMT

No, case is not important. Only one variable and if it contains the letters stallings and nothing else or stallings and few letters after it.

Re: Where Expression to quickly and accurately find a name (character) in a table

Reeza — Mon, 10 Jun 2019 18:56:43 GMT

FYI - I've merged your posts, not sure why you have three identical ones.

Also, please just insert your image rather than have attachments. I can't download attachments anymore and many others can't either.

Re: Where Expression to quickly and accurately find a name (character) in a table

req41273 — Fri, 14 Jun 2019 14:05:44 GMT

I did not intentionally post multiple times. The system website did this.