topic Re: Index not finding string if there is a comma or dot etc after it in SAS Programming

Index not finding string if there is a comma or dot etc after it

SIgnificatif — Fri, 07 Jun 2019 12:18:03 GMT

Hi dear all.

I have a basic function and I can't find what i'm looking for...

the below code works:

data have;
re="all";
ro="hello";
ra=catx('',ro,re);
texto='blablabla hello all , people';
	if indexw(texto,ra)>0 then do;
	bi="wee";
	end;
	run;

and this one not ... ( because there is a comma after 'all' in texto:

data have;
re="all";
ro="hello";
ra=catx('',ro,re);
texto='blablabla hello all, people';
	if indexw(texto,ra)>0 then do;
	bi="wee";
	end;
	run;

how to fix that, to make the index or indexw find the word even if there is a comma, period etc after or before the searched word ( or series of words' like ro re... ?

Thanks for the response.

Sincerely.

Re: Index not finding string if there is a comma or dot etc after it

anushreebiotech — Fri, 07 Jun 2019 12:32:18 GMT

Hi,

You can use Trim function.

data have;
re="all";
ro="hello";
ra=catx('',ro,re);
texto='blablabla hello all, people';
if index(texto,(trim(ra)))>0 then do;
bi="wee";
end;
run;

Regards,

Anushree

Re: Index not finding string if there is a comma or dot etc after it

Riteshdell — Fri, 07 Jun 2019 12:39:29 GMT

In your second code of texto attribute of value, space is removed after "ALL".

Thats why you are not getting result.

as per First code, Space is there after ALL.

add space and then run.

Re: Index not finding string if there is a comma or dot etc after it

SIgnificatif — Fri, 07 Jun 2019 12:47:31 GMT

The mentioned solution is working, I've also used strip and it worked too...

thanx 🙂

Re: Index not finding string if there is a comma or dot etc after it

ballardw — Fri, 07 Jun 2019 15:57:48 GMT

INDEXW has an options parameter to contain delimiters. The default delimiter is blank.

Add additional delimiters as a string literal or variable containing desired delimiters after the search string.

Note that you do want to include a blank or that would stop being a delimiter.

if indexw(texto,ra, " ,.!?/()&%" )>0 then do