Character comparison using IF

[MainframeSAS]

Good evening !

I'm trying to create a filter to select records that has M on the last position.

This fields has strings up to 8 characters long.

By using    IF MY_FIELD =: 'M'

this would retrieve all records that start with M. How can i restrict the filter to the last character?

any help is welcome ! thanks !

[MikeZdeb]

Hi, you could try ...

data x;
input name :$10 @@;
datalines;
KAREEM MARK LIAM MICHAEL
;

data last_m;
set x;
if left(reverse(name)) =: "M";
run;

data set LAST_M

Obs name

1 KAREEM
2 LIAM

[PGStats]

Or...

if substr(name, length(name), 1) = "M";