Hi Dishant, Here is a possible solution based on your data assuming that the order in both dataset is the same: data test; Input name $ surname $; datalines; ramesh Babu Dishant parikh Disha.N Khanna ;Run; data test1; Input name1 $ surname1 $; datalines; RamesH BABU DISHANT PARIKH disha Khanna ;Run; *length of variables name and surname based on your data and can be obtained from sashelp.vcolumn; %let nlen =8; %let slen =8; data compare(drop=i); merge test test1; length pos1 pos2 $32.; do i=1 to &nlen.; if char(name,i) ^= char(name1,i) then pos1 = catx(',', pos1,i); end; do i=1 to &slen.; if char(surname,i) ^= char(surname1,i) then pos2 = catx(',', pos2,i); end; run; BR
... View more