Alternatives to Index(s1,s2)

[JBerry]

I'm having problems using INDEX() function ... 

I have a string variable which is a space separated list,

s = AGE WEIGHT GENDER HEIGHT

When I query a dataset like this:

proc sql;

  select variablename

  from MYDATASET

  where index("%upcase(%sysfunc(compbl(&s)))", compress(upcase(variablename), ' ')) > 0; quit;run;

I end up getting results like this:

WEIGHT

MAX_WEIGHT

MIN_WEIGHT

ANYTHING_WITH_WEIGHT_IN_IT

I'm looking for a perfect match by word - not pattern. I was thinking of appending a space to either end of the search pattern, but I'm not sure if that's the most elegant

[Reeza · Accepted solution]

IndexW - index word function

Also, you can use the upcase/upper and compbl function directly, you don't need % or sysfunc as far as I can see.

[JBerry]

Many thanks! That's exactly what I was looking for.