多个条件生成虚拟变量变量，如果并购事件中的买方与标的位于同一个省份虚拟变量为1.

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

老师同学好，我下载了并购的数据，数据如下。希望生成一个地理位置虚拟变量，如果一个并购事件中的买方与标的位于同一个省份取值为1，应该怎么实现呢？EventID相同表示是同一个并购事件，officeprovince 是交易双方地位，officeprovince表示交易双方的位置信息。

感谢大家！！！

1. * Example generated by -dataex-. To install: ssc install dataex
   
2. clear
   
3. input EventID tradingpositionid officeprovince
   
4. 200000000896 3  .
   
5. 200000000900 3 25
   
6. 200000000903 3  5
   
7. 200000000927 3  .
   
8. 200000000945 3  .
   
9. 200000000953 3  .
   
10. 200000001030 3  .
    
11. 200000001037 3  .
    
12. 200000001064 3  .
    
13. 200000001097 3  .
    
14. 200000001124 3  .
    
15. 200000001130 3  .
    
16. 200000001173 3  .
    
17. 200000001188 3  .
    
18. 200000001190 1 24
    
19. 200000001190 3  .
    
20. 200000001221 3  .
    
21. 200000001222 3  .
    
22. 200000001258 3  .
    
23. 200000001268 3  .
    
24. 200000001319 3  .
    
25. 200000001325 3  .
    
26. 200000001328 3  .
    
27. 200000001328 1  5
    
28. 200000001375 3  .
    
29. 200000001379 3 33
    
30. 200000001413 3  6
    
31. 200000001417 3  .
    
32. 200000001424 3  .
    
33. 200000001425 3 24
    
34. 200000001426 3  .
    
35. 200000001435 3  .
    
36. 200000001436 3  .
    
37. 200000001437 3  .
    
38. 200000001438 3  .
    
39. 200000001439 3  .
    
40. 200000001440 3  .
    
41. 200000001448 3 30
    
42. 200000001458 3  .
    
43. 200000001512 1 24
    
44. 200000001512 3  .
    
45. 200000001523 3  .
    
46. 200000001529 3  .
    
47. 200000001572 3  .
    
48. 200000001572 1  .
    
49. 200000001597 3  .
    
50. 200000001640 3  .
    
51. 200000001656 1  .
    
52. 200000001656 3  .
    
53. 200000001660 3  .
    
54. 200000001664 3  5
    
55. 200000001671 3  .
    
56. 200000001672 3  .
    
57. 200000001687 1  .
    
58. 200000001687 3  .
    
59. 200000001706 3  .
    
60. 200000001710 1  .
    
61. 200000001710 3  .
    
62. 200000001769 3  .
    
63. 200000001788 3  3
    
64. 200000001790 3  .
    
65. 200000001791 3  .
    
66. 200000001794 3  .
    
67. 200000001799 3  .
    
68. 200000001806 3  2
    
69. 200000001807 3  .
    
70. 200000001813 3  .
    
71. 200000001814 3 19
    
72. 200000001815 3  .
    
73. 200000001825 3  .
    
74. 200000001834 3  .
    
75. 200000001837 3  .
    
76. 200000001842 3  2
    
77. 200000001889 3  .
    
78. 200000001895 3  9
    
79. 200000001908 1  .
    
80. 200000001908 3  2
    
81. 200000001909 3  .
    
82. 200000001969 3  .
    
83. 200000001973 3  .
    
84. 200000001976 3 24
    
85. 200000001977 1 32
    
86. 200000001977 3 24
    
87. 200000001987 3  .
    
88. 200000002008 3  .
    
89. 200000002008 3  .
    
90. 200000002008 3  .
    
91. 200000002008 3  .
    
92. 200000002008 3  .
    
93. 200000002008 3  .
    
94. 200000002008 3  .
    
95. 200000002017 3 10
    
96. 200000002021 3 32
    
97. 200000002022 3 32
    
98. 200000002029 3 27
    
99. 200000002061 3 22
    
100. 200000002063 3  .
     
101. 200000002064 3  2
     
102. 200000002079 3 24
     
103. 200000002079 1 24
     
104. end

复制代码

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

关键词：000001 000020 000002 000014 000018

看不懂关系！请详细说明。