Hello SAS Community, My problem, I suspect, stems from user input. Each person is able to submit unlimited applications (records). Therefore, we receive data sets that are quite similar except for some variance that distorts the cleanup. Below is a sample dataset. We have used the SHA256 function to create the UniqID based on the Security field. But upon further review, other variables are strikingly similar. Sometimes the names are spelled differently, the security variable is missing data as well as the phone number. Other times we find that people put in the same number but have a different name and security variable. So my question is, how can I create a program that will look for all of these variances? Thank you. I appreciate any gentle nudge. Luis
... View more