| [3] | litgov_est.dta | |||
|
ch10.1.do:6 |
[8] | litgov_estsample.dta | ||
| master.do:4 | ||||
| → | ch10.1.do | ↘ | ||
|
table2tex |
[53] | |||
|
litgov_estsample.dta |
[6] |
ch10.1.do:8 |
||
ch10.1.do open
file:script:do
| # | content |
|---|---|
| 1 [+] | * ITSP 10.1 - |
| 3 [+] | use "litgov_est.dta" , |
| 4 [+] | drop if !t56s |
| 5 [+] | matrix drop _all |
| 6 [+] | save litgov_estsample , |
| 8 [+] | use litgov_estsample.dta , |
| 9 [+] | tabstat insider , |
| 10 [+] | return list |
* N |
|
| 13 [+] | makematrix t2a, from(r(Stat1) r(Stat2)): tabstat insider , |
| 14 [+] | summarize insider , |
| 15 [+] | matrix temp = r(N) |
| 16 [+] | matrix t2a = t2a , |
* CEO |
|
| 19 [+] | makematrix t2aa, from(r(Stat1) r(Stat2)): tabstat ceo , |
| 20 [+] | mat t2aa[1,1] = . |
| 21 [+] | summarize ceo if insider , |
| 22 [+] | mat temp = r(N) |
| 23 [+] | mat t2aa = t2a \ (t2aa, temp) |
| 25 [+] | * Outcome, Involvement, Demographics * gen tenure = exp(entrench) |
| 28 [+] | foreach v of varlist audit defendant_ANY ins_trade_ANY departed age tenure stkholding { |
| 29 [+] | qui makematrix t2b, from(r(Stat1) r(Stat2)): tabstat `v' , |
| 30 [+] | summarize `v' , |
| 31 [+] | matrix `v'1 = r(N) |
| 32 [+] | qui ttest `v' , |
| 33 [+] | matrix `v'2 = r(p) |
| 34 [+] | qui ranksum `v' , |
| 35 [+] | matrix `v'3 = 1 - normprob(abs(r(z))) |
| 36 [+] | matrix `v' = t2b, `v'1, `v'2 , |
| 37 [+] | matrix t2bb = (nullmat(t2bb) \ `v') |
| 38 [+] | } |
| 40 [+] | matrix colnames t2aa = Outsider Insider Total |
| 41 [+] | matrix rownames t2aa = Observations CEO |
| 42 [+] | matrix list t2aa |
| 43 [+] | matrix colnames t2bb = Outsider Insider N t_pval MW_pval |
| 44 [+] | matrix list t2bb |
| 46 [+] | local inv Audit Defendant Ins\_Trading Departed Age Tenure Voting\_Share |
| 47 [+] | local inv1 "Member Audit Committee (0/1)" |
| 48 [+] | local inv2 "Defendant (0/1)" |
| 49 [+] | local inv5 "Age (Years)" |
| 50 [+] | local inv6 "Board Tenure (Years)" |
| 51 [+] | local inv7 "Voting Share (\%)" |
| 52 [+] | tempname hh |
| 53 [+] | file open `hh' using table2.tex , |
| 54 [+] | file write `hh' "\begin{table}[htbp]\caption{Director-level variables}\bigskip" _newline |
| 56 [+] | file write `hh' "\begin{tabular}{lrrrrr}" _newline "\hline" _newline |
| 57 [+] | file write `hh' " Variable & Outside & Inside & & \multicolumn{2}{c}{\$p\$-value of Difference} \\" _newline |
| 58 [+] | file write `hh' "& Directors & Directors & & \multicolumn{2}{c}{in Location} \\" _newline |
| 59 [+] | file write `hh' "\hline & Mean & Mean & \$N\$ & \$t\$ test & Mann--Whitney \\" _newline |
| 60 [+] | file write `hh' "\hline" _newline |
| 61 [+] | file write `hh' "Observations (\$N\$) & " (t2aa[1, 1]) " & " (t2aa[1, 2]) " & " (t2aa[1, 3]) " \\" _newline |
| 62 [+] | file write `hh' "\\{\sl Involvement} \\" _newline |
| 63 [+] | file write `hh' "CEO (0/1) & N/A & " %7.3f (t2aa[2, 2]) " & " (t2aa[2, 3]) " \\" _newline |
| 64 [+] | forv i = 1/2 { |
| 65 [+] | file write `hh' "`inv`i'' & " %7.3f (t2bb[`i', 1]) " & " %7.3f (t2bb[`i', 2]) " & " (t2bb[`i', 3]) " & " %7.3f (t2bb[`i', 4]) " & " %7.3f (t2bb[`i', 5]) " \\" _newline |
| 66 [+] | } |
| 67 [+] | file write `hh' "\\{\sl Outcome} \\" _newline |
| 68 [+] | local i 4 |
| 69 [+] | file write `hh' "Departed (0/1) & " %7.3f (t2bb[`i', 1]) " & " %7.3f (t2bb[`i', 2]) " & " (t2bb[`i', 3]) " & " %7.3f (t2bb[`i', 4]) " & " %7.3f (t2bb[`i', 5]) " \\" _newline |
| 70 [+] | file write `hh' "\\{\sl Demographics} \\" _newline |
| 71 [+] | forv i = 5/7 { |
| 72 [+] | file write `hh' "`inv`i'' & " %7.3f (t2bb[`i', 1]) " & " %7.3f (t2bb[`i', 2]) " & " (t2bb[`i', 3]) " & " %7.3f (t2bb[`i', 4]) " & " %7.3f (t2bb[`i', 5]) " \\" _newline |
| 73 [+] | } |
| 74 [+] | file write `hh' "\hline" _n "\end{tabular}" "\medskip" _newline |
| 75 [+] | file write `hh' "\end{table}" _newline |
| 76 [+] | file close `hh' |
* ITSP 10.1 -
use "litgov_est.dta", clear
drop if !t56s
matrix drop _all
save litgov_estsample, replace
use litgov_estsample.dta, clear
tabstat insider, by(insider) stat(N) save
return list
* N
makematrix t2a, from(r(Stat1) r(Stat2)): tabstat insider, by(insider) stat(N) save
summarize insider, mean
matrix temp = r(N)
matrix t2a = t2a, temp
* CEO
makematrix t2aa, from(r(Stat1) r(Stat2)): tabstat ceo, by(insider) stat(mean) save
mat t2aa[1,1] = .
summarize ceo if insider, mean
mat temp = r(N)
mat t2aa = t2a \ (t2aa, temp)
* Outcome, Involvement, Demographics
* gen tenure = exp(entrench)
foreach v of varlist audit defendant_ANY ins_trade_ANY departed age tenure stkholding {
qui makematrix t2b, from(r(Stat1) r(Stat2)): tabstat `v', by(insider) stat(mean) save
summarize `v', mean
matrix `v'1 = r(N)
qui ttest `v', by(insider)
matrix `v'2 = r(p)
qui ranksum `v', by(insider)
matrix `v'3 = 1 - normprob(abs(r(z)))
matrix `v' = t2b, `v'1, `v'2, `v'3
matrix t2bb = (nullmat(t2bb) \ `v')
}
matrix colnames t2aa = Outsider Insider Total
matrix rownames t2aa = Observations CEO
matrix list t2aa
matrix colnames t2bb = Outsider Insider N t_pval MW_pval
matrix list t2bb
local inv Audit Defendant Ins\_Trading Departed Age Tenure Voting\_Share
local inv1 "Member Audit Committee (0/1)"
local inv2 "Defendant (0/1)"
local inv5 "Age (Years)"
local inv6 "Board Tenure (Years)"
local inv7 "Voting Share (\%)"
tempname hh
file open `hh' using table2.tex, write replace
file write `hh' "\begin{table}[htbp]\caption{Director-level variables}\bigskip" _newline
file write `hh' "\begin{tabular}{lrrrrr}" _newline "\hline" _newline
file write `hh' " Variable & Outside & Inside & & \multicolumn{2}{c}{\$p\$-value of Difference} \\" _newline
file write `hh' "& Directors & Directors & & \multicolumn{2}{c}{in Location} \\" _newline
file write `hh' "\hline & Mean & Mean & \$N\$ & \$t\$ test & Mann--Whitney \\" _newline
file write `hh' "\hline" _newline
file write `hh' "Observations (\$N\$) & " (t2aa[1, 1]) " & " (t2aa[1, 2]) " & " (t2aa[1, 3]) " \\" _newline
file write `hh' "\\{\sl Involvement} \\" _newline
file write `hh' "CEO (0/1) & N/A & " %7.3f (t2aa[2, 2]) " & " (t2aa[2, 3]) " \\" _newline
forv i = 1/2 {
file write `hh' "`inv`i'' & " %7.3f (t2bb[`i', 1]) " & " %7.3f (t2bb[`i', 2]) " & " (t2bb[`i', 3]) " & " %7.3f (t2bb[`i', 4]) " & " %7.3f (t2bb[`i', 5]) " \\" _newline
}
file write `hh' "\\{\sl Outcome} \\" _newline
local i 4
file write `hh' "Departed (0/1) & " %7.3f (t2bb[`i', 1]) " & " %7.3f (t2bb[`i', 2]) " & " (t2bb[`i', 3]) " & " %7.3f (t2bb[`i', 4]) " & " %7.3f (t2bb[`i', 5]) " \\" _newline
file write `hh' "\\{\sl Demographics} \\" _newline
forv i = 5/7 {
file write `hh' "`inv`i'' & " %7.3f (t2bb[`i', 1]) " & " %7.3f (t2bb[`i', 2]) " & " (t2bb[`i', 3]) " & " %7.3f (t2bb[`i', 4]) " & " %7.3f (t2bb[`i', 5]) " \\" _newline
}
file write `hh' "\hline" _n "\end{tabular}" "\medskip" _newline
file write `hh' "\end{table}" _newline
file close `hh'