-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathcheck_not_raised_internally.do
52 lines (32 loc) · 1.74 KB
/
check_not_raised_internally.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
/*
Fixing/Double checking wb_raised_issue_internally == "NO" or ""
*/
cap cd "C:\Users\lmostrom\Dropbox\Violation paper\whistleblower paper\"
include wb_data_clean.do
keep if inlist(wb_raised_issue_internally, "NO", "") & internal == 1
sort caption
keep case_id caption wb_full_name job_title_at_fraud_firm wb_raised_issue_internally ///
audit billing colleague direct_supervisor gov hotline hr legalcompliance relevantdirector topmanager ///
response_* retaliation_*
export excel "employee_wbs_not_raised_internally.xls", first(variables)
*================================================================================
include wb_data_clean.do
keep if wb_raised_issue_internally == "YES" & internal == 1
sort caption
keep case_id caption wb_full_name job_title_at_fraud_firm wb_raised_issue_internally ///
audit billing colleague direct_supervisor gov hotline hr legalcompliance relevantdirector topmanager ///
response_* retaliation_*
export excel "employee_wbs_raised_internally.xls", first(variables)
*================================================================================
include wb_data_clean.do
keep if internal == 1
keep if gvkey != .
*gen fyear = year(received_date)
*merge m:1 gvkey fyear using "../../Compustat.dta", nogen keep(3) keepus(sic)
replace conm = "EXXON CORP" if gvkey == 4503
replace conm = "AMERIGROUP CORP" if gvkey == 145367
gsort -wb_raised_issue_internally -mgmt_class wb_full_name
br wb_full_name conm mgmt_class wb_raised_issue_internally
export excel wb_full_name conm mgmt_class received_date ///
wb_start_year_at_firm1 wb_end_year_at_firm1 wb_raised_issue_internally ///
using "employee_wbs_from_public_firms-for_linkedin.xls", first(variables) replace