topic Re: delete the row if last digit is 4 in New SAS User

delete the row if last digit is 4

Smitha9 — Mon, 09 Jan 2023 21:35:33 GMT

Hi,

I have a datset which has 5digit numbers that ends with 2 or 4. I want to delete the entire row if the last digit is 4.

example:

ID Sample

1 00012

2 00034

3 00032

4 00124

5 00432

I want to delete the row which has the last digit 4. In the above example, I want to delete 00034 and 00124.

Can I do this in SAS to remove if the 5th digit is 4.

thanks in advance.

Re: delete the row if last digit is 4

SASKiwi — Mon, 09 Jan 2023 21:44:05 GMT

If Sample is character then this should do it:

data Want;
  set Have;
  if substr(Sample,5,1) = '4' then delete;
run;

Re: delete the row if last digit is 4

sbxkoenk — Mon, 09 Jan 2023 22:20:33 GMT

Or like this :

data have;
input ID Sample $;
cards;
1        00012
2        00034
3        00032
4        00124
5        00432
;
run;

data want;
 set have;
 where reverse(strip(Sample)) NOT =: '4';
run;
/* end of program */

Koen

Re: delete the row if last digit is 4

PaigeMiller — Tue, 10 Jan 2023 11:28:25 GMT

If the variable in numeric, you would use the MOD function

if mod(sample,10)=4 then delete;