Hi Ksharp,
Thank you so much for the advance codes!
after I run into my real data, I have a little question to make it perfect.
When I run using your codes, the ones that have two Match1-- see ID12, code1=A_A, the result should be "0" instead of Blank.
otherwise all are looks good.
But if ID12, code1 = F_F for example, then the result should be "Blank or missing", because F is not Matching with Match1 and Match2. Does it make sense?
could you help to fix the code?
Thanks again for your time.
this is what I want.
ID
code1
Result1
code2
Result2
code3
Result3
code4
Result4
11
A_B
1
C_D
1
A_C
1
B_D
1
12
A_A
0
D_D
0
A_A
2
B_B
2
14
B_B
2
C_C
2
C_C
0
D_D
0
... View more