finding words in sas

[sasprogramming]

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;

[jimbarbour]

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

[andreas_lds]

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

Using findw is the right choice.

[Josie1]

try putting a space before and after like ' DI '

[sasprogramming]

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

[Josie1]

not unless you write CRE DI T

[andreas_lds]

---

@Josie1 wrote:

try putting a space before and after like ' DI '

---

Not necessary if findw is used.