delete the last digit

[Smitha9]

I have a data.

ID   number

1    10022

2    12332

3    12334

4    13452

5    13454

I want to delete the ID which has "number" with last digit which has "4"

I want,

1  10022

2 12332

3 13452

thank you

[Reeza]

Is it a numeric or character variable?
Assuming character...but if it's numeric use SUBSTRN instead of SUBSTR.

where substr(number, length(number)-1) ne '4'

[Smitha9]

It is a character, the "number" if its ends with "4" I want to delete the whole row. thanks

[Tom · Accepted solution]

---

@Smitha9 wrote:
It is a character, the "number" if its ends with "4" I want to delete the whole row. thanks

---

if char(number,length(number))='4' then delete;

[Shmuel]

data want;

set have;

     if substr(put(number,z5.),5,1) = '4' then delete;

run;

[ed_sas_member]

Hi @Smitha9 

Here is another approach using pearl regular expressions:

data want;
	set have;
	if prxmatch('/4\s*$/',number) then delete;
run;

The PRXMATCH() function looks for the pattern 4 followed by 0, 1 or more blanks (\s*) at the end of the string ($) in the variable 'number'.

Best,