topic Re: Alternatives to Index(s1,s2) in SAS Procedures

Alternatives to Index(s1,s2)

JBerry — Tue, 10 Jun 2014 23:30:08 GMT

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

Re: Alternatives to Index(s1,s2)

Reeza — Tue, 10 Jun 2014 23:36:37 GMT

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.

Re: Alternatives to Index(s1,s2)

JBerry — Wed, 11 Jun 2014 00:20:27 GMT

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