用stata找出两列数据同一ID之间的相同值,ID不是唯一的

我想找出同一个数据表中两个变量同一iD之间相同的项，请问该如何做？
下面是例子：我想找出id为16的两个变量之间的共同值A和H;ID为20的两个变量的共同值M;ID为25的两个两个变量没有共同项。var1和var2实际上是股东名称，我想匹配共同股东。




附：

clear
input str3(id var1 var2)
"16" "A" "C"
"16" "B" "F"
"16" "H" "A"
"16" "D" "L"
"16" "N" "H"
"20" "M" "M"
"20" "F" "S"
"20" "D" "Q"
"20" "I" "L"
"25" "Q" "A"
"25" "M" "C"
"25" "F" "S"
"25" "D" "P"
"25" "I" "L"
end

1. forvalues i=1/2{
   
2. use cs,clear
   
3. keep id var`i'
   
4. ren var`i' var
   
5. save cs_`i',replace
   
6. }
   
7. 
   
8. merge 1:1 id var using cs_1
   
9. keep if _m==3
   
10. drop _m

复制代码

1. clear
   
2. input str3(id var1 var2)
   
3. "16" "A" "C"
   
4. "16" "B" "F"
   
5. "16" "H" "A"
   
6. "16" "D" "L"
   
7. "16" "N" "H"
   
8. "20" "M" "M"
   
9. "20" "F" "S"
   
10. "20" "D" "Q"
    
11. "20" "I" "L"
    
12. "25" "Q" "A"
    
13. "25" "M" "C"
    
14. "25" "F" "S"
    
15. "25" "D" "P"
    
16. "25" "I" "L"
    
17. end
    
18. save cs,replace

复制代码