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

[Tom]

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]

Thanks a lot.