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:

[email protected] 

[email protected]

[email protected] 

And I want my output to be:

[email protected] 

[email protected] 

[email protected] 

Is this possible in SAS?

Thank you!

[kristindlcrz]

Also, the string could be like these:

[email protected]  

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

[email protected] 

Thank you!

[hhinohar]

This is a quick sample.

data have;
	input email:$30.;
datalines;
[email protected] 
[email protected]
[email protected] 
[email protected]  
;
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 [email protected], the output will still be [email protected]?

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