topic Character comparison using IF in SAS Programming

Character comparison using IF

MainframeSAS — Wed, 09 Sep 2015 22:11:49 GMT

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 — Wed, 09 Sep 2015 22:52:12 GMT

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 — Thu, 10 Sep 2015 02:14:31 GMT

Or...

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