topic Re: remove last one digit and first two digits from a number in New SAS User

remove last one digit and first two digits from a number

Smitha9 — Wed, 29 Jul 2020 13:37:42 GMT

Hi,

I have a dataset

2000032

2000072

2000092

I want the dataset:

0003

0007

0009

I want to remove first 2digits and last one digit.

Can anyone help in this. thank you

Re: remove last one digit and first two digits from a number

PaigeMiller — Wed, 29 Jul 2020 13:40:40 GMT

It's hard to generalize from such a small example. Are there always two digits at the start and always one digit at the end? Are the strings always 7 characters? It seems as if all you want is characters 3 4 5 and 6, so this code will work:

new_id=substr(id,3,4);

Re: remove last one digit and first two digits from a number

Ksharp — Thu, 30 Jul 2020 12:43:34 GMT

data have;
input ID $;
want=prxchange('s/^\d\d|\d\s*$//',-1,id);
cards;
2000032
2000072
2000092
;

Re: remove last one digit and first two digits from a number

Kurt_Bremser — Thu, 30 Jul 2020 12:56:07 GMT

data have;
input ID $;
datalines;
2000032
2000072
2000092
;

data want;
set have;
id = substr(id,3,4);
run;

This code might nicely illustrate that your question suffers from a Maxim 42 issue.