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.
data have;
str='jojojoiABC';
output;
str='iknmmoabc';
output;
str='knhjknl';
output;
run;
data want;
set have;
if prxmatch('/.*abc$/i',strip(str));
run;
data have;
str='jojojoiABC';
output;
str='iknmmoabc';
output;
str='knhjknl';
output;
run;
data want;
set have;
if prxmatch('/.*abc$/i',strip(str));
run;
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;
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.