SAS function Index problem

[harrylui]

good day,

i am using function index for searching the keyword from my data but some error happen and here is the example

NAME

Liverpool

Liverpoollowolo

club Liverpool

data want;

data have;

if index(NAME,"Liverpool") then output;

run;

The final data will contain these three names but the second (Liverpoollowolo) is not the result i want. how can i fix this?

can i add space to the keyword like below?

if index(NAME," Liverpool ") then output;

but i am afraid that the first one will fail cause there is no space before the name Liverpool

what i am looking for is a separate "Liverpool" in my new data set

Regards,

Harry

[Kurt_Bremser · Accepted solution]

Use the INDEXW function if searching for words:

data want;
input name $50.;
if indexw(name,"Liverpool") then output;
datalines;
Liverpool
Liverpoollowolo
club Liverpool
;

[kelxxx]

hi

you can use indexw(), findw()

it would be better to use upcase or lowcase for case-insensitive

if indexw(upcase(NAME),"LIVERPOOL") then output; 
if findw(lowcase(NAME),"liverpool") then output;
if findw(NAME,"liverpool"," ",'i') then output;

have a good day