Hi All:
First of all- THANK YOU for speaking up! All of this info is helpful in pointing me in the right direction. It also helps to know that what I am trying to accomplish is a big job. I can't tell you how much it helps to be validated around my concerns.
I can see that there are many ways to skin this cat (sorry for the grotesque pun...but it's a grotesque job!)...and figuring out the appropriate method is going to be a task in it of itself.
I've reached out to some collegues for assistance- turns out that we have a process in place for validating emails; I will be meeting with the gentleman who has established this process. I hope to share the information you all have provided me to see how his methodology compares. I'd like to use coding from you-all and him...and build it right into my workflow. I will let you know what his response and method is.
Thanks again- and my apologies if I have previously offended anyone; like I had mentioned before, sometimes finding help on forums can be challenging due to communication barriers and egos. 😛
-Tessa
Thought it is worth mentioning that SAS's Dataflux product contains functionality for cleaning email addresses along with cleaning all sorts of other data besides. This interesting paper explains more:
http://support.sas.com/resources/papers/proceedings15/SAS1852-2015.pdf
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.