topic Re: delete the last digit in New SAS User

delete the last digit

Smitha9 — Fri, 03 Jul 2020 20:54:17 GMT

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

Re: delete the last digit

Reeza — Fri, 03 Jul 2020 21:03:35 GMT

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'

Re: delete the last digit

Shmuel — Fri, 03 Jul 2020 21:05:07 GMT

data want;

set have;

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

run;

Re: delete the last digit

Smitha9 — Fri, 03 Jul 2020 21:08:48 GMT

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

Re: delete the last digit

Tom — Fri, 03 Jul 2020 21:16:15 GMT

@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;

Re: delete the last digit

ed_sas_member — Sat, 04 Jul 2020 08:10:11 GMT

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,