topic Re: compare a variable with the list and return the matching value in SAS Programming

compare a variable with the list and return the matching value

scorpionhks — Wed, 22 Sep 2021 03:17:34 GMT

for missing values in industry variable, I am looking to compare email_id which is partially anonymized (name is anonymized but industry remain same) with the list of distinct values of industry column to derive the industry name from email address and return the matching value for missing records. for example: in row 6, email id is GGYDNEE3@homeandgardenBAHG.co, i want to compare it with all distinct values of industry column (in this case matching value would be home and garden) and return that value for missing value in industry column, similarly row 15 should get 'nursery' and row 20 should get 'landscape designer' for missing values in industry column. what is the logic to use here ?

Re: compare a variable with the list and return the matching value

Reeza — Wed, 22 Sep 2021 03:40:25 GMT

If you treat your industry as the terms you're searching for, perhaps this may help.
https://gist.github.com/statgeek/2f733d27820f43fa37d6ba92c30f22cf

You may want to use a more fuzzy matching approach though...see this post for some ideas.
https://blogs.sas.com/content/sgf/2021/09/21/fuzzy-matching/

Re: compare a variable with the list and return the matching value

scorpionhks — Wed, 22 Sep 2021 03:52:48 GMT

thanks for quick response. the github link you sent seem to work to identify a matching value and return the flag=1. i would like to get the matching value returned to replace the missing value for industry column. how do i get the matching value from the array list ?

Re: compare a variable with the list and return the matching value

Reeza — Wed, 22 Sep 2021 14:34:15 GMT

if find(team, _search(i), 'it')>0 then flag=search(i);