topic Re: finding words in sas in SAS Programming

finding words in sas

sasprogramming — Wed, 09 Jun 2021 07:15:06 GMT

I am using the following code to find the word DI. The code below returns true when it looks at "CREDIT". However I want it to return false, DI is in CREDIT, but I only want cases true when DI is a word. How do i achieve this?

if findw(field_to_search_from, 'DI') ge 1 then flag= 1;

Re: finding words in sas

jimbarbour — Wed, 09 Jun 2021 02:49:24 GMT

I would use the FIND or FINDW functions to identify distinct words.

For example:

DATA	_NULL_;
					*----+----1----+----2----+----3----+----4----+----5-;
	String		=	'In Army boot camp, the DI is in charge.';

	Position	=	FINDW(String, 'DI');

	PUTLOG  "The position is " Position 2.;
RUN;

Yields:

The position is 24

Jim

Re: finding words in sas

andreas_lds — Wed, 09 Jun 2021 05:09:19 GMT

Please post the code you have including data in usable form (data step with datalines, no attachments).

Using findw is the right choice.

Re: finding words in sas

Josie1 — Wed, 09 Jun 2021 06:43:04 GMT

try putting a space before and after like ' DI '

Re: finding words in sas

sasprogramming — Wed, 09 Jun 2021 07:17:04 GMT

But if CREDIT is the first word in the field_to_search_from then it wont have a space before it?

Re: finding words in sas

Josie1 — Wed, 09 Jun 2021 07:20:44 GMT

not unless you write CRE DI T

Re: finding words in sas

andreas_lds — Wed, 09 Jun 2021 10:11:15 GMT

@Josie1 wrote:

try putting a space before and after like ' DI '

Not necessary if findw is used.