hi how I can remove all characters prior to %40 from email addresses

Agha — Fri, 07 Mar 2025 14:59:14 GMT

Re: hi how I can remove all characters prior to %40 from email addresses

Tom — Fri, 07 Mar 2025 15:04:57 GMT

It usually helps if you actually include a description of your question in the body of your post.

For example:

what is the name of the variable that has the email address
Can you show some example values you have and what you want to get from them?
I assume by %40 you actual just mean the @ character that separates the username (mailbox name) from the server name?

If you just have one address in the string then I would suggest using SCAN() function.

data want;
  set have;
  hostname = scan(email,2,'@');
run;

Agha — Sat, 08 Mar 2025 18:45:59 GMT

Thanks a lot.