[stata命令求助] stata在面板数据中计算前三年国际并购经验和东道国并购经验

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

我的数据结构是acqcusip targetcusip dealnumber Yrannounced dateannounced acqnation targetnation：
1. acqcusip 收购公司代码
2. targetcusip被收购公司代码
3. dealnumber交易代码
4. Yrannounced收购年份
5. dateannounced 收购具体时间
6. acqnation收购方所在国家/地区代码
7. targetnation被收购方所在国家/地区代码
备注：每个acqcusip在同一年可能有多次收购。
我想要计算两个变量：
1、收购公司在发起每次收购之前的三年内的国际收购次数（acq prior 3 years' international acquisitions experience），但是这里的前三年国际收购要排除当时东道国的国家，国际收购也就是指除当次收购acqnation和targetnation之外的国际收购，这样是避免和下一个变量重复计算；
2、收购公司在每次收购之前的三年内的东道国收购次数（ac prior 3 years' host-country acquisition experience）
举例一下：00011X在2007年 81646E这次收购的 prior 3 years' international acquisitions experience=0（host country的国际并购不算，因为targetnation是NZ，所以以往2005和2006的NZ都不算），prior 3 years' host-country acquisition experience=3；00011X在2014年 1C8854的 prior 3 years' international acquisitions experience=2（2011有两次NZ收购），prior 3 years' host-country acquisition experience=0（2011、2012、2013都没有HK收购）
我也看了相关帖子，其中根据以往黄老师的rangestat (sum) crossboard, interval(year -3 -1) by(acqcusip)命令，但是这个命令包括了前三年内东道国所在国家的国际并购，其中crossboard是是否跨国并购（acqnation=targetnation，则为跨国并购），我没有放进去。求相关朋友指教！非常感谢！

1. * Example generated by -dataex-. For more info, type help dataex
   
2. clear
   
3. input str12 dealnumber str9(acqcusip targetcusip) str10 dateannounced int Yrannounced str6(acqnation targetnation)
   
4. "1348548040" "00008W" "00263H" "10/01/2002" 2002 "AU" "AU"
   
5. "1531438040" "00008W" "28382W" "06/01/2004" 2004 "AU" "AU"
   
6. "1705049040" "00008W" "67186L" "10/27/2005" 2005 "AU" "AU"
   
7. "1718617040" "00008W" "04537E" "12/09/2005" 2005 "AU" "AU"
   
8. "1717549040" "00008W" "00609R" "12/06/2005" 2005 "AU" "AU"
   
9. "1726593040" "00008W" "89267Z" "01/10/2006" 2006 "AU" "AU"
   
10. "1912635040" "00008W" "25559E" "10/08/2007" 2007 "AU" "AU"
    
11. "1912631040" "00008W" "78855W" "10/08/2007" 2007 "AU" "AU"
    
12. "1894440040" "00008W" "87021Z" "07/31/2007" 2007 "AU" "AU"
    
13. "1912621040" "00008W" "90642K" "10/08/2007" 2007 "AU" "AU"
    
14. "2532169040" "00008W" "4A5478" "06/24/2013" 2013 "AU" "AU"
    
15. "3493667040" "00008W" "9J2790" "11/22/19"   2019 "AU" "AU"
    
16. "3480562040" "00008W" "8J3265" "11/22/19"   2019 "AU" "AU"
    
17. "1335110020" "00009A" "46164W" "10/14/2002" 2002 "AU" "US"
    
18. "1350608040" "00009C" "36835E" "12/09/2002" 2002 "NT" "CT"
    
19. "1696179040" "00009T" "36061P" "09/22/2005" 2005 "JP" "JP"
    
20. "770037040"  "00009Z" "30281F" "04/21/1998" 1998 "AS" "IT"
    
21. "1888935040" "00010J" "85535Z" "07/17/2007" 2007 "TH" "TH"
    
22. "1953367040" "00010J" "85535Z" "02/18/2008" 2008 "TH" "TH"
    
23. "1321040040" "00010L" "92644Y" "06/19/2002" 2002 "FR" "FR"
    
24. "574898040"  "00010P" "89051E" "07/19/1995" 1995 "EA" "EA"
    
25. "1306015040" "00011R" "74083V" "01/23/2002" 2002 "UK" "UK"
    
26. "2258414040" "00011X" "54342E" "03/01/2005" 2005 "AU" "NZ"
    
27. "1799617040" "00011X" "31711X" "10/06/2006" 2006 "AU" "NZ"
    
28. "1743696040" "00011X" "86285Z" "03/15/2006" 2006 "AU" "NZ"
    
29. "1830804040" "00011X" "81646E" "01/17/2007" 2007 "AU" "NZ"
    
30. "1884842040" "00011X" "89044Z" "07/03/2007" 2007 "AU" "AU"
    
31. "1938101040" "00011X" "83124L" "12/20/2007" 2007 "AU" "NZ"
    
32. "2337902040" "00011X" "07360H" "08/18/2011" 2011 "AU" "NZ"
    
33. "2287077040" "00011X" "67671N" "03/05/2011" 2011 "AU" "NZ"
    
34. "2388325040" "00011X" "67235H" "11/08/2011" 2011 "AU" "AU"
    
35. "2426573040" "00011X" "10540K" "06/21/2012" 2012 "AU" "AU"
    
36. "2610863040" "00011X" "05291M" "02/19/2014" 2014 "AU" "AU"
    
37. "2709021040" "00011X" "4C9990" "12/22/2014" 2014 "AU" "AU"
    
38. "2657268040" "00011X" "1C8854" "07/18/2014" 2014 "AU" "HK"
    
39. "3024640040" "00011X" "2F0519" "10/24/2016" 2016 "AU" "AU"
    
40. end

复制代码

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：stata命令 Stata tata 国际并购 面板数据 stata命令 前三年求和