Extracting the string after the numeric values from a single variable

[kristindlcrz]

Hi,

So I need to extract the strings after a certain number of numerics. Although the problem is that the number of numerics is inconsistent. How do I get the string after the numbers?

For example, my data is the following:

1234567aaa@mail.com 

12345bbb@mail.com

123456789ccc@mail.com 

And I want my output to be:

aaa@mail.com 

bbb@mail.com 

ccc@mail.com 

Is this possible in SAS?

Thank you!

[kristindlcrz]

Also, the string could be like these:

12345ddd23@mail.com  

I want to be able to collect all of the characters after the numeric so the desired output would be:

ddd23@mail.com 

Thank you!

[hhinohar]

This is a quick sample.

data have;
	input email:$30.;
datalines;
1234567aaa@mail.com 
12345bbb@mail.com
123456789ccc@mail.com 
12345ddd23@mail.com  
;
run;

data want;
	set have;
	email_out=prxchange("s/(\d+)(\w+@\w+.\w+)/$2/i",-1,email);
run;

[kristindlcrz]

Will this also cover the emails that have numbers in them?

Such as if the data is 123aaa01@mail.com, the output will still be aaa01@mail.com?

[hhinohar]

Yes it does on my SAS Studio.

You're welcome to try.

[kristindlcrz]

Thank you so much hhinohar!

[andreas_lds]

Another solution without using a regular expression:

data want;
  set have;
  email_sub = substr(email, notdigit(email));
run;