DATA Step, Macro, Functions and more

Character comparison using IF

Reply
New Contributor
Posts: 4

Character comparison using IF

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 !
Valued Guide
Posts: 765

Re: Character comparison using IF

Posted in reply to MainframeSAS

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

 

Respected Advisor
Posts: 4,919

Re: Character comparison using IF

Posted in reply to MainframeSAS

Or...

if substr(name, length(name), 1) = "M";
PG
Ask a Question
Discussion stats
  • 2 replies
  • 181 views
  • 0 likes
  • 3 in conversation