Hello France, This the final code what i used to do the matching. Just do the necessary changes.It worked for me. Hope it helps. Regard EJAA. data s1; set s1; format Cleaned_exec_fullname $255.; /*Name*/ Cleaned_exec_fullname = scan(exec_fullname, 1,'()'); Cleaned_exec_fullname = upcase(Cleaned_exec_fullname); Cleaned_exec_fullname = compress(Cleaned_exec_fullname,",,.,/,*,',",""); Cleaned_exec_fullname = compress(Cleaned_exec_fullname,""""); Cleaned_exec_fullname = strip(Cleaned_exec_fullname); Cleaned_exec_fullname = compbl(Cleaned_exec_fullname); run; data s2; set s2; format Cleaned_directorname $255.; /* Name*/ Cleaned_directorname = scan(directorname, 1,'()'); Cleaned_directorname = upcase(Cleaned_directorname); Cleaned_directorname = compress(Cleaned_directorname,",,.,/,*,',",""); Cleaned_directorname = compress(Cleaned_directorname,""""); Cleaned_directorname = strip(Cleaned_directorname); Cleaned_directorname = compbl(Cleaned_directorname); run; proc sql noprint; **Selecting exact matches; create table Exact_matches_Comp as select s1.exec_fullname as Original_Exec_Name, s1.Cleaned_exec_fullname as Cleaned_Exec_Name, s2.directorname as Original_Director_Name, s2.Cleaned_directorname as Cleaned_Director_Name, s2.degree from s1 inner join s2 on s1.Cleaned_exec_fullname = s2.Cleaned_directorname where s1.Cleaned_exec_fullname is not null; quit; proc sort data=Exact_matches_Comp nodupkey; by Cleaned_Director_Name degree; run;
... View more