Is there a SAS function to determine a string ends with another string?

[jjjch]

We can use "=:" to determine whether aString starts with 'ABC' like below:

if aString=:'ABC';

But how to determine aString ends with 'ABC'? Is there an existing function or operator for that? Thanks.

[novinosrin · Accepted solution]

data have;
 str='jojojoiABC';
 output;
 str='iknmmoabc';
 output;
 str='knhjknl';
 output;
run;

data want;
 set have;
 if prxmatch('/.*abc$/i',strip(str));
run;

[jjjch]

Thank you, @novinosrin

[Reeza]

REVERSE() everything?

if reverse(aString) =: reverse(ABC)?

[jjjch]

Thank you, Reeza. Your solution also works. I just hope SAS can provide a string function or operator for endswith().

[Reeza]

Or if you know it's a design limitation, you can design your processes to be prefix heavy rather than suffix.

[novinosrin]

data have;
 str='jojojoiABC';
 output;
 str='iknmmoabc';
 output;
 str='knhjknl';
 output;
run;

data want;
 set have;
 if UPCASE(substr(strip(str),length(strip(str))-2))='ABC';
run;

[FreelanceReinh]

In a WHERE condition you could also use the LIKE operator:

where aString like '%ABC';