topic Re: Need to query for a variable value that only contains a single word in New SAS User

Need to query for a variable value that only contains a single word

Elliott — Tue, 02 Jul 2019 18:25:05 GMT

I need to query a name variable and the user wants to know if the name is only a single word. The variable contains business names so should have multiple words. How do I do that.. for the specific words I am using index(lowercase(name), "Corp")>0 but I do not know how to query for a singer word, no matter what it is. The name field is Char 26.

Any assistance you can offer will be greatly appreciated.

Thanks,

Elliott

Re: Need to query for a variable value that only contains a single word

Haris — Tue, 02 Jul 2019 18:31:13 GMT

Are you looking for COUNTW function?

Re: Need to query for a variable value that only contains a single word

Elliott — Tue, 02 Jul 2019 18:50:11 GMT

no, I need to identify if the business name is only a single word, no matter how many characters. The user feels this may be an invalid name and wants to review the information. They feel a single name with no spaces is an invalid business name and should be flagged.

Thanks,

Re: Need to query for a variable value that only contains a single word

Haris — Tue, 02 Jul 2019 19:02:45 GMT

COUNTW counts words, not characters. CountW(VarName)=1 sounds like the condition you're looking for.

Re: Need to query for a variable value that only contains a single word

Reeza — Tue, 02 Jul 2019 19:16:38 GMT

COUNTW() is correct, please try it and let us know. If it's not, post the code you've tried and show an example of a case it doesn't find.

@Elliott wrote:

no, I need to identify if the business name is only a single word, no matter how many characters. The user feels this may be an invalid name and wants to review the information. They feel a single name with no spaces is an invalid business name and should be flagged.

Thanks,