forked from burakbayramli/books
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathmids do.do
115 lines (98 loc) · 3.74 KB
/
mids do.do
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
clear
set more off
use "midparticipants.dta"
rename styear year
merge m:m year ccode using "power1.dta"
drop if dispnum3==.
gen ya=y if sidea==1
gen yb=y if sidea==0
gen gdpa=gdp if sidea==1
gen gdpb=gdp if sidea==0
gen cinca=cinc if sidea==1
gen cincb=cinc if sidea==0
gen state_a=stabb if sidea==1
gen state_b=stabb if sidea==0
collapse (firstnm) state_a (lastnm) state_b (sum) ya yb gdpa gdpb cinca cincb, by (dispnum3)
merge 1:1 dispnum3 using "mids.dta"
drop if ya==0 | yb==0 | gdpa==0 | gdpb==0
drop if outcome>4 | outcome==-9
gen yfrac=ya/(ya+yb)
gen cincfrac=cinca/(cinca+cincb)
gen gdpfrac=gdpa/(gdpa+gdpb)
gen y1=1 if yfrac>.5
replace y1=0 if yfrac<.5
gen gdp1=1 if gdpfrac>.5
replace gdp1=0 if gdpfrac<.5
gen cinc1=1 if cincfrac>.5
replace cinc1=0 if cincfrac<.5
gen win=1 if outcome==1 | outcome==4
replace win=0 if outcome==2 | outcome==3
list dispnum3 styear state_a state_b gdpfrac yfrac if win==1 & y1==1 & gdp1==0
list dispnum3 styear state_a state_b gdpfrac yfrac if win==0 & y1==0 & gdp1==1
list dispnum3 styear state_a state_b gdpfrac yfrac if win==1 & y1==0 & gdp1==1
list dispnum3 styear state_a state_b gdpfrac yfrac if win==0 & y1==1 & gdp1==0
list dispnum3 styear state_a state_b cincfrac yfrac if win==1 & y1==1 & cinc1==0
list dispnum3 styear state_a state_b cincfrac yfrac if win==0 & y1==0 & cinc1==1
list dispnum3 styear state_a state_b cincfrac yfrac if win==0 & y1==1 & cinc1==0
list dispnum3 styear state_a state_b cincfrac yfrac if win==1 & y1==0 & cinc1==1
gen ywl = 1 if win==1 & y1==1 | win==0 & y1==0
replace ywl=0 if win==1 & y1==0 | win==0 & y1==1
gen gdpwl = 1 if win==1 & gdp1==1 | win==0 & gdp1==0
replace gdpwl=0 if win==1 & gdp1==0 | win==0 & gdp1==1
gen cincwl = 1 if win==1 & cinc1==1 | win==0 & cinc1==0
replace cincwl=0 if win==1 & cinc1==0 | win==0 & cinc1==1
sum ywl
sum gdpwl
sum cincwl
*limit to bilateral mids
clear
set more off
use "midparticipants.dta"
sort dispnum3
gen ug=1
egen count=total(ug), by(dispnum3)
keep if count==2
rename styear year
merge m:m year ccode using "power1.dta"
drop if dispnum3==.
gen ya=y if sidea==1
gen yb=y if sidea==0
gen gdpa=gdp if sidea==1
gen gdpb=gdp if sidea==0
gen cinca=cinc if sidea==1
gen cincb=cinc if sidea==0
gen state_a=stabb if sidea==1
gen state_b=stabb if sidea==0
collapse (firstnm) state_a (lastnm) state_b count (sum) ya yb gdpa gdpb cinca cincb, by (dispnum3)
merge 1:1 dispnum3 using "mids.dta"
drop if ya==0 | yb==0 | gdpa==0 | gdpb==0
drop if outcome>4 | outcome==-9
drop if count==.
gen yfrac=ya/(ya+yb)
gen cincfrac=cinca/(cinca+cincb)
gen gdpfrac=gdpa/(gdpa+gdpb)
gen y1=1 if yfrac>.5
replace y1=0 if yfrac<.5
gen gdp1=1 if gdpfrac>.5
replace gdp1=0 if gdpfrac<.5
gen cinc1=1 if cincfrac>.5
replace cinc1=0 if cincfrac<.5
gen win=1 if outcome==1 | outcome==4
replace win=0 if outcome==2 | outcome==3
list dispnum3 styear state_a state_b gdpfrac yfrac if win==1 & y1==1 & gdp1==0
list dispnum3 styear state_a state_b gdpfrac yfrac if win==0 & y1==0 & gdp1==1
list dispnum3 styear state_a state_b gdpfrac yfrac if win==1 & y1==0 & gdp1==1
list dispnum3 styear state_a state_b gdpfrac yfrac if win==0 & y1==1 & gdp1==0
list dispnum3 styear state_a state_b cincfrac yfrac if win==1 & y1==1 & cinc1==0
list dispnum3 styear state_a state_b cincfrac yfrac if win==0 & y1==0 & cinc1==1
list dispnum3 styear state_a state_b cincfrac yfrac if win==0 & y1==1 & cinc1==0
list dispnum3 styear state_a state_b cincfrac yfrac if win==1 & y1==0 & cinc1==1
gen ywl = 1 if win==1 & y1==1 | win==0 & y1==0
replace ywl=0 if win==1 & y1==0 | win==0 & y1==1
gen gdpwl = 1 if win==1 & gdp1==1 | win==0 & gdp1==0
replace gdpwl=0 if win==1 & gdp1==0 | win==0 & gdp1==1
gen cincwl = 1 if win==1 & cinc1==1 | win==0 & cinc1==0
replace cincwl=0 if win==1 & cinc1==0 | win==0 & cinc1==1
sum ywl
sum gdpwl
sum cincwl