topic Extracting the string after the numeric values from a single variable in SAS Programming

Extracting the string after the numeric values from a single variable

kristindlcrz — Wed, 23 Sep 2020 03:42:01 GMT

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!

Re: Extracting the string after the numeric values from a single variable

kristindlcrz — Wed, 23 Sep 2020 04:03:37 GMT

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!

Re: Extracting the string after the numeric values from a single variable

hhinohar — Wed, 23 Sep 2020 04:21:55 GMT

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;

Re: Extracting the string after the numeric values from a single variable

kristindlcrz — Wed, 23 Sep 2020 04:23:44 GMT

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?

Re: Extracting the string after the numeric values from a single variable

hhinohar — Wed, 23 Sep 2020 04:27:25 GMT

Yes it does on my SAS Studio.

You're welcome to try.

Re: Extracting the string after the numeric values from a single variable

kristindlcrz — Wed, 23 Sep 2020 04:28:18 GMT

Thank you so much hhinohar!

Re: Extracting the string after the numeric values from a single variable

andreas_lds — Wed, 23 Sep 2020 04:50:17 GMT

Another solution without using a regular expression:

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