topic Re: Is there a SAS function to determine a string ends with another string? in SAS Programming

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

jjjch — Tue, 13 Oct 2020 17:14:59 GMT

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.

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

novinosrin — Tue, 13 Oct 2020 17:22:13 GMT


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

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

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

Reeza — Tue, 13 Oct 2020 17:31:06 GMT

REVERSE() everything?

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

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

novinosrin — Tue, 13 Oct 2020 17:40:55 GMT


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;

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

jjjch — Tue, 13 Oct 2020 18:13:51 GMT

Thank you, @novinosrin

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

jjjch — Tue, 13 Oct 2020 18:15:17 GMT

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

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

FreelanceReinh — Tue, 13 Oct 2020 18:27:09 GMT

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

where aString like '%ABC';

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

Reeza — Tue, 13 Oct 2020 20:55:52 GMT

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