| 1 |
* this sctipt is borrowed from Brodeur et al. (2020) and executes some variable manipulation, labels variables and drops variables not needed any more
|
| 2 |
|
▼ | 3 |
clear all
|
▼ | 4 |
set more off
|
| 5 |
|
| 6 |
* specify directories where data are located and where results should be stored
|
▼ | 7 |
global dir_main : pwd
. global dir_main : pwd
.
|
▼ | 8 |
global dir_data "$dir_main/Data"
global dir_data "/home/rstudio/repbox/projects_ejd/aer_112_9_9/mod/Scripts/Data"
. global dir_data "$dir_main/Data"
.
|
▼ | 9 |
global dir_results "$dir_main/Results"
global dir_results "/home/rstudio/repbox/projects_ejd/aer_112_9_9/mod/Scripts/Results"
. global dir_results "$dir_main/Results"
.
|
| 10 |
|
| 11 |
|
▼ | 12 |
cd "$dir_data"
cd "/home/rstudio/repbox/projects_ejd/aer_112_9_9/mod/Scripts/Data"
. cd "${repbox_path}/Data"
/home/rstudio/repbox/projects_ejd/aer_112_9_9/mod/Data
.
|
| 13 |
* read in the data
|
▼ | 14 |
use "MM Data.dta" , clear
. use "MM Data.dta" , clear
.
|
| 15 |
|
| 16 |
* journals
|
▼ | 17 |
rename journal journal_name
. rename journal journal_name
.
|
▼ | 18 |
gen journal=.
. gen journal=.
(21,740 missing values generated)
.
|
▼ | 19 |
replace journal=1 if journal_name=="Quarterly Journal of Economics"
replace journal=1 if journal_name=="Quarterly Journal of Economics"
. replace journal=1 if journal_name=="Quarterly Journal of E
> conomics"
(840 real changes made)
.
|
▼ | 20 |
replace journal=3 if journal_name=="Journal of Political Economy"
replace journal=3 if journal_name=="Journal of Political Economy"
. replace journal=3 if journal_name=="Journal of Political E
> conomy"
(761 real changes made)
.
|
▼ | 21 |
replace journal=4 if journal_name=="Econometrica"
. replace journal=4 if journal_name=="Econometrica"
(307 real changes made)
.
|
▼ | 22 |
replace journal=5 if journal_name=="Journal of Finance" // old one, has no effect
. replace journal=5 if journal_name=="Journal of Finance"
(1,135 real changes made)
.
|
▼ | 23 |
replace journal=5 if journal_name=="Journal of Finance"
. replace journal=5 if journal_name=="Journal of Finance"
(0 real changes made)
.
|
▼ | 24 |
replace journal=6 if journal_name=="Review of Economic Studies" // old one, has no effect
replace journal=6 if journal_name=="Review of Economic Studies"
. replace journal=6 if journal_name=="Review of Economic Stu
> dies"
(306 real changes made)
.
|
▼ | 25 |
replace journal=6 if journal_name=="Review of Economic Studies"
replace journal=6 if journal_name=="Review of Economic Studies"
. replace journal=6 if journal_name=="Review of Economic Stu
> dies"
(0 real changes made)
.
|
▼ | 26 |
replace journal=7 if journal_name=="AEJ: Macroeconomics" // old
. replace journal=7 if journal_name=="AEJ: Macroeconomics"
(54 real changes made)
.
|
▼ | 27 |
replace journal=7 if journal_name=="American Economic Journal: Macroeconomics"
replace journal=7 if journal_name=="American Economic Journal: Macroeconomics"
. replace journal=7 if journal_name=="American Economic Jour
> nal: Macroeconomics"
(0 real changes made)
.
|
▼ | 28 |
replace journal=8 if journal_name=="Journal of Economic Growth"
replace journal=8 if journal_name=="Journal of Economic Growth"
. replace journal=8 if journal_name=="Journal of Economic Gr
> owth"
(100 real changes made)
.
|
▼ | 29 |
replace journal=9 if journal_name=="Review of Economics and Statistics"
replace journal=9 if journal_name=="Review of Economics and Statistics"
. replace journal=9 if journal_name=="Review of Economics an
> d Statistics"
(1,484 real changes made)
.
|
▼ | 30 |
replace journal=11 if journal_name=="American Economic Review"
replace journal=11 if journal_name=="American Economic Review"
. replace journal=11 if journal_name=="American Economic Rev
> iew"
(1,740 real changes made)
.
|
▼ | 31 |
replace journal=12 if journal_name=="Economic Policy"
. replace journal=12 if journal_name=="Economic Policy"
(80 real changes made)
.
|
▼ | 32 |
replace journal=15 if journal_name=="AEJ: Applied Economics" // OLD
replace journal=15 if journal_name=="AEJ: Applied Economics"
. replace journal=15 if journal_name=="AEJ: Applied Economic
> s"
(2,242 real changes made)
.
|
▼ | 33 |
replace journal=15 if journal_name=="American Economic Journal: Applied Economics"
replace journal=15 if journal_name=="American Economic Journal: Applied Economics"
. replace journal=15 if journal_name=="American Economic Jou
> rnal: Applied Economics"
(0 real changes made)
.
|
▼ | 34 |
replace journal=16 if journal_name=="Journal of the European Economic Association"
replace journal=16 if journal_name=="Journal of the European Economic Association"
. replace journal=16 if journal_name=="Journal of the Europe
> an Economic Association"
(491 real changes made)
.
|
▼ | 35 |
replace journal=17 if journal_name=="Review of Financial Studies"
replace journal=17 if journal_name=="Review of Financial Studies"
. replace journal=17 if journal_name=="Review of Financial S
> tudies"
(963 real changes made)
.
|
▼ | 36 |
replace journal=18 if journal_name=="Journal of International Economics"
replace journal=18 if journal_name=="Journal of International Economics"
. replace journal=18 if journal_name=="Journal of Internatio
> nal Economics"
(510 real changes made)
.
|
▼ | 37 |
replace journal=19 if journal_name=="Economic Journal" // OLD
. replace journal=19 if journal_name=="Economic Journal"
(891 real changes made)
.
|
▼ | 38 |
replace journal=19 if journal_name=="Economic Journal"
. replace journal=19 if journal_name=="Economic Journal"
(0 real changes made)
.
|
▼ | 39 |
replace journal=20 if journal_name=="Review of Financial Economics" // OLD
replace journal=20 if journal_name=="Review of Financial Economics"
. replace journal=20 if journal_name=="Review of Financial E
> conomics"
(0 real changes made)
.
|
▼ | 40 |
replace journal=20 if journal_name=="Journal of Financial Economics"
replace journal=20 if journal_name=="Journal of Financial Economics"
. replace journal=20 if journal_name=="Journal of Financial
> Economics"
(635 real changes made)
.
|
▼ | 41 |
replace journal=21 if journal_name=="Experimental Economics"
replace journal=21 if journal_name=="Experimental Economics"
. replace journal=21 if journal_name=="Experimental Economic
> s"
(79 real changes made)
.
|
▼ | 42 |
replace journal=22 if journal_name=="Journal of Development Economics"
replace journal=22 if journal_name=="Journal of Development Economics"
. replace journal=22 if journal_name=="Journal of Developmen
> t Economics"
(2,818 real changes made)
.
|
▼ | 43 |
replace journal=23 if journal_name=="Journal of Labor Economics"
replace journal=23 if journal_name=="Journal of Labor Economics"
. replace journal=23 if journal_name=="Journal of Labor Econ
> omics"
(653 real changes made)
.
|
▼ | 44 |
replace journal=24 if journal_name=="Journal of Financial Intermediation"
replace journal=24 if journal_name=="Journal of Financial Intermediation"
. replace journal=24 if journal_name=="Journal of Financial
> Intermediation"
(285 real changes made)
.
|
▼ | 45 |
replace journal=25 if journal_name=="Journal of Applied Econometrics"
replace journal=25 if journal_name=="Journal of Applied Econometrics"
. replace journal=25 if journal_name=="Journal of Applied Ec
> onometrics"
(86 real changes made)
.
|
▼ | 46 |
replace journal=26 if journal_name=="Journal of Human Resources"
replace journal=26 if journal_name=="Journal of Human Resources"
. replace journal=26 if journal_name=="Journal of Human Reso
> urces"
(752 real changes made)
.
|
▼ | 47 |
replace journal=27 if journal_name=="AEJ: Economic Policy" // OLD
. replace journal=27 if journal_name=="AEJ: Economic Policy"
>
(1,263 real changes made)
.
|
▼ | 48 |
replace journal=27 if journal_name=="American Economic Journal: Economic Policy"
replace journal=27 if journal_name=="American Economic Journal: Economic Policy"
. replace journal=27 if journal_name=="American Economic Jou
> rnal: Economic Policy"
(0 real changes made)
.
|
▼ | 49 |
replace journal=31 if journal_name=="Journal of Urban Economics"
replace journal=31 if journal_name=="Journal of Urban Economics"
. replace journal=31 if journal_name=="Journal of Urban Econ
> omics"
(660 real changes made)
.
|
▼ | 50 |
replace journal=32 if journal_name=="Journal of Public Economics"
replace journal=32 if journal_name=="Journal of Public Economics"
. replace journal=32 if journal_name=="Journal of Public Eco
> nomics"
(2,605 real changes made)
.
|
| 51 |
|
▼ | 52 |
gen top5=0 if journal!=.
. gen top5=0 if journal!=.
.
|
▼ | 53 |
replace top5=1 if journal==1
. replace top5=1 if journal==1
(840 real changes made)
.
|
▼ | 54 |
replace top5=1 if journal==3
. replace top5=1 if journal==3
(761 real changes made)
.
|
▼ | 55 |
replace top5=1 if journal==4
. replace top5=1 if journal==4
(307 real changes made)
.
|
▼ | 56 |
replace top5=1 if journal==6
. replace top5=1 if journal==6
(306 real changes made)
.
|
▼ | 57 |
replace top5=1 if journal==11
. replace top5=1 if journal==11
(1,740 real changes made)
.
|
| 58 |
|
▼ | 59 |
gen FINANCE=0 if journal!=.
. gen FINANCE=0 if journal!=.
.
|
▼ | 60 |
replace FINANCE=1 if journal==5
. replace FINANCE=1 if journal==5
(1,135 real changes made)
.
|
▼ | 61 |
replace FINANCE=1 if journal==17
. replace FINANCE=1 if journal==17
(963 real changes made)
.
|
▼ | 62 |
replace FINANCE=1 if journal==20
. replace FINANCE=1 if journal==20
(635 real changes made)
.
|
▼ | 63 |
replace FINANCE=1 if journal==24
. replace FINANCE=1 if journal==24
(285 real changes made)
.
|
| 64 |
|
▼ | 65 |
gen MACRO_GROWTH=0 if journal!=.
. gen MACRO_GROWTH=0 if journal!=.
.
|
▼ | 66 |
replace MACRO_GROWTH=1 if journal==7
. replace MACRO_GROWTH=1 if journal==7
(54 real changes made)
.
|
▼ | 67 |
replace MACRO_GROWTH=1 if journal==8
. replace MACRO_GROWTH=1 if journal==8
(100 real changes made)
.
|
| 68 |
|
▼ | 69 |
gen GEN_INT=0 if journal!=.
. gen GEN_INT=0 if journal!=.
.
|
▼ | 70 |
replace GEN_INT=1 if journal==9
. replace GEN_INT=1 if journal==9
(1,484 real changes made)
.
|
▼ | 71 |
replace GEN_INT=1 if journal==12
. replace GEN_INT=1 if journal==12
(80 real changes made)
.
|
▼ | 72 |
replace GEN_INT=1 if journal==14
. replace GEN_INT=1 if journal==14
(0 real changes made)
.
|
▼ | 73 |
replace GEN_INT=1 if journal==15
. replace GEN_INT=1 if journal==15
(2,242 real changes made)
.
|
▼ | 74 |
replace GEN_INT=1 if journal==16
. replace GEN_INT=1 if journal==16
(491 real changes made)
.
|
▼ | 75 |
replace GEN_INT=1 if journal==19
. replace GEN_INT=1 if journal==19
(891 real changes made)
.
|
▼ | 76 |
replace GEN_INT=1 if journal==25
. replace GEN_INT=1 if journal==25
(86 real changes made)
.
|
▼ | 77 |
replace GEN_INT=1 if journal==26
. replace GEN_INT=1 if journal==26
(752 real changes made)
.
|
| 78 |
|
▼ | 79 |
gen EXP=0 if journal!=.
. gen EXP=0 if journal!=.
.
|
▼ | 80 |
replace EXP=1 if journal==21
. replace EXP=1 if journal==21
(79 real changes made)
.
|
| 81 |
|
▼ | 82 |
gen DEV=0 if journal!=.
. gen DEV=0 if journal!=.
.
|
▼ | 83 |
replace DEV=1 if journal==22
. replace DEV=1 if journal==22
(2,818 real changes made)
.
|
| 84 |
|
▼ | 85 |
gen LABOR=0 if journal!=.
. gen LABOR=0 if journal!=.
.
|
▼ | 86 |
replace LABOR=1 if journal==23
. replace LABOR=1 if journal==23
(653 real changes made)
.
|
| 87 |
|
▼ | 88 |
gen PUB=0 if journal!=.
. gen PUB=0 if journal!=.
.
|
▼ | 89 |
replace PUB=1 if journal==27
. replace PUB=1 if journal==27
(1,263 real changes made)
.
|
▼ | 90 |
replace PUB=1 if journal==32
. replace PUB=1 if journal==32
(2,605 real changes made)
.
|
| 91 |
|
▼ | 92 |
gen URB=0 if journal!=.
. gen URB=0 if journal!=.
.
|
▼ | 93 |
replace URB=1 if journal==31
. replace URB=1 if journal==31
(660 real changes made)
.
|
| 94 |
|
| 95 |
* how reported
|
▼ | 96 |
gen p_value=1 if report=="p"
. gen p_value=1 if report=="p"
(20,726 missing values generated)
.
|
▼ | 97 |
gen z_stat=1 if report=="s"
. gen z_stat=1 if report=="s"
(2,009 missing values generated)
.
|
▼ | 98 |
gen t_stat=1 if report=="t"
. gen t_stat=1 if report=="t"
(20,768 missing values generated)
.
|
| 99 |
|
▼ | 100 |
replace p_value=0 if report=="s"
. replace p_value=0 if report=="s"
(19,731 real changes made)
.
|
▼ | 101 |
replace p_value=0 if report=="t"
. replace p_value=0 if report=="t"
(972 real changes made)
.
|
▼ | 102 |
replace z_stat=0 if report=="p"
. replace z_stat=0 if report=="p"
(1,014 real changes made)
.
|
▼ | 103 |
replace z_stat=0 if report=="t"
. replace z_stat=0 if report=="t"
(972 real changes made)
.
|
▼ | 104 |
replace t_stat=0 if report=="p"
. replace t_stat=0 if report=="p"
(1,014 real changes made)
.
|
▼ | 105 |
replace t_stat=0 if report=="s"
. replace t_stat=0 if report=="s"
(19,731 real changes made)
.
|
| 106 |
|
▼ | 107 |
encode report, gen(ireport)
. encode report, gen(ireport)
.
|
| 108 |
|
| 109 |
* unique identifiers
|
▼ | 110 |
capture egen unique_j = group(journal)
. capture egen unique_j = group(journal)
.
|
▼ | 111 |
capture egen unique_ja = group(journal article)
. capture egen unique_ja = group(journal article)
.
|
▼ | 112 |
capture egen unique_jat = group(journal article table)
. capture egen unique_jat = group(journal article table)
.
|
| 113 |
|
| 114 |
* weights
|
▼ | 115 |
gen journal_cluster=journal*10000
. gen journal_cluster=journal*10000
.
|
| 116 |
|
▼ | 117 |
egen journal_article_cluster=concat(journal_cluster article)
egen journal_article_cluster=concat(journal_cluster article)
. egen journal_article_cluster=concat(journal_cluster articl
> e)
.
|
▼ | 118 |
destring journal_article_cluster, replace
. destring journal_article_cluster, replace
journal_article_cluster: all characters numeric; replaced as long
.
|
| 119 |
|
▼ | 120 |
egen journal_article=concat(journal article)
. egen journal_article=concat(journal article)
.
|
▼ | 121 |
destring journal_article, replace
. destring journal_article, replace
journal_article: all characters numeric; replaced as int
.
|
| 122 |
|
▼ | 123 |
egen article_table=concat(journal_article_cluster table)
. egen article_table=concat(journal_article_cluster table)
.
|
▼ | 124 |
destring article_table, replace
. destring article_table, replace
article_table: contains nonnumeric characters; no replace
.
|
| 125 |
|
▼ | 126 |
bysort journal_article_cluster: gen test_count = _N
. bysort journal_article_cluster: gen test_count = _N
.
|
▼ | 127 |
gen aw_d=1/test_count
. gen aw_d=1/test_count
.
|
▼ | 128 |
gen aw=aw_d*10000
|
| 129 |
|
▼ | 130 |
bysort article_table: gen test_count_1 = _N
. bysort article_table: gen test_count_1 = _N
.
|
▼ | 131 |
gen aw_tab_d=1/test_count_1
. gen aw_tab_d=1/test_count_1
.
|
▼ | 132 |
gen aw_tab=aw_tab_d*10000
. gen aw_tab=aw_tab_d*10000
.
|
| 133 |
|
| 134 |
|
| 135 |
|
| 136 |
* method identifiers
|
▼ | 137 |
gen RCT=.
. gen RCT=.
(21,740 missing values generated)
.
|
▼ | 138 |
replace RCT=1 if method=="RCT"
. replace RCT=1 if method=="RCT"
(7,569 real changes made)
.
|
▼ | 139 |
replace RCT=0 if method!="RCT"
. replace RCT=0 if method!="RCT"
(14,171 real changes made)
.
|
| 140 |
|
▼ | 141 |
gen DID=.
. gen DID=.
(21,740 missing values generated)
.
|
▼ | 142 |
replace DID=1 if method=="DID"
. replace DID=1 if method=="DID"
(5,853 real changes made)
.
|
▼ | 143 |
replace DID=0 if method!="DID"
. replace DID=0 if method!="DID"
(15,887 real changes made)
.
|
| 144 |
|
▼ | 145 |
gen IV=.
. gen IV=.
(21,740 missing values generated)
.
|
▼ | 146 |
replace IV=1 if method=="IV"
. replace IV=1 if method=="IV"
(5,170 real changes made)
.
|
▼ | 147 |
replace IV=0 if method!="IV"
. replace IV=0 if method!="IV"
(16,570 real changes made)
.
|
| 148 |
|
▼ | 149 |
gen RDD=.
. gen RDD=.
(21,740 missing values generated)
.
|
▼ | 150 |
replace RDD=1 if method=="RDD"
. replace RDD=1 if method=="RDD"
(3,148 real changes made)
.
|
▼ | 151 |
replace RDD=0 if method!="RDD"
. replace RDD=0 if method!="RDD"
(18,592 real changes made)
.
|
| 152 |
|
| 153 |
* statistical threshold identifiers
|
▼ | 154 |
gen sign_1pct=.
. gen sign_1pct=.
(21,740 missing values generated)
.
|
▼ | 155 |
replace sign_1pct=1 if t!=. & t>2.58
. replace sign_1pct=1 if t!=. & t>2.58
(7,362 real changes made)
.
|
▼ | 156 |
replace sign_1pct=0 if t!=. & t<=2.58
. replace sign_1pct=0 if t!=. & t<=2.58
(14,378 real changes made)
.
|
| 157 |
|
▼ | 158 |
gen sign_5pct=.
. gen sign_5pct=.
(21,740 missing values generated)
.
|
▼ | 159 |
replace sign_5pct=1 if t!=. & t>1.96
. replace sign_5pct=1 if t!=. & t>1.96
(10,559 real changes made)
.
|
▼ | 160 |
replace sign_5pct=0 if t!=. & t<=1.96
. replace sign_5pct=0 if t!=. & t<=1.96
(11,181 real changes made)
.
|
| 161 |
|
▼ | 162 |
gen sign_10pct=.
. gen sign_10pct=.
(21,740 missing values generated)
.
|
▼ | 163 |
replace sign_10pct=1 if t!=. & t>1.65
. replace sign_10pct=1 if t!=. & t>1.65
(12,252 real changes made)
.
|
▼ | 164 |
replace sign_10pct=0 if t!=. & t<=1.65
. replace sign_10pct=0 if t!=. & t<=1.65
(9,488 real changes made)
.
|
| 165 |
|
| 166 |
* num authors
|
| 167 |
|
▼ | 168 |
capture drop num_authors
. capture drop num_authors
.
|
▼ | 169 |
egen num_authors = rownonmiss(Author*), strok
. egen num_authors = rownonmiss(Author*), strok
.
|
▼ | 170 |
replace num_authors = 11 if title=="Giving kids a head start: The impact and mechanisms of early commitment of financial aid on poor students in rural China"
replace num_authors = 11 if title=="Giving kids a head start: The impact and mechanisms of early commitment of financial aid on poor students in rural China"
. replace num_authors = 11 if title=="Giving kids a head sta
> rt: The impact and mechanisms of early commitment of financial aid on poor st
> udents in rural China"
(34 real changes made)
.
|
| 171 |
|
▼ | 172 |
capture drop authored_solo
. capture drop authored_solo
.
|
▼ | 173 |
gen authored_solo = 0
. gen authored_solo = 0
.
|
▼ | 174 |
replace authored_solo = 1 if num_authors==1
. replace authored_solo = 1 if num_authors==1
(4,360 real changes made)
.
|
| 175 |
|
| 176 |
|
| 177 |
* genders
|
| 178 |
* ssc inst egenmore // may be necessary
|
| 179 |
|
▼ | 180 |
capture drop authors_gender_string
. capture drop authors_gender_string
.
|
▼ | 181 |
gen authors_gender_string=""
. gen authors_gender_string=""
(21,740 missing values generated)
.
|
▼ | 182 |
replace authors_gender_string=Gender1+Gender2+Gender3+Gender4+Gender5+Gender6+Gender7+Gender8+Gender9+Gender10+Gender11
replace authors_gender_string=Gender1+Gender2+Gender3+Gender4+Gender5+Gender6+Gender7+Gender8+Gender9+Gender10+Gender11
. replace authors_gender_string=Gender1+Gender2+Gender3+Gend
> er4+Gender5+Gender6+Gender7+Gender8+Gender9+Gender10+Gender11
variable authors_gender_string was str1 now str11
(21,740 real changes made)
.
|
| 183 |
|
▼ | 184 |
capture drop num_male_authors
. capture drop num_male_authors
.
|
▼ | 185 |
egen num_male_authors = nss(authors_gender_string) , find(m)
egen num_male_authors = nss(authors_gender_string) , find(m)
. egen num_male_authors = nss(authors_gender_string) , find(
> m)
.
|
| 186 |
|
▼ | 187 |
capture drop num_female_authors
. capture drop num_female_authors
.
|
▼ | 188 |
egen num_female_authors = nss(authors_gender_string) , find(f)
egen num_female_authors = nss(authors_gender_string) , find(f)
. egen num_female_authors = nss(authors_gender_string) , fin
> d(f)
.
|
| 189 |
|
▼ | 190 |
capture drop share_male_authors
. capture drop share_male_authors
.
|
▼ | 191 |
gen share_male_authors = num_male_authors / num_authors
. gen share_male_authors = num_male_authors / num_authors
.
|
| 192 |
|
▼ | 193 |
capture drop share_female_authors
. capture drop share_female_authors
.
|
▼ | 194 |
gen share_female_authors = num_female_authors / num_authors
gen share_female_authors = num_female_authors / num_authors
. gen share_female_authors = num_female_authors / num_author
> s
.
|
| 195 |
|
| 196 |
|
| 197 |
|
| 198 |
* experience
|
▼ | 199 |
replace PhDYear1 = "1989" if PhDYear1=="2989"
. replace PhDYear1 = "1989" if PhDYear1=="2989"
(2 real changes made)
.
|
| 200 |
|
▼ | 201 |
forval i = 1(1)11 {
|
▼ | 202 |
capture drop PhDYear`i'sieve
capture drop PhDYear1sieve
capture drop PhDYear2sieve
capture drop PhDYear3sieve
capture drop PhDYear4sieve
capture drop PhDYear5sieve
capture drop PhDYear6sieve
capture drop PhDYear7sieve
capture drop PhDYear8sieve
capture drop PhDYear9sieve
capture drop PhDYear10sieve
capture drop PhDYear11sieve
|
▼ | 203 |
egen PhDYear`i'sieve = sieve(PhDYear`i'), keep(numeric)
egen PhDYear1sieve = sieve(PhDYear1), keep(numeric)
(536 missing values generated)
egen PhDYear2sieve = sieve(PhDYear2), keep(numeric)
(4,982 missing values generated)
egen PhDYear3sieve = sieve(PhDYear3), keep(numeric)
(10,559 missing values generated)
egen PhDYear4sieve = sieve(PhDYear4), keep(numeric)
(17,980 missing values generated)
egen PhDYear5sieve = sieve(PhDYear5), keep(numeric)
(20,534 missing values generated)
egen PhDYear6sieve = sieve(PhDYear6), keep(numeric)
(21,693 missing values generated)
egen PhDYear7sieve = sieve(PhDYear7), keep(numeric)
(21,740 missing values generated)
egen PhDYear8sieve = sieve(PhDYear8), keep(numeric)
(21,706 missing values generated)
egen PhDYear9sieve = sieve(PhDYear9), keep(numeric)
(21,706 missing values generated)
egen PhDYear10sieve = sieve(PhDYear10), keep(numeric)
(21,740 missing values generated)
|
▼ | 204 |
destring PhDYear`i'sieve, replace
destring PhDYear1sieve, replace
PhDYear1sieve: all characters numeric; replaced as int
(536 missing values generated)
destring PhDYear2sieve, replace
PhDYear2sieve: all characters numeric; replaced as int
(4982 missing values generated)
destring PhDYear3sieve, replace
PhDYear3sieve: all characters numeric; replaced as int
(10559 missing values generated)
destring PhDYear4sieve, replace
PhDYear4sieve: all characters numeric; replaced as int
(17980 missing values generated)
destring PhDYear5sieve, replace
PhDYear5sieve: all characters numeric; replaced as int
(20534 missing values generated)
destring PhDYear6sieve, replace
PhDYear6sieve: all characters numeric; replaced as int
(21693 missing values generated)
destring PhDYear7sieve, replace
PhDYear7sieve: all characters numeric; replaced as byte
(21740 missing values generated)
destring PhDYear8sieve, replace
PhDYear8sieve: all characters numeric; replaced as int
(21706 missing values generated)
destring PhDYear9sieve, replace
PhDYear9sieve: all characters numeric; replaced as int
(21706 missing values generated)
destring PhDYear10sieve, replace
PhDYear10sieve: all characters numeric; replaced as byte
(21740 missing values generated)
destring PhDYear11sieve, replace
PhDYear11sieve: all characters numeric; replaced as int
(21706 missing values generated)
|
▼ | 205 |
replace PhDYear`i'sieve = . if PhDYear`i'sieve==0
replace PhDYear1sieve = . if PhDYear1sieve==0
(0 real changes made)
replace PhDYear2sieve = . if PhDYear2sieve==0
(0 real changes made)
replace PhDYear3sieve = . if PhDYear3sieve==0
(0 real changes made)
replace PhDYear4sieve = . if PhDYear4sieve==0
(0 real changes made)
replace PhDYear5sieve = . if PhDYear5sieve==0
(12 real changes made, 12 to missing)
replace PhDYear6sieve = . if PhDYear6sieve==0
(0 real changes made)
replace PhDYear7sieve = . if PhDYear7sieve==0
(0 real changes made)
replace PhDYear8sieve = . if PhDYear8sieve==0
(0 real changes made)
replace PhDYear9sieve = . if PhDYear9sieve==0
(0 real changes made)
replace PhDYear10sieve = . if PhDYear10sieve==0
(0 real changes made)
replace PhDYear11sieve = . if PhDYear11sieve==0
(0 real changes made)
|
▼ | 206 |
replace PhDYear`i'sieve = . if PhDYear`i'sieve==9999
replace PhDYear1sieve = . if PhDYear1sieve==9999
(0 real changes made)
replace PhDYear2sieve = . if PhDYear2sieve==9999
(0 real changes made)
replace PhDYear3sieve = . if PhDYear3sieve==9999
(0 real changes made)
replace PhDYear4sieve = . if PhDYear4sieve==9999
(0 real changes made)
replace PhDYear5sieve = . if PhDYear5sieve==9999
(0 real changes made)
replace PhDYear6sieve = . if PhDYear6sieve==9999
(0 real changes made)
replace PhDYear7sieve = . if PhDYear7sieve==9999
(0 real changes made)
replace PhDYear8sieve = . if PhDYear8sieve==9999
(0 real changes made)
replace PhDYear9sieve = . if PhDYear9sieve==9999
(0 real changes made)
replace PhDYear10sieve = . if PhDYear10sieve==9999
(0 real changes made)
replace PhDYear11sieve = . if PhDYear11sieve==9999
(0 real changes made)
|
▼ | 207 |
capture drop experience`i'
capture drop experience10
capture drop experience11
|
▼ | 208 |
gen experience`i' = year-PhDYear`i'sieve
gen experience1 = year-PhDYear1sieve
(536 missing values generated)
gen experience2 = year-PhDYear2sieve
(4,982 missing values generated)
gen experience3 = year-PhDYear3sieve
(10,559 missing values generated)
gen experience4 = year-PhDYear4sieve
(17,980 missing values generated)
gen experience5 = year-PhDYear5sieve
(20,546 missing values generated)
gen experience6 = year-PhDYear6sieve
(21,693 missing values generated)
gen experience7 = year-PhDYear7sieve
(21,740 missing values generated)
gen experience8 = year-PhDYear8sieve
(21,706 missing values generated)
gen experience9 = year-PhDYear9sieve
(21,706 missing values generated)
gen experience10 = year-PhDYear10sieve
(21,740 missing values generated)
gen experience11 = year-PhDYear11sieve
(21,706 missing values generated)
|
▼ | 209 |
replace experience`i' = . if experience`i'<0
replace experience1 = . if experience1<0
(157 real changes made, 157 to missing)
replace experience2 = . if experience2<0
(330 real changes made, 330 to missing)
replace experience3 = . if experience3<0
(156 real changes made, 156 to missing)
replace experience4 = . if experience4<0
(102 real changes made, 102 to missing)
replace experience5 = . if experience5<0
(0 real changes made)
replace experience6 = . if experience6<0
(0 real changes made)
replace experience7 = . if experience7<0
(0 real changes made)
replace experience8 = . if experience8<0
(0 real changes made)
replace experience9 = . if experience9<0
(0 real changes made)
replace experience10 = . if experience10<0
(0 real changes made)
replace experience11 = . if experience11<0
(0 real changes made)
|
▼ | 210 |
replace experience`i' = . if experience`i' == .
replace experience1 = . if experience1 == .
(0 real changes made)
replace experience2 = . if experience2 == .
(0 real changes made)
replace experience3 = . if experience3 == .
(0 real changes made)
replace experience4 = . if experience4 == .
(0 real changes made)
replace experience5 = . if experience5 == .
(0 real changes made)
replace experience6 = . if experience6 == .
(0 real changes made)
replace experience7 = . if experience7 == .
(0 real changes made)
replace experience8 = . if experience8 == .
(0 real changes made)
replace experience9 = . if experience9 == .
(0 real changes made)
replace experience10 = . if experience10 == .
(0 real changes made)
replace experience11 = . if experience11 == .
(0 real changes made)
|
| 211 |
}
|
| 212 |
|
▼ | 213 |
sum PhDYear*
. sum PhDYear*
Variable | Obs Mean Std. dev. Min Max
-------------+---------------------------------------------------------
PhDYear1 | 0
PhDYear2 | 0
PhDYear3 | 0
PhDYear4 | 0
PhDYear5 | 0
-------------+---------------------------------------------------------
PhDYear6 | 0
PhDYear7 | 0
PhDYear8 | 0
PhDYear9 | 0
PhDYear10 | 0
-------------+---------------------------------------------------------
PhDYear11 | 0
PhDYear1si~e | 21,204 2005.547 8.602276 1959 2020
PhDYear2si~e | 16,758 2005.605 7.854448 1966 2021
PhDYear3si~e | 11,181 2003.636 9.216486 1972 2020
PhDYear4si~e | 3,760 2003.947 10.33362 1967 2019
-------------+---------------------------------------------------------
PhDYear5si~e | 1,194 2002.482 6.53587 1990 2016
PhDYear6si~e | 47 1987 0 1987 1987
PhDYear7si~e | 0
PhDYear8si~e | 34 2002 0 2002 2002
PhDYear9si~e | 34 2009 0 2009 2009
-------------+---------------------------------------------------------
PhDYear10s~e | 0
PhDYear11s~e | 34 1991 0 1991 1991
.
|
| 214 |
|
▼ | 215 |
sum experience*
. sum experience*
Variable | Obs Mean Std. dev. Min Max
-------------+---------------------------------------------------------
experience1 | 21,047 10.99587 8.45535 0 59
experience2 | 16,428 11.14305 7.52349 0 49
experience3 | 11,025 13.04599 8.78391 0 43
experience4 | 3,658 13.0205 9.917178 1 48
experience5 | 1,194 14.75963 6.739682 2 28
-------------+---------------------------------------------------------
experience6 | 47 28 0 28 28
experience7 | 0
experience8 | 34 13 0 13 13
experience9 | 34 6 0 6 6
experience10 | 0
-------------+---------------------------------------------------------
experience11 | 34 24 0 24 24
.
|
| 216 |
|
▼ | 217 |
capture drop experience_avg
. capture drop experience_avg
.
|
▼ | 218 |
capture drop experience_avg_sq
. capture drop experience_avg_sq
.
|
| 219 |
|
▼ | 220 |
egen experience_avg = rowmean(experience*)
. egen experience_avg = rowmean(experience*)
(71 missing values generated)
.
|
▼ | 221 |
replace experience_avg = 0 if experience_avg==.
. replace experience_avg = 0 if experience_avg==.
(71 real changes made)
.
|
▼ | 222 |
gen experience_avg_sq = (experience_avg^2)/100
. gen experience_avg_sq = (experience_avg^2)/100
.
|
| 223 |
|
▼ | 224 |
sum experience*
. sum experience*
Variable | Obs Mean Std. dev. Min Max
-------------+---------------------------------------------------------
experience1 | 21,047 10.99587 8.45535 0 59
experience2 | 16,428 11.14305 7.52349 0 49
experience3 | 11,025 13.04599 8.78391 0 43
experience4 | 3,658 13.0205 9.917178 1 48
experience5 | 1,194 14.75963 6.739682 2 28
-------------+---------------------------------------------------------
experience6 | 47 28 0 28 28
experience7 | 0
experience8 | 34 13 0 13 13
experience9 | 34 6 0 6 6
experience10 | 0
-------------+---------------------------------------------------------
experience11 | 34 24 0 24 24
experience~g | 21,740 10.73031 5.816504 0 38
experience~q | 21,740 1.489696 1.672511 0 14.44
.
|
| 225 |
|
| 226 |
|
| 227 |
* editor_present
|
| 228 |
|
▼ | 229 |
forval i = 1(1)11 {
|
▼ | 230 |
destring Editor`i', replace force
destring Editor1, replace force
Editor1: contains nonnumeric characters; replaced as byte
(303 missing values generated)
destring Editor2, replace force
Editor2: contains nonnumeric characters; replaced as byte
(4468 missing values generated)
destring Editor3, replace force
Editor3: contains nonnumeric characters; replaced as byte
(10451 missing values generated)
destring Editor4, replace force
Editor4: contains nonnumeric characters; replaced as byte
(17890 missing values generated)
destring Editor5, replace force
Editor5: contains nonnumeric characters; replaced as byte
(20482 missing values generated)
destring Editor6, replace force
Editor6: contains nonnumeric characters; replaced as byte
(21437 missing values generated)
destring Editor7, replace force
Editor7: contains nonnumeric characters; replaced as byte
(21740 missing values generated)
destring Editor8, replace force
Editor8: all characters numeric; replaced as byte
(21706 missing values generated)
destring Editor9, replace force
Editor9: all characters numeric; replaced as byte
(21706 missing values generated)
destring Editor10, replace force
Editor10: all characters numeric; replaced as byte
(21706 missing values generated)
destring Editor11, replace force
Editor11: all characters numeric; replaced as byte
(21706 missing values generated)
|
▼ | 231 |
replace Editor`i' = 0 if Editor`i'==.
replace Editor1 = 0 if Editor1==.
(303 real changes made)
replace Editor2 = 0 if Editor2==.
(4,468 real changes made)
replace Editor3 = 0 if Editor3==.
(10,451 real changes made)
replace Editor4 = 0 if Editor4==.
(17,890 real changes made)
replace Editor5 = 0 if Editor5==.
(20,482 real changes made)
replace Editor6 = 0 if Editor6==.
(21,437 real changes made)
replace Editor7 = 0 if Editor7==.
(21,740 real changes made)
replace Editor8 = 0 if Editor8==.
(21,706 real changes made)
replace Editor9 = 0 if Editor9==.
(21,706 real changes made)
replace Editor10 = 0 if Editor10==.
(21,706 real changes made)
replace Editor11 = 0 if Editor11==.
(21,706 real changes made)
|
| 232 |
}
|
| 233 |
|
▼ | 234 |
capture drop editor_present
. capture drop editor_present
.
|
▼ | 235 |
egen editor_present = rowmax(Editor*)
. egen editor_present = rowmax(Editor*)
.
|
| 236 |
|
| 237 |
* share_top_authors
|
| 238 |
|
▼ | 239 |
forval i = 1(1)11 {
|
▼ | 240 |
capture drop top_author`i'
capture drop top_author10
capture drop top_author11
|
▼ | 241 |
gen top_author`i'=0
|
▼ | 242 |
replace top_author`i'=. if Author`i'==""
replace top_author1=. if Author1==""
(0 real changes made)
replace top_author2=. if Author2==""
(4,394 real changes made, 4,394 to missing)
replace top_author3=. if Author3==""
(10,395 real changes made, 10,395 to missing)
replace top_author4=. if Author4==""
(17,884 real changes made, 17,884 to missing)
replace top_author5=. if Author5==""
(20,482 real changes made, 20,482 to missing)
replace top_author6=. if Author6==""
(21,437 real changes made, 21,437 to missing)
replace top_author7=. if Author7==""
(21,693 real changes made, 21,693 to missing)
replace top_author8=. if Author8==""
(21,740 real changes made, 21,740 to missing)
replace top_author9=. if Author9==""
(21,740 real changes made, 21,740 to missing)
replace top_author10=. if Author10==""
(21,740 real changes made, 21,740 to missing)
replace top_author11=. if Author11==""
(21,740 real changes made, 21,740 to missing)
|
▼ | 243 |
replace top_author`i'=1 if strpos(AF`i', "Harvard")
replace top_author1=1 if strpos(AF1, "Harvard")
(1,233 real changes made)
replace top_author2=1 if strpos(AF2, "Harvard")
(747 real changes made)
replace top_author3=1 if strpos(AF3, "Harvard")
(573 real changes made)
replace top_author4=1 if strpos(AF4, "Harvard")
(116 real changes made)
replace top_author5=1 if strpos(AF5, "Harvard")
(22 real changes made)
replace top_author6=1 if strpos(AF6, "Harvard")
(0 real changes made)
replace top_author7=1 if strpos(AF7, "Harvard")
(0 real changes made)
replace top_author8=1 if strpos(AF8, "Harvard")
(0 real changes made)
replace top_author9=1 if strpos(AF9, "Harvard")
(0 real changes made)
replace top_author10=1 if strpos(AF10, "Harvard")
(0 real changes made)
replace top_author11=1 if strpos(AF11, "Harvard")
(0 real changes made)
|
▼ | 244 |
replace top_author`i'=1 if strpos(AF`i', "Massachusetts Institute of Technology") | strpos(AF`i', "MIT")
replace top_author1=1 if strpos(AF1, "Massachusetts Institute of Technology") | strpos(AF1, "MIT")
(1,092 real changes made)
replace top_author2=1 if strpos(AF2, "Massachusetts Institute of Technology") | strpos(AF2, "MIT")
(226 real changes made)
replace top_author3=1 if strpos(AF3, "Massachusetts Institute of Technology") | strpos(AF3, "MIT")
(640 real changes made)
replace top_author4=1 if strpos(AF4, "Massachusetts Institute of Technology") | strpos(AF4, "MIT")
(135 real changes made)
replace top_author5=1 if strpos(AF5, "Massachusetts Institute of Technology") | strpos(AF5, "MIT")
(0 real changes made)
replace top_author6=1 if strpos(AF6, "Massachusetts Institute of Technology") | strpos(AF6, "MIT")
(0 real changes made)
replace top_author7=1 if strpos(AF7, "Massachusetts Institute of Technology") | strpos(AF7, "MIT")
(0 real changes made)
replace top_author8=1 if strpos(AF8, "Massachusetts Institute of Technology") | strpos(AF8, "MIT")
(0 real changes made)
replace top_author9=1 if strpos(AF9, "Massachusetts Institute of Technology") | strpos(AF9, "MIT")
(0 real changes made)
replace top_author10=1 if strpos(AF10, "Massachusetts Institute of Technology") | strpos(AF10, "MIT")
(0 real changes made)
replace top_author11=1 if strpos(AF11, "Massachusetts Institute of Technology") | strpos(AF11, "MIT")
(0 real changes made)
|
▼ | 245 |
replace top_author`i'=1 if strpos(AF`i', "Berkeley")
replace top_author1=1 if strpos(AF1, "Berkeley")
(290 real changes made)
replace top_author2=1 if strpos(AF2, "Berkeley")
(683 real changes made)
replace top_author3=1 if strpos(AF3, "Berkeley")
(460 real changes made)
replace top_author4=1 if strpos(AF4, "Berkeley")
(6 real changes made)
replace top_author5=1 if strpos(AF5, "Berkeley")
(0 real changes made)
replace top_author6=1 if strpos(AF6, "Berkeley")
(0 real changes made)
replace top_author7=1 if strpos(AF7, "Berkeley")
(0 real changes made)
replace top_author8=1 if strpos(AF8, "Berkeley")
(0 real changes made)
replace top_author9=1 if strpos(AF9, "Berkeley")
(0 real changes made)
replace top_author10=1 if strpos(AF10, "Berkeley")
(0 real changes made)
replace top_author11=1 if strpos(AF11, "Berkeley")
(0 real changes made)
|
▼ | 246 |
replace top_author`i'=1 if strpos(AF`i', "University of Chicago")
replace top_author1=1 if strpos(AF1, "University of Chicago")
(594 real changes made)
replace top_author2=1 if strpos(AF2, "University of Chicago")
(395 real changes made)
replace top_author3=1 if strpos(AF3, "University of Chicago")
(724 real changes made)
replace top_author4=1 if strpos(AF4, "University of Chicago")
(69 real changes made)
replace top_author5=1 if strpos(AF5, "University of Chicago")
(0 real changes made)
replace top_author6=1 if strpos(AF6, "University of Chicago")
(0 real changes made)
replace top_author7=1 if strpos(AF7, "University of Chicago")
(0 real changes made)
replace top_author8=1 if strpos(AF8, "University of Chicago")
(0 real changes made)
replace top_author9=1 if strpos(AF9, "University of Chicago")
(0 real changes made)
replace top_author10=1 if strpos(AF10, "University of Chicago")
(0 real changes made)
replace top_author11=1 if strpos(AF11, "University of Chicago")
(0 real changes made)
|
▼ | 247 |
replace top_author`i'=1 if strpos(AF`i', "Paris School of Economics") | strpos(AF`i', "PSE")
replace top_author1=1 if strpos(AF1, "Paris School of Economics") | strpos(AF1, "PSE")
(174 real changes made)
replace top_author2=1 if strpos(AF2, "Paris School of Economics") | strpos(AF2, "PSE")
(361 real changes made)
replace top_author3=1 if strpos(AF3, "Paris School of Economics") | strpos(AF3, "PSE")
(189 real changes made)
replace top_author4=1 if strpos(AF4, "Paris School of Economics") | strpos(AF4, "PSE")
(0 real changes made)
replace top_author5=1 if strpos(AF5, "Paris School of Economics") | strpos(AF5, "PSE")
(55 real changes made)
replace top_author6=1 if strpos(AF6, "Paris School of Economics") | strpos(AF6, "PSE")
(0 real changes made)
replace top_author7=1 if strpos(AF7, "Paris School of Economics") | strpos(AF7, "PSE")
(0 real changes made)
replace top_author8=1 if strpos(AF8, "Paris School of Economics") | strpos(AF8, "PSE")
(0 real changes made)
replace top_author9=1 if strpos(AF9, "Paris School of Economics") | strpos(AF9, "PSE")
(0 real changes made)
replace top_author10=1 if strpos(AF10, "Paris School of Economics") | strpos(AF10, "PSE")
(0 real changes made)
replace top_author11=1 if strpos(AF11, "Paris School of Economics") | strpos(AF11, "PSE")
(0 real changes made)
|
▼ | 248 |
replace top_author`i'=1 if strpos(AF`i', "Princeton University")
replace top_author1=1 if strpos(AF1, "Princeton University")
(497 real changes made)
replace top_author2=1 if strpos(AF2, "Princeton University")
(163 real changes made)
replace top_author3=1 if strpos(AF3, "Princeton University")
(18 real changes made)
replace top_author4=1 if strpos(AF4, "Princeton University")
(0 real changes made)
replace top_author5=1 if strpos(AF5, "Princeton University")
(0 real changes made)
replace top_author6=1 if strpos(AF6, "Princeton University")
(0 real changes made)
replace top_author7=1 if strpos(AF7, "Princeton University")
(0 real changes made)
replace top_author8=1 if strpos(AF8, "Princeton University")
(0 real changes made)
replace top_author9=1 if strpos(AF9, "Princeton University")
(0 real changes made)
replace top_author10=1 if strpos(AF10, "Princeton University")
(0 real changes made)
replace top_author11=1 if strpos(AF11, "Princeton University")
(0 real changes made)
|
▼ | 249 |
replace top_author`i'=1 if strpos(AF`i', "Stanford University")
replace top_author1=1 if strpos(AF1, "Stanford University")
(425 real changes made)
replace top_author2=1 if strpos(AF2, "Stanford University")
(363 real changes made)
replace top_author3=1 if strpos(AF3, "Stanford University")
(18 real changes made)
replace top_author4=1 if strpos(AF4, "Stanford University")
(15 real changes made)
replace top_author5=1 if strpos(AF5, "Stanford University")
(0 real changes made)
replace top_author6=1 if strpos(AF6, "Stanford University")
(0 real changes made)
replace top_author7=1 if strpos(AF7, "Stanford University")
(0 real changes made)
replace top_author8=1 if strpos(AF8, "Stanford University")
(0 real changes made)
replace top_author9=1 if strpos(AF9, "Stanford University")
(34 real changes made)
replace top_author10=1 if strpos(AF10, "Stanford University")
(34 real changes made)
replace top_author11=1 if strpos(AF11, "Stanford University")
(34 real changes made)
|
▼ | 250 |
replace top_author`i'=1 if strpos(AF`i', "Oxford University")
replace top_author1=1 if strpos(AF1, "Oxford University")
(7 real changes made)
replace top_author2=1 if strpos(AF2, "Oxford University")
(0 real changes made)
replace top_author3=1 if strpos(AF3, "Oxford University")
(12 real changes made)
replace top_author4=1 if strpos(AF4, "Oxford University")
(0 real changes made)
replace top_author5=1 if strpos(AF5, "Oxford University")
(0 real changes made)
replace top_author6=1 if strpos(AF6, "Oxford University")
(0 real changes made)
replace top_author7=1 if strpos(AF7, "Oxford University")
(0 real changes made)
replace top_author8=1 if strpos(AF8, "Oxford University")
(0 real changes made)
replace top_author9=1 if strpos(AF9, "Oxford University")
(0 real changes made)
replace top_author10=1 if strpos(AF10, "Oxford University")
(0 real changes made)
replace top_author11=1 if strpos(AF11, "Oxford University")
(0 real changes made)
|
▼ | 251 |
replace top_author`i'=1 if strpos(AF`i', "Toulouse School of Economics") | strpos(AF`i', "TSE")
replace top_author1=1 if strpos(AF1, "Toulouse School of Economics") | strpos(AF1, "TSE")
(0 real changes made)
replace top_author2=1 if strpos(AF2, "Toulouse School of Economics") | strpos(AF2, "TSE")
(0 real changes made)
replace top_author3=1 if strpos(AF3, "Toulouse School of Economics") | strpos(AF3, "TSE")
(0 real changes made)
replace top_author4=1 if strpos(AF4, "Toulouse School of Economics") | strpos(AF4, "TSE")
(0 real changes made)
replace top_author5=1 if strpos(AF5, "Toulouse School of Economics") | strpos(AF5, "TSE")
(0 real changes made)
replace top_author6=1 if strpos(AF6, "Toulouse School of Economics") | strpos(AF6, "TSE")
(0 real changes made)
replace top_author7=1 if strpos(AF7, "Toulouse School of Economics") | strpos(AF7, "TSE")
(0 real changes made)
replace top_author8=1 if strpos(AF8, "Toulouse School of Economics") | strpos(AF8, "TSE")
(0 real changes made)
replace top_author9=1 if strpos(AF9, "Toulouse School of Economics") | strpos(AF9, "TSE")
(0 real changes made)
replace top_author10=1 if strpos(AF10, "Toulouse School of Economics") | strpos(AF10, "TSE")
(0 real changes made)
replace top_author11=1 if strpos(AF11, "Toulouse School of Economics") | strpos(AF11, "TSE")
(0 real changes made)
|
▼ | 252 |
replace top_author`i'=1 if strpos(AF`i', "Columbia University")
replace top_author1=1 if strpos(AF1, "Columbia University")
(220 real changes made)
replace top_author2=1 if strpos(AF2, "Columbia University")
(355 real changes made)
replace top_author3=1 if strpos(AF3, "Columbia University")
(42 real changes made)
replace top_author4=1 if strpos(AF4, "Columbia University")
(0 real changes made)
replace top_author5=1 if strpos(AF5, "Columbia University")
(0 real changes made)
replace top_author6=1 if strpos(AF6, "Columbia University")
(0 real changes made)
replace top_author7=1 if strpos(AF7, "Columbia University")
(0 real changes made)
replace top_author8=1 if strpos(AF8, "Columbia University")
(0 real changes made)
replace top_author9=1 if strpos(AF9, "Columbia University")
(0 real changes made)
replace top_author10=1 if strpos(AF10, "Columbia University")
(0 real changes made)
replace top_author11=1 if strpos(AF11, "Columbia University")
(0 real changes made)
|
▼ | 253 |
replace top_author`i'=1 if strpos(AF`i', "New York University") | strpos(AF`i', "NYU")
replace top_author1=1 if strpos(AF1, "New York University") | strpos(AF1, "NYU")
(137 real changes made)
replace top_author2=1 if strpos(AF2, "New York University") | strpos(AF2, "NYU")
(258 real changes made)
replace top_author3=1 if strpos(AF3, "New York University") | strpos(AF3, "NYU")
(163 real changes made)
replace top_author4=1 if strpos(AF4, "New York University") | strpos(AF4, "NYU")
(103 real changes made)
replace top_author5=1 if strpos(AF5, "New York University") | strpos(AF5, "NYU")
(0 real changes made)
replace top_author6=1 if strpos(AF6, "New York University") | strpos(AF6, "NYU")
(0 real changes made)
replace top_author7=1 if strpos(AF7, "New York University") | strpos(AF7, "NYU")
(0 real changes made)
replace top_author8=1 if strpos(AF8, "New York University") | strpos(AF8, "NYU")
(0 real changes made)
replace top_author9=1 if strpos(AF9, "New York University") | strpos(AF9, "NYU")
(0 real changes made)
replace top_author10=1 if strpos(AF10, "New York University") | strpos(AF10, "NYU")
(0 real changes made)
replace top_author11=1 if strpos(AF11, "New York University") | strpos(AF11, "NYU")
(0 real changes made)
|
▼ | 254 |
replace top_author`i'=1 if strpos(AF`i', "Yale University")
replace top_author1=1 if strpos(AF1, "Yale University")
(71 real changes made)
replace top_author2=1 if strpos(AF2, "Yale University")
(227 real changes made)
replace top_author3=1 if strpos(AF3, "Yale University")
(32 real changes made)
replace top_author4=1 if strpos(AF4, "Yale University")
(68 real changes made)
replace top_author5=1 if strpos(AF5, "Yale University")
(0 real changes made)
replace top_author6=1 if strpos(AF6, "Yale University")
(256 real changes made)
replace top_author7=1 if strpos(AF7, "Yale University")
(0 real changes made)
replace top_author8=1 if strpos(AF8, "Yale University")
(0 real changes made)
replace top_author9=1 if strpos(AF9, "Yale University")
(0 real changes made)
replace top_author10=1 if strpos(AF10, "Yale University")
(0 real changes made)
replace top_author11=1 if strpos(AF11, "Yale University")
(0 real changes made)
|
▼ | 255 |
replace top_author`i'=1 if strpos(AF`i', "Boston University")
replace top_author1=1 if strpos(AF1, "Boston University")
(37 real changes made)
replace top_author2=1 if strpos(AF2, "Boston University")
(67 real changes made)
replace top_author3=1 if strpos(AF3, "Boston University")
(4 real changes made)
replace top_author4=1 if strpos(AF4, "Boston University")
(0 real changes made)
replace top_author5=1 if strpos(AF5, "Boston University")
(0 real changes made)
replace top_author6=1 if strpos(AF6, "Boston University")
(0 real changes made)
replace top_author7=1 if strpos(AF7, "Boston University")
(0 real changes made)
replace top_author8=1 if strpos(AF8, "Boston University")
(0 real changes made)
replace top_author9=1 if strpos(AF9, "Boston University")
(0 real changes made)
replace top_author10=1 if strpos(AF10, "Boston University")
(0 real changes made)
replace top_author11=1 if strpos(AF11, "Boston University")
(0 real changes made)
|
▼ | 256 |
replace top_author`i'=1 if strpos(AF`i', "Barcelona Graduate School of Economics") | strpos(AF`i', "Barcelona GSE")
replace top_author1=1 if strpos(AF1, "Barcelona Graduate School of Economics") | strpos(AF1, "Barcelona GSE")
(92 real changes made)
replace top_author2=1 if strpos(AF2, "Barcelona Graduate School of Economics") | strpos(AF2, "Barcelona GSE")
(84 real changes made)
replace top_author3=1 if strpos(AF3, "Barcelona Graduate School of Economics") | strpos(AF3, "Barcelona GSE")
(20 real changes made)
replace top_author4=1 if strpos(AF4, "Barcelona Graduate School of Economics") | strpos(AF4, "Barcelona GSE")
(0 real changes made)
replace top_author5=1 if strpos(AF5, "Barcelona Graduate School of Economics") | strpos(AF5, "Barcelona GSE")
(0 real changes made)
replace top_author6=1 if strpos(AF6, "Barcelona Graduate School of Economics") | strpos(AF6, "Barcelona GSE")
(0 real changes made)
replace top_author7=1 if strpos(AF7, "Barcelona Graduate School of Economics") | strpos(AF7, "Barcelona GSE")
(0 real changes made)
replace top_author8=1 if strpos(AF8, "Barcelona Graduate School of Economics") | strpos(AF8, "Barcelona GSE")
(0 real changes made)
replace top_author9=1 if strpos(AF9, "Barcelona Graduate School of Economics") | strpos(AF9, "Barcelona GSE")
(0 real changes made)
replace top_author10=1 if strpos(AF10, "Barcelona Graduate School of Economics") | strpos(AF10, "Barcelona GSE")
(0 real changes made)
replace top_author11=1 if strpos(AF11, "Barcelona Graduate School of Economics") | strpos(AF11, "Barcelona GSE")
(0 real changes made)
|
▼ | 257 |
replace top_author`i'=1 if strpos(AF`i', "University of California-San Diego") | strpos(AF`i', "UCSD")
replace top_author1=1 if strpos(AF1, "University of California-San Diego") | strpos(AF1, "UCSD")
(0 real changes made)
replace top_author2=1 if strpos(AF2, "University of California-San Diego") | strpos(AF2, "UCSD")
(0 real changes made)
replace top_author3=1 if strpos(AF3, "University of California-San Diego") | strpos(AF3, "UCSD")
(0 real changes made)
replace top_author4=1 if strpos(AF4, "University of California-San Diego") | strpos(AF4, "UCSD")
(0 real changes made)
replace top_author5=1 if strpos(AF5, "University of California-San Diego") | strpos(AF5, "UCSD")
(0 real changes made)
replace top_author6=1 if strpos(AF6, "University of California-San Diego") | strpos(AF6, "UCSD")
(0 real changes made)
replace top_author7=1 if strpos(AF7, "University of California-San Diego") | strpos(AF7, "UCSD")
(0 real changes made)
replace top_author8=1 if strpos(AF8, "University of California-San Diego") | strpos(AF8, "UCSD")
(0 real changes made)
replace top_author9=1 if strpos(AF9, "University of California-San Diego") | strpos(AF9, "UCSD")
(0 real changes made)
replace top_author10=1 if strpos(AF10, "University of California-San Diego") | strpos(AF10, "UCSD")
(0 real changes made)
replace top_author11=1 if strpos(AF11, "University of California-San Diego") | strpos(AF11, "UCSD")
(0 real changes made)
|
▼ | 258 |
replace top_author`i'=1 if strpos(AF`i', "Dartmouth College")
replace top_author1=1 if strpos(AF1, "Dartmouth College")
(60 real changes made)
replace top_author2=1 if strpos(AF2, "Dartmouth College")
(65 real changes made)
replace top_author3=1 if strpos(AF3, "Dartmouth College")
(89 real changes made)
replace top_author4=1 if strpos(AF4, "Dartmouth College")
(55 real changes made)
replace top_author5=1 if strpos(AF5, "Dartmouth College")
(0 real changes made)
replace top_author6=1 if strpos(AF6, "Dartmouth College")
(0 real changes made)
replace top_author7=1 if strpos(AF7, "Dartmouth College")
(0 real changes made)
replace top_author8=1 if strpos(AF8, "Dartmouth College")
(0 real changes made)
replace top_author9=1 if strpos(AF9, "Dartmouth College")
(0 real changes made)
replace top_author10=1 if strpos(AF10, "Dartmouth College")
(0 real changes made)
replace top_author11=1 if strpos(AF11, "Dartmouth College")
(0 real changes made)
|
▼ | 259 |
replace top_author`i'=1 if strpos(AF`i', "University of Pennsylvania")
replace top_author1=1 if strpos(AF1, "University of Pennsylvania")
(237 real changes made)
replace top_author2=1 if strpos(AF2, "University of Pennsylvania")
(229 real changes made)
replace top_author3=1 if strpos(AF3, "University of Pennsylvania")
(280 real changes made)
replace top_author4=1 if strpos(AF4, "University of Pennsylvania")
(135 real changes made)
replace top_author5=1 if strpos(AF5, "University of Pennsylvania")
(296 real changes made)
replace top_author6=1 if strpos(AF6, "University of Pennsylvania")
(0 real changes made)
replace top_author7=1 if strpos(AF7, "University of Pennsylvania")
(0 real changes made)
replace top_author8=1 if strpos(AF8, "University of Pennsylvania")
(0 real changes made)
replace top_author9=1 if strpos(AF9, "University of Pennsylvania")
(0 real changes made)
replace top_author10=1 if strpos(AF10, "University of Pennsylvania")
(0 real changes made)
replace top_author11=1 if strpos(AF11, "University of Pennsylvania")
(0 real changes made)
|
▼ | 260 |
replace top_author`i'=1 if strpos(AF`i', "University College London") | strpos(AF`i', "UCL")
replace top_author1=1 if strpos(AF1, "University College London") | strpos(AF1, "UCL")
(304 real changes made)
replace top_author2=1 if strpos(AF2, "University College London") | strpos(AF2, "UCL")
(18 real changes made)
replace top_author3=1 if strpos(AF3, "University College London") | strpos(AF3, "UCL")
(52 real changes made)
replace top_author4=1 if strpos(AF4, "University College London") | strpos(AF4, "UCL")
(12 real changes made)
replace top_author5=1 if strpos(AF5, "University College London") | strpos(AF5, "UCL")
(12 real changes made)
replace top_author6=1 if strpos(AF6, "University College London") | strpos(AF6, "UCL")
(0 real changes made)
replace top_author7=1 if strpos(AF7, "University College London") | strpos(AF7, "UCL")
(0 real changes made)
replace top_author8=1 if strpos(AF8, "University College London") | strpos(AF8, "UCL")
(0 real changes made)
replace top_author9=1 if strpos(AF9, "University College London") | strpos(AF9, "UCL")
(0 real changes made)
replace top_author10=1 if strpos(AF10, "University College London") | strpos(AF10, "UCL")
(0 real changes made)
replace top_author11=1 if strpos(AF11, "University College London") | strpos(AF11, "UCL")
(0 real changes made)
|
▼ | 261 |
replace top_author`i'=1 if strpos(AF`i', "Northwestern University")
replace top_author1=1 if strpos(AF1, "Northwestern University")
(327 real changes made)
replace top_author2=1 if strpos(AF2, "Northwestern University")
(463 real changes made)
replace top_author3=1 if strpos(AF3, "Northwestern University")
(93 real changes made)
replace top_author4=1 if strpos(AF4, "Northwestern University")
(129 real changes made)
replace top_author5=1 if strpos(AF5, "Northwestern University")
(0 real changes made)
replace top_author6=1 if strpos(AF6, "Northwestern University")
(0 real changes made)
replace top_author7=1 if strpos(AF7, "Northwestern University")
(0 real changes made)
replace top_author8=1 if strpos(AF8, "Northwestern University")
(0 real changes made)
replace top_author9=1 if strpos(AF9, "Northwestern University")
(0 real changes made)
replace top_author10=1 if strpos(AF10, "Northwestern University")
(0 real changes made)
replace top_author11=1 if strpos(AF11, "Northwestern University")
(0 real changes made)
|
▼ | 262 |
replace top_author`i'=1 if strpos(AF`i', "Columbia University")
replace top_author1=1 if strpos(AF1, "Columbia University")
(0 real changes made)
replace top_author2=1 if strpos(AF2, "Columbia University")
(0 real changes made)
replace top_author3=1 if strpos(AF3, "Columbia University")
(0 real changes made)
replace top_author4=1 if strpos(AF4, "Columbia University")
(0 real changes made)
replace top_author5=1 if strpos(AF5, "Columbia University")
(0 real changes made)
replace top_author6=1 if strpos(AF6, "Columbia University")
(0 real changes made)
replace top_author7=1 if strpos(AF7, "Columbia University")
(0 real changes made)
replace top_author8=1 if strpos(AF8, "Columbia University")
(0 real changes made)
replace top_author9=1 if strpos(AF9, "Columbia University")
(0 real changes made)
replace top_author10=1 if strpos(AF10, "Columbia University")
(0 real changes made)
replace top_author11=1 if strpos(AF11, "Columbia University")
(0 real changes made)
|
▼ | 263 |
replace top_author`i'=1 if strpos(AF`i', "University of California-Los Angeles ") | strpos(AF`i', "UCLA")
replace top_author1=1 if strpos(AF1, "University of California-Los Angeles ") | strpos(AF1, "UCLA")
(0 real changes made)
replace top_author2=1 if strpos(AF2, "University of California-Los Angeles ") | strpos(AF2, "UCLA")
(0 real changes made)
replace top_author3=1 if strpos(AF3, "University of California-Los Angeles ") | strpos(AF3, "UCLA")
(0 real changes made)
replace top_author4=1 if strpos(AF4, "University of California-Los Angeles ") | strpos(AF4, "UCLA")
(0 real changes made)
replace top_author5=1 if strpos(AF5, "University of California-Los Angeles ") | strpos(AF5, "UCLA")
(0 real changes made)
replace top_author6=1 if strpos(AF6, "University of California-Los Angeles ") | strpos(AF6, "UCLA")
(0 real changes made)
replace top_author7=1 if strpos(AF7, "University of California-Los Angeles ") | strpos(AF7, "UCLA")
(0 real changes made)
replace top_author8=1 if strpos(AF8, "University of California-Los Angeles ") | strpos(AF8, "UCLA")
(0 real changes made)
replace top_author9=1 if strpos(AF9, "University of California-Los Angeles ") | strpos(AF9, "UCLA")
(0 real changes made)
replace top_author10=1 if strpos(AF10, "University of California-Los Angeles ") | strpos(AF10, "UCLA")
(0 real changes made)
replace top_author11=1 if strpos(AF11, "University of California-Los Angeles ") | strpos(AF11, "UCLA")
(0 real changes made)
|
▼ | 264 |
replace top_author`i'=1 if strpos(AF`i', "London School of Economics") | strpos(AF`i', "LSE")
replace top_author1=1 if strpos(AF1, "London School of Economics") | strpos(AF1, "LSE")
(528 real changes made)
replace top_author2=1 if strpos(AF2, "London School of Economics") | strpos(AF2, "LSE")
(267 real changes made)
replace top_author3=1 if strpos(AF3, "London School of Economics") | strpos(AF3, "LSE")
(167 real changes made)
replace top_author4=1 if strpos(AF4, "London School of Economics") | strpos(AF4, "LSE")
(120 real changes made)
replace top_author5=1 if strpos(AF5, "London School of Economics") | strpos(AF5, "LSE")
(0 real changes made)
replace top_author6=1 if strpos(AF6, "London School of Economics") | strpos(AF6, "LSE")
(0 real changes made)
replace top_author7=1 if strpos(AF7, "London School of Economics") | strpos(AF7, "LSE")
(0 real changes made)
replace top_author8=1 if strpos(AF8, "London School of Economics") | strpos(AF8, "LSE")
(0 real changes made)
replace top_author9=1 if strpos(AF9, "London School of Economics") | strpos(AF9, "LSE")
(0 real changes made)
replace top_author10=1 if strpos(AF10, "London School of Economics") | strpos(AF10, "LSE")
(0 real changes made)
replace top_author11=1 if strpos(AF11, "London School of Economics") | strpos(AF11, "LSE")
(0 real changes made)
|
▼ | 265 |
replace top_author`i'=1 if strpos(AF`i', "University of Wisconsin-Madison")
replace top_author1=1 if strpos(AF1, "University of Wisconsin-Madison")
(2 real changes made)
replace top_author2=1 if strpos(AF2, "University of Wisconsin-Madison")
(0 real changes made)
replace top_author3=1 if strpos(AF3, "University of Wisconsin-Madison")
(0 real changes made)
replace top_author4=1 if strpos(AF4, "University of Wisconsin-Madison")
(0 real changes made)
replace top_author5=1 if strpos(AF5, "University of Wisconsin-Madison")
(0 real changes made)
replace top_author6=1 if strpos(AF6, "University of Wisconsin-Madison")
(0 real changes made)
replace top_author7=1 if strpos(AF7, "University of Wisconsin-Madison")
(0 real changes made)
replace top_author8=1 if strpos(AF8, "University of Wisconsin-Madison")
(0 real changes made)
replace top_author9=1 if strpos(AF9, "University of Wisconsin-Madison")
(0 real changes made)
replace top_author10=1 if strpos(AF10, "University of Wisconsin-Madison")
(0 real changes made)
replace top_author11=1 if strpos(AF11, "University of Wisconsin-Madison")
(0 real changes made)
|
▼ | 266 |
replace top_author`i'=1 if strpos(AF`i', "University of Michigan")
replace top_author1=1 if strpos(AF1, "University of Michigan")
(368 real changes made)
replace top_author2=1 if strpos(AF2, "University of Michigan")
(80 real changes made)
replace top_author3=1 if strpos(AF3, "University of Michigan")
(169 real changes made)
replace top_author4=1 if strpos(AF4, "University of Michigan")
(182 real changes made)
replace top_author5=1 if strpos(AF5, "University of Michigan")
(0 real changes made)
replace top_author6=1 if strpos(AF6, "University of Michigan")
(0 real changes made)
replace top_author7=1 if strpos(AF7, "University of Michigan")
(0 real changes made)
replace top_author8=1 if strpos(AF8, "University of Michigan")
(0 real changes made)
replace top_author9=1 if strpos(AF9, "University of Michigan")
(0 real changes made)
replace top_author10=1 if strpos(AF10, "University of Michigan")
(0 real changes made)
replace top_author11=1 if strpos(AF11, "University of Michigan")
(0 real changes made)
|
| 267 |
}
|
| 268 |
|
▼ | 269 |
capture drop share_top_authors
. capture drop share_top_authors
.
|
▼ | 270 |
egen share_top_authors = rowmean(top_author`i'*)
egen share_top_authors = rowmean(top_author*)
. egen share_top_authors = rowmean(top_author`i'*)
.
|
| 271 |
|
| 272 |
* share_top_phd
|
| 273 |
|
▼ | 274 |
forval i = 1(1)11 {
|
▼ | 275 |
capture drop top_phd`i'
|
▼ | 276 |
gen top_phd`i'=0
|
▼ | 277 |
replace top_phd`i'=. if Author`i'==""
replace top_phd1=. if Author1==""
(0 real changes made)
replace top_phd2=. if Author2==""
(4,394 real changes made, 4,394 to missing)
replace top_phd3=. if Author3==""
(10,395 real changes made, 10,395 to missing)
replace top_phd4=. if Author4==""
(17,884 real changes made, 17,884 to missing)
replace top_phd5=. if Author5==""
(20,482 real changes made, 20,482 to missing)
replace top_phd6=. if Author6==""
(21,437 real changes made, 21,437 to missing)
replace top_phd7=. if Author7==""
(21,693 real changes made, 21,693 to missing)
replace top_phd8=. if Author8==""
(21,740 real changes made, 21,740 to missing)
replace top_phd9=. if Author9==""
(21,740 real changes made, 21,740 to missing)
replace top_phd10=. if Author10==""
(21,740 real changes made, 21,740 to missing)
replace top_phd11=. if Author11==""
(21,740 real changes made, 21,740 to missing)
|
▼ | 278 |
replace top_phd`i'=1 if strpos(PhDInstitution`i', "Harvard")
replace top_phd1=1 if strpos(PhDInstitution1, "Harvard")
(2,389 real changes made)
replace top_phd2=1 if strpos(PhDInstitution2, "Harvard")
(1,758 real changes made)
replace top_phd3=1 if strpos(PhDInstitution3, "Harvard")
(968 real changes made)
replace top_phd4=1 if strpos(PhDInstitution4, "Harvard")
(483 real changes made)
replace top_phd5=1 if strpos(PhDInstitution5, "Harvard")
(43 real changes made)
replace top_phd6=1 if strpos(PhDInstitution6, "Harvard")
(0 real changes made)
replace top_phd7=1 if strpos(PhDInstitution7, "Harvard")
(0 real changes made)
replace top_phd8=1 if strpos(PhDInstitution8, "Harvard")
(0 real changes made)
replace top_phd9=1 if strpos(PhDInstitution9, "Harvard")
(0 real changes made)
replace top_phd10=1 if strpos(PhDInstitution10, "Harvard")
(0 real changes made)
replace top_phd11=1 if strpos(PhDInstitution11, "Harvard")
(0 real changes made)
|
▼ | 279 |
replace top_phd`i'=1 if strpos(PhDInstitution`i', "Massachusetts Institute of Technology") | strpos(PhDInstitution`i', "MIT")
replace top_phd1=1 if strpos(PhDInstitution1, "Massachusetts Institute of Technology") | strpos(PhDInstitution1, "MIT")
(2,279 real changes made)
replace top_phd2=1 if strpos(PhDInstitution2, "Massachusetts Institute of Technology") | strpos(PhDInstitution2, "MIT")
(1,427 real changes made)
replace top_phd3=1 if strpos(PhDInstitution3, "Massachusetts Institute of Technology") | strpos(PhDInstitution3, "MIT")
(1,199 real changes made)
replace top_phd4=1 if strpos(PhDInstitution4, "Massachusetts Institute of Technology") | strpos(PhDInstitution4, "MIT")
(316 real changes made)
replace top_phd5=1 if strpos(PhDInstitution5, "Massachusetts Institute of Technology") | strpos(PhDInstitution5, "MIT")
(0 real changes made)
replace top_phd6=1 if strpos(PhDInstitution6, "Massachusetts Institute of Technology") | strpos(PhDInstitution6, "MIT")
(0 real changes made)
replace top_phd7=1 if strpos(PhDInstitution7, "Massachusetts Institute of Technology") | strpos(PhDInstitution7, "MIT")
(0 real changes made)
replace top_phd8=1 if strpos(PhDInstitution8, "Massachusetts Institute of Technology") | strpos(PhDInstitution8, "MIT")
(0 real changes made)
replace top_phd9=1 if strpos(PhDInstitution9, "Massachusetts Institute of Technology") | strpos(PhDInstitution9, "MIT")
(0 real changes made)
replace top_phd10=1 if strpos(PhDInstitution10, "Massachusetts Institute of Technology") | strpos(PhDInstitution10, "MIT")
(0 real changes made)
replace top_phd11=1 if strpos(PhDInstitution11, "Massachusetts Institute of Technology") | strpos(PhDInstitution11, "MIT")
(0 real changes made)
|
▼ | 280 |
replace top_phd`i'=1 if strpos(PhDInstitution`i', "Berkeley")
replace top_phd1=1 if strpos(PhDInstitution1, "Berkeley")
(1,139 real changes made)
replace top_phd2=1 if strpos(PhDInstitution2, "Berkeley")
(896 real changes made)
replace top_phd3=1 if strpos(PhDInstitution3, "Berkeley")
(549 real changes made)
replace top_phd4=1 if strpos(PhDInstitution4, "Berkeley")
(94 real changes made)
replace top_phd5=1 if strpos(PhDInstitution5, "Berkeley")
(292 real changes made)
replace top_phd6=1 if strpos(PhDInstitution6, "Berkeley")
(0 real changes made)
replace top_phd7=1 if strpos(PhDInstitution7, "Berkeley")
(0 real changes made)
replace top_phd8=1 if strpos(PhDInstitution8, "Berkeley")
(0 real changes made)
replace top_phd9=1 if strpos(PhDInstitution9, "Berkeley")
(0 real changes made)
replace top_phd10=1 if strpos(PhDInstitution10, "Berkeley")
(0 real changes made)
replace top_phd11=1 if strpos(PhDInstitution11, "Berkeley")
(0 real changes made)
|
▼ | 281 |
replace top_phd`i'=1 if strpos(PhDInstitution`i', "University of Chicago")
replace top_phd1=1 if strpos(PhDInstitution1, "University of Chicago")
(560 real changes made)
replace top_phd2=1 if strpos(PhDInstitution2, "University of Chicago")
(306 real changes made)
replace top_phd3=1 if strpos(PhDInstitution3, "University of Chicago")
(71 real changes made)
replace top_phd4=1 if strpos(PhDInstitution4, "University of Chicago")
(0 real changes made)
replace top_phd5=1 if strpos(PhDInstitution5, "University of Chicago")
(0 real changes made)
replace top_phd6=1 if strpos(PhDInstitution6, "University of Chicago")
(0 real changes made)
replace top_phd7=1 if strpos(PhDInstitution7, "University of Chicago")
(0 real changes made)
replace top_phd8=1 if strpos(PhDInstitution8, "University of Chicago")
(0 real changes made)
replace top_phd9=1 if strpos(PhDInstitution9, "University of Chicago")
(0 real changes made)
replace top_phd10=1 if strpos(PhDInstitution10, "University of Chicago")
(0 real changes made)
replace top_phd11=1 if strpos(PhDInstitution11, "University of Chicago")
(0 real changes made)
|
▼ | 282 |
replace top_phd`i'=1 if strpos(PhDInstitution`i', "Paris School of Economics") | strpos(PhDInstitution`i', "PSE")
replace top_phd1=1 if strpos(PhDInstitution1, "Paris School of Economics") | strpos(PhDInstitution1, "PSE")
(376 real changes made)
replace top_phd2=1 if strpos(PhDInstitution2, "Paris School of Economics") | strpos(PhDInstitution2, "PSE")
(564 real changes made)
replace top_phd3=1 if strpos(PhDInstitution3, "Paris School of Economics") | strpos(PhDInstitution3, "PSE")
(105 real changes made)
replace top_phd4=1 if strpos(PhDInstitution4, "Paris School of Economics") | strpos(PhDInstitution4, "PSE")
(52 real changes made)
replace top_phd5=1 if strpos(PhDInstitution5, "Paris School of Economics") | strpos(PhDInstitution5, "PSE")
(52 real changes made)
replace top_phd6=1 if strpos(PhDInstitution6, "Paris School of Economics") | strpos(PhDInstitution6, "PSE")
(0 real changes made)
replace top_phd7=1 if strpos(PhDInstitution7, "Paris School of Economics") | strpos(PhDInstitution7, "PSE")
(0 real changes made)
replace top_phd8=1 if strpos(PhDInstitution8, "Paris School of Economics") | strpos(PhDInstitution8, "PSE")
(0 real changes made)
replace top_phd9=1 if strpos(PhDInstitution9, "Paris School of Economics") | strpos(PhDInstitution9, "PSE")
(0 real changes made)
replace top_phd10=1 if strpos(PhDInstitution10, "Paris School of Economics") | strpos(PhDInstitution10, "PSE")
(0 real changes made)
replace top_phd11=1 if strpos(PhDInstitution11, "Paris School of Economics") | strpos(PhDInstitution11, "PSE")
(0 real changes made)
|
▼ | 283 |
replace top_phd`i'=1 if strpos(PhDInstitution`i', "Princeton University")
replace top_phd1=1 if strpos(PhDInstitution1, "Princeton University")
(32 real changes made)
replace top_phd2=1 if strpos(PhDInstitution2, "Princeton University")
(219 real changes made)
replace top_phd3=1 if strpos(PhDInstitution3, "Princeton University")
(227 real changes made)
replace top_phd4=1 if strpos(PhDInstitution4, "Princeton University")
(6 real changes made)
replace top_phd5=1 if strpos(PhDInstitution5, "Princeton University")
(0 real changes made)
replace top_phd6=1 if strpos(PhDInstitution6, "Princeton University")
(0 real changes made)
replace top_phd7=1 if strpos(PhDInstitution7, "Princeton University")
(0 real changes made)
replace top_phd8=1 if strpos(PhDInstitution8, "Princeton University")
(0 real changes made)
replace top_phd9=1 if strpos(PhDInstitution9, "Princeton University")
(0 real changes made)
replace top_phd10=1 if strpos(PhDInstitution10, "Princeton University")
(0 real changes made)
replace top_phd11=1 if strpos(PhDInstitution11, "Princeton University")
(0 real changes made)
|
▼ | 284 |
replace top_phd`i'=1 if strpos(PhDInstitution`i', "Stanford University")
replace top_phd1=1 if strpos(PhDInstitution1, "Stanford University")
(310 real changes made)
replace top_phd2=1 if strpos(PhDInstitution2, "Stanford University")
(163 real changes made)
replace top_phd3=1 if strpos(PhDInstitution3, "Stanford University")
(127 real changes made)
replace top_phd4=1 if strpos(PhDInstitution4, "Stanford University")
(36 real changes made)
replace top_phd5=1 if strpos(PhDInstitution5, "Stanford University")
(0 real changes made)
replace top_phd6=1 if strpos(PhDInstitution6, "Stanford University")
(0 real changes made)
replace top_phd7=1 if strpos(PhDInstitution7, "Stanford University")
(0 real changes made)
replace top_phd8=1 if strpos(PhDInstitution8, "Stanford University")
(0 real changes made)
replace top_phd9=1 if strpos(PhDInstitution9, "Stanford University")
(0 real changes made)
replace top_phd10=1 if strpos(PhDInstitution10, "Stanford University")
(0 real changes made)
replace top_phd11=1 if strpos(PhDInstitution11, "Stanford University")
(0 real changes made)
|
▼ | 285 |
replace top_phd`i'=1 if strpos(PhDInstitution`i', "Oxford University")
replace top_phd1=1 if strpos(PhDInstitution1, "Oxford University")
(79 real changes made)
replace top_phd2=1 if strpos(PhDInstitution2, "Oxford University")
(135 real changes made)
replace top_phd3=1 if strpos(PhDInstitution3, "Oxford University")
(0 real changes made)
replace top_phd4=1 if strpos(PhDInstitution4, "Oxford University")
(59 real changes made)
replace top_phd5=1 if strpos(PhDInstitution5, "Oxford University")
(67 real changes made)
replace top_phd6=1 if strpos(PhDInstitution6, "Oxford University")
(0 real changes made)
replace top_phd7=1 if strpos(PhDInstitution7, "Oxford University")
(0 real changes made)
replace top_phd8=1 if strpos(PhDInstitution8, "Oxford University")
(0 real changes made)
replace top_phd9=1 if strpos(PhDInstitution9, "Oxford University")
(0 real changes made)
replace top_phd10=1 if strpos(PhDInstitution10, "Oxford University")
(0 real changes made)
replace top_phd11=1 if strpos(PhDInstitution11, "Oxford University")
(0 real changes made)
|
▼ | 286 |
replace top_phd`i'=1 if strpos(PhDInstitution`i', "Toulouse School of Economics") | strpos(PhDInstitution`i', "TSE")
replace top_phd1=1 if strpos(PhDInstitution1, "Toulouse School of Economics") | strpos(PhDInstitution1, "TSE")
(35 real changes made)
replace top_phd2=1 if strpos(PhDInstitution2, "Toulouse School of Economics") | strpos(PhDInstitution2, "TSE")
(0 real changes made)
replace top_phd3=1 if strpos(PhDInstitution3, "Toulouse School of Economics") | strpos(PhDInstitution3, "TSE")
(0 real changes made)
replace top_phd4=1 if strpos(PhDInstitution4, "Toulouse School of Economics") | strpos(PhDInstitution4, "TSE")
(18 real changes made)
replace top_phd5=1 if strpos(PhDInstitution5, "Toulouse School of Economics") | strpos(PhDInstitution5, "TSE")
(0 real changes made)
replace top_phd6=1 if strpos(PhDInstitution6, "Toulouse School of Economics") | strpos(PhDInstitution6, "TSE")
(0 real changes made)
replace top_phd7=1 if strpos(PhDInstitution7, "Toulouse School of Economics") | strpos(PhDInstitution7, "TSE")
(0 real changes made)
replace top_phd8=1 if strpos(PhDInstitution8, "Toulouse School of Economics") | strpos(PhDInstitution8, "TSE")
(0 real changes made)
replace top_phd9=1 if strpos(PhDInstitution9, "Toulouse School of Economics") | strpos(PhDInstitution9, "TSE")
(0 real changes made)
replace top_phd10=1 if strpos(PhDInstitution10, "Toulouse School of Economics") | strpos(PhDInstitution10, "TSE")
(0 real changes made)
replace top_phd11=1 if strpos(PhDInstitution11, "Toulouse School of Economics") | strpos(PhDInstitution11, "TSE")
(0 real changes made)
|
▼ | 287 |
replace top_phd`i'=1 if strpos(PhDInstitution`i', "Columbia University")
replace top_phd1=1 if strpos(PhDInstitution1, "Columbia University")
(163 real changes made)
replace top_phd2=1 if strpos(PhDInstitution2, "Columbia University")
(97 real changes made)
replace top_phd3=1 if strpos(PhDInstitution3, "Columbia University")
(272 real changes made)
replace top_phd4=1 if strpos(PhDInstitution4, "Columbia University")
(113 real changes made)
replace top_phd5=1 if strpos(PhDInstitution5, "Columbia University")
(256 real changes made)
replace top_phd6=1 if strpos(PhDInstitution6, "Columbia University")
(0 real changes made)
replace top_phd7=1 if strpos(PhDInstitution7, "Columbia University")
(0 real changes made)
replace top_phd8=1 if strpos(PhDInstitution8, "Columbia University")
(0 real changes made)
replace top_phd9=1 if strpos(PhDInstitution9, "Columbia University")
(0 real changes made)
replace top_phd10=1 if strpos(PhDInstitution10, "Columbia University")
(0 real changes made)
replace top_phd11=1 if strpos(PhDInstitution11, "Columbia University")
(0 real changes made)
|
▼ | 288 |
replace top_phd`i'=1 if strpos(PhDInstitution`i', "New York University") | strpos(PhDInstitution`i', "NYU")
replace top_phd1=1 if strpos(PhDInstitution1, "New York University") | strpos(PhDInstitution1, "NYU")
(233 real changes made)
replace top_phd2=1 if strpos(PhDInstitution2, "New York University") | strpos(PhDInstitution2, "NYU")
(50 real changes made)
replace top_phd3=1 if strpos(PhDInstitution3, "New York University") | strpos(PhDInstitution3, "NYU")
(358 real changes made)
replace top_phd4=1 if strpos(PhDInstitution4, "New York University") | strpos(PhDInstitution4, "NYU")
(1 real change made)
replace top_phd5=1 if strpos(PhDInstitution5, "New York University") | strpos(PhDInstitution5, "NYU")
(6 real changes made)
replace top_phd6=1 if strpos(PhDInstitution6, "New York University") | strpos(PhDInstitution6, "NYU")
(0 real changes made)
replace top_phd7=1 if strpos(PhDInstitution7, "New York University") | strpos(PhDInstitution7, "NYU")
(0 real changes made)
replace top_phd8=1 if strpos(PhDInstitution8, "New York University") | strpos(PhDInstitution8, "NYU")
(0 real changes made)
replace top_phd9=1 if strpos(PhDInstitution9, "New York University") | strpos(PhDInstitution9, "NYU")
(0 real changes made)
replace top_phd10=1 if strpos(PhDInstitution10, "New York University") | strpos(PhDInstitution10, "NYU")
(0 real changes made)
replace top_phd11=1 if strpos(PhDInstitution11, "New York University") | strpos(PhDInstitution11, "NYU")
(0 real changes made)
|
▼ | 289 |
replace top_phd`i'=1 if strpos(PhDInstitution`i', "Yale University")
replace top_phd1=1 if strpos(PhDInstitution1, "Yale University")
(217 real changes made)
replace top_phd2=1 if strpos(PhDInstitution2, "Yale University")
(309 real changes made)
replace top_phd3=1 if strpos(PhDInstitution3, "Yale University")
(58 real changes made)
replace top_phd4=1 if strpos(PhDInstitution4, "Yale University")
(8 real changes made)
replace top_phd5=1 if strpos(PhDInstitution5, "Yale University")
(0 real changes made)
replace top_phd6=1 if strpos(PhDInstitution6, "Yale University")
(0 real changes made)
replace top_phd7=1 if strpos(PhDInstitution7, "Yale University")
(0 real changes made)
replace top_phd8=1 if strpos(PhDInstitution8, "Yale University")
(0 real changes made)
replace top_phd9=1 if strpos(PhDInstitution9, "Yale University")
(0 real changes made)
replace top_phd10=1 if strpos(PhDInstitution10, "Yale University")
(0 real changes made)
replace top_phd11=1 if strpos(PhDInstitution11, "Yale University")
(0 real changes made)
|
▼ | 290 |
replace top_phd`i'=1 if strpos(PhDInstitution`i', "Boston University")
replace top_phd1=1 if strpos(PhDInstitution1, "Boston University")
(82 real changes made)
replace top_phd2=1 if strpos(PhDInstitution2, "Boston University")
(144 real changes made)
replace top_phd3=1 if strpos(PhDInstitution3, "Boston University")
(67 real changes made)
replace top_phd4=1 if strpos(PhDInstitution4, "Boston University")
(20 real changes made)
replace top_phd5=1 if strpos(PhDInstitution5, "Boston University")
(0 real changes made)
replace top_phd6=1 if strpos(PhDInstitution6, "Boston University")
(0 real changes made)
replace top_phd7=1 if strpos(PhDInstitution7, "Boston University")
(0 real changes made)
replace top_phd8=1 if strpos(PhDInstitution8, "Boston University")
(0 real changes made)
replace top_phd9=1 if strpos(PhDInstitution9, "Boston University")
(0 real changes made)
replace top_phd10=1 if strpos(PhDInstitution10, "Boston University")
(0 real changes made)
replace top_phd11=1 if strpos(PhDInstitution11, "Boston University")
(0 real changes made)
|
▼ | 291 |
replace top_phd`i'=1 if strpos(PhDInstitution`i', "Barcelona Graduate School of Economics") | strpos(PhDInstitution`i', "Barcelona GSE")
replace top_phd1=1 if strpos(PhDInstitution1, "Barcelona Graduate School of Economics") | strpos(PhDInstitution1, "Barcelona GSE")
(0 real changes made)
replace top_phd2=1 if strpos(PhDInstitution2, "Barcelona Graduate School of Economics") | strpos(PhDInstitution2, "Barcelona GSE")
(0 real changes made)
replace top_phd3=1 if strpos(PhDInstitution3, "Barcelona Graduate School of Economics") | strpos(PhDInstitution3, "Barcelona GSE")
(0 real changes made)
replace top_phd4=1 if strpos(PhDInstitution4, "Barcelona Graduate School of Economics") | strpos(PhDInstitution4, "Barcelona GSE")
(0 real changes made)
replace top_phd5=1 if strpos(PhDInstitution5, "Barcelona Graduate School of Economics") | strpos(PhDInstitution5, "Barcelona GSE")
(0 real changes made)
replace top_phd6=1 if strpos(PhDInstitution6, "Barcelona Graduate School of Economics") | strpos(PhDInstitution6, "Barcelona GSE")
(0 real changes made)
replace top_phd7=1 if strpos(PhDInstitution7, "Barcelona Graduate School of Economics") | strpos(PhDInstitution7, "Barcelona GSE")
(0 real changes made)
replace top_phd8=1 if strpos(PhDInstitution8, "Barcelona Graduate School of Economics") | strpos(PhDInstitution8, "Barcelona GSE")
(0 real changes made)
replace top_phd9=1 if strpos(PhDInstitution9, "Barcelona Graduate School of Economics") | strpos(PhDInstitution9, "Barcelona GSE")
(0 real changes made)
replace top_phd10=1 if strpos(PhDInstitution10, "Barcelona Graduate School of Economics") | strpos(PhDInstitution10, "Barcelona GSE")
(0 real changes made)
replace top_phd11=1 if strpos(PhDInstitution11, "Barcelona Graduate School of Economics") | strpos(PhDInstitution11, "Barcelona GSE")
(0 real changes made)
|
▼ | 292 |
replace top_phd`i'=1 if strpos(PhDInstitution`i', "University of California-San Diego") | strpos(PhDInstitution`i', "UCSD")
replace top_phd1=1 if strpos(PhDInstitution1, "University of California-San Diego") | strpos(PhDInstitution1, "UCSD")
(140 real changes made)
replace top_phd2=1 if strpos(PhDInstitution2, "University of California-San Diego") | strpos(PhDInstitution2, "UCSD")
(6 real changes made)
replace top_phd3=1 if strpos(PhDInstitution3, "University of California-San Diego") | strpos(PhDInstitution3, "UCSD")
(51 real changes made)
replace top_phd4=1 if strpos(PhDInstitution4, "University of California-San Diego") | strpos(PhDInstitution4, "UCSD")
(0 real changes made)
replace top_phd5=1 if strpos(PhDInstitution5, "University of California-San Diego") | strpos(PhDInstitution5, "UCSD")
(0 real changes made)
replace top_phd6=1 if strpos(PhDInstitution6, "University of California-San Diego") | strpos(PhDInstitution6, "UCSD")
(0 real changes made)
replace top_phd7=1 if strpos(PhDInstitution7, "University of California-San Diego") | strpos(PhDInstitution7, "UCSD")
(0 real changes made)
replace top_phd8=1 if strpos(PhDInstitution8, "University of California-San Diego") | strpos(PhDInstitution8, "UCSD")
(0 real changes made)
replace top_phd9=1 if strpos(PhDInstitution9, "University of California-San Diego") | strpos(PhDInstitution9, "UCSD")
(0 real changes made)
replace top_phd10=1 if strpos(PhDInstitution10, "University of California-San Diego") | strpos(PhDInstitution10, "UCSD")
(0 real changes made)
replace top_phd11=1 if strpos(PhDInstitution11, "University of California-San Diego") | strpos(PhDInstitution11, "UCSD")
(0 real changes made)
|
▼ | 293 |
replace top_phd`i'=1 if strpos(PhDInstitution`i', "Dartmouth College")
replace top_phd1=1 if strpos(PhDInstitution1, "Dartmouth College")
(0 real changes made)
replace top_phd2=1 if strpos(PhDInstitution2, "Dartmouth College")
(0 real changes made)
replace top_phd3=1 if strpos(PhDInstitution3, "Dartmouth College")
(0 real changes made)
replace top_phd4=1 if strpos(PhDInstitution4, "Dartmouth College")
(0 real changes made)
replace top_phd5=1 if strpos(PhDInstitution5, "Dartmouth College")
(0 real changes made)
replace top_phd6=1 if strpos(PhDInstitution6, "Dartmouth College")
(0 real changes made)
replace top_phd7=1 if strpos(PhDInstitution7, "Dartmouth College")
(0 real changes made)
replace top_phd8=1 if strpos(PhDInstitution8, "Dartmouth College")
(0 real changes made)
replace top_phd9=1 if strpos(PhDInstitution9, "Dartmouth College")
(0 real changes made)
replace top_phd10=1 if strpos(PhDInstitution10, "Dartmouth College")
(0 real changes made)
replace top_phd11=1 if strpos(PhDInstitution11, "Dartmouth College")
(0 real changes made)
|
▼ | 294 |
replace top_phd`i'=1 if strpos(PhDInstitution`i', "University of Pennsylvania")
replace top_phd1=1 if strpos(PhDInstitution1, "University of Pennsylvania")
(165 real changes made)
replace top_phd2=1 if strpos(PhDInstitution2, "University of Pennsylvania")
(5 real changes made)
replace top_phd3=1 if strpos(PhDInstitution3, "University of Pennsylvania")
(192 real changes made)
replace top_phd4=1 if strpos(PhDInstitution4, "University of Pennsylvania")
(0 real changes made)
replace top_phd5=1 if strpos(PhDInstitution5, "University of Pennsylvania")
(0 real changes made)
replace top_phd6=1 if strpos(PhDInstitution6, "University of Pennsylvania")
(0 real changes made)
replace top_phd7=1 if strpos(PhDInstitution7, "University of Pennsylvania")
(0 real changes made)
replace top_phd8=1 if strpos(PhDInstitution8, "University of Pennsylvania")
(0 real changes made)
replace top_phd9=1 if strpos(PhDInstitution9, "University of Pennsylvania")
(0 real changes made)
replace top_phd10=1 if strpos(PhDInstitution10, "University of Pennsylvania")
(0 real changes made)
replace top_phd11=1 if strpos(PhDInstitution11, "University of Pennsylvania")
(0 real changes made)
|
▼ | 295 |
replace top_phd`i'=1 if strpos(PhDInstitution`i', "University College London") | strpos(PhDInstitution`i', "UCL")
replace top_phd1=1 if strpos(PhDInstitution1, "University College London") | strpos(PhDInstitution1, "UCL")
(293 real changes made)
replace top_phd2=1 if strpos(PhDInstitution2, "University College London") | strpos(PhDInstitution2, "UCL")
(265 real changes made)
replace top_phd3=1 if strpos(PhDInstitution3, "University College London") | strpos(PhDInstitution3, "UCL")
(104 real changes made)
replace top_phd4=1 if strpos(PhDInstitution4, "University College London") | strpos(PhDInstitution4, "UCL")
(77 real changes made)
replace top_phd5=1 if strpos(PhDInstitution5, "University College London") | strpos(PhDInstitution5, "UCL")
(71 real changes made)
replace top_phd6=1 if strpos(PhDInstitution6, "University College London") | strpos(PhDInstitution6, "UCL")
(0 real changes made)
replace top_phd7=1 if strpos(PhDInstitution7, "University College London") | strpos(PhDInstitution7, "UCL")
(0 real changes made)
replace top_phd8=1 if strpos(PhDInstitution8, "University College London") | strpos(PhDInstitution8, "UCL")
(0 real changes made)
replace top_phd9=1 if strpos(PhDInstitution9, "University College London") | strpos(PhDInstitution9, "UCL")
(0 real changes made)
replace top_phd10=1 if strpos(PhDInstitution10, "University College London") | strpos(PhDInstitution10, "UCL")
(0 real changes made)
replace top_phd11=1 if strpos(PhDInstitution11, "University College London") | strpos(PhDInstitution11, "UCL")
(0 real changes made)
|
▼ | 296 |
replace top_phd`i'=1 if strpos(PhDInstitution`i', "Northwestern University")
replace top_phd1=1 if strpos(PhDInstitution1, "Northwestern University")
(0 real changes made)
replace top_phd2=1 if strpos(PhDInstitution2, "Northwestern University")
(72 real changes made)
replace top_phd3=1 if strpos(PhDInstitution3, "Northwestern University")
(12 real changes made)
replace top_phd4=1 if strpos(PhDInstitution4, "Northwestern University")
(12 real changes made)
replace top_phd5=1 if strpos(PhDInstitution5, "Northwestern University")
(0 real changes made)
replace top_phd6=1 if strpos(PhDInstitution6, "Northwestern University")
(0 real changes made)
replace top_phd7=1 if strpos(PhDInstitution7, "Northwestern University")
(0 real changes made)
replace top_phd8=1 if strpos(PhDInstitution8, "Northwestern University")
(0 real changes made)
replace top_phd9=1 if strpos(PhDInstitution9, "Northwestern University")
(0 real changes made)
replace top_phd10=1 if strpos(PhDInstitution10, "Northwestern University")
(0 real changes made)
replace top_phd11=1 if strpos(PhDInstitution11, "Northwestern University")
(0 real changes made)
|
▼ | 297 |
replace top_phd`i'=1 if strpos(PhDInstitution`i', "Columbia University")
replace top_phd1=1 if strpos(PhDInstitution1, "Columbia University")
(0 real changes made)
replace top_phd2=1 if strpos(PhDInstitution2, "Columbia University")
(0 real changes made)
replace top_phd3=1 if strpos(PhDInstitution3, "Columbia University")
(0 real changes made)
replace top_phd4=1 if strpos(PhDInstitution4, "Columbia University")
(0 real changes made)
replace top_phd5=1 if strpos(PhDInstitution5, "Columbia University")
(0 real changes made)
replace top_phd6=1 if strpos(PhDInstitution6, "Columbia University")
(0 real changes made)
replace top_phd7=1 if strpos(PhDInstitution7, "Columbia University")
(0 real changes made)
replace top_phd8=1 if strpos(PhDInstitution8, "Columbia University")
(0 real changes made)
replace top_phd9=1 if strpos(PhDInstitution9, "Columbia University")
(0 real changes made)
replace top_phd10=1 if strpos(PhDInstitution10, "Columbia University")
(0 real changes made)
replace top_phd11=1 if strpos(PhDInstitution11, "Columbia University")
(0 real changes made)
|
▼ | 298 |
replace top_phd`i'=1 if strpos(PhDInstitution`i', "University of California-Los Angeles ") | strpos(PhDInstitution`i', "UCLA")
replace top_phd1=1 if strpos(PhDInstitution1, "University of California-Los Angeles ") | strpos(PhDInstitution1, "UCLA")
(0 real changes made)
replace top_phd2=1 if strpos(PhDInstitution2, "University of California-Los Angeles ") | strpos(PhDInstitution2, "UCLA")
(0 real changes made)
replace top_phd3=1 if strpos(PhDInstitution3, "University of California-Los Angeles ") | strpos(PhDInstitution3, "UCLA")
(0 real changes made)
replace top_phd4=1 if strpos(PhDInstitution4, "University of California-Los Angeles ") | strpos(PhDInstitution4, "UCLA")
(0 real changes made)
replace top_phd5=1 if strpos(PhDInstitution5, "University of California-Los Angeles ") | strpos(PhDInstitution5, "UCLA")
(0 real changes made)
replace top_phd6=1 if strpos(PhDInstitution6, "University of California-Los Angeles ") | strpos(PhDInstitution6, "UCLA")
(0 real changes made)
replace top_phd7=1 if strpos(PhDInstitution7, "University of California-Los Angeles ") | strpos(PhDInstitution7, "UCLA")
(0 real changes made)
replace top_phd8=1 if strpos(PhDInstitution8, "University of California-Los Angeles ") | strpos(PhDInstitution8, "UCLA")
(0 real changes made)
replace top_phd9=1 if strpos(PhDInstitution9, "University of California-Los Angeles ") | strpos(PhDInstitution9, "UCLA")
(0 real changes made)
replace top_phd10=1 if strpos(PhDInstitution10, "University of California-Los Angeles ") | strpos(PhDInstitution10, "UCLA")
(0 real changes made)
replace top_phd11=1 if strpos(PhDInstitution11, "University of California-Los Angeles ") | strpos(PhDInstitution11, "UCLA")
(0 real changes made)
|
▼ | 299 |
replace top_phd`i'=1 if strpos(PhDInstitution`i', "London School of Economics") | strpos(PhDInstitution`i', "LSE")
replace top_phd1=1 if strpos(PhDInstitution1, "London School of Economics") | strpos(PhDInstitution1, "LSE")
(715 real changes made)
replace top_phd2=1 if strpos(PhDInstitution2, "London School of Economics") | strpos(PhDInstitution2, "LSE")
(147 real changes made)
replace top_phd3=1 if strpos(PhDInstitution3, "London School of Economics") | strpos(PhDInstitution3, "LSE")
(289 real changes made)
replace top_phd4=1 if strpos(PhDInstitution4, "London School of Economics") | strpos(PhDInstitution4, "LSE")
(56 real changes made)
replace top_phd5=1 if strpos(PhDInstitution5, "London School of Economics") | strpos(PhDInstitution5, "LSE")
(0 real changes made)
replace top_phd6=1 if strpos(PhDInstitution6, "London School of Economics") | strpos(PhDInstitution6, "LSE")
(0 real changes made)
replace top_phd7=1 if strpos(PhDInstitution7, "London School of Economics") | strpos(PhDInstitution7, "LSE")
(0 real changes made)
replace top_phd8=1 if strpos(PhDInstitution8, "London School of Economics") | strpos(PhDInstitution8, "LSE")
(0 real changes made)
replace top_phd9=1 if strpos(PhDInstitution9, "London School of Economics") | strpos(PhDInstitution9, "LSE")
(0 real changes made)
replace top_phd10=1 if strpos(PhDInstitution10, "London School of Economics") | strpos(PhDInstitution10, "LSE")
(0 real changes made)
replace top_phd11=1 if strpos(PhDInstitution11, "London School of Economics") | strpos(PhDInstitution11, "LSE")
(0 real changes made)
|
▼ | 300 |
replace top_phd`i'=1 if strpos(PhDInstitution`i', "University of Wisconsin-Madison")
replace top_phd1=1 if strpos(PhDInstitution1, "University of Wisconsin-Madison")
(97 real changes made)
replace top_phd2=1 if strpos(PhDInstitution2, "University of Wisconsin-Madison")
(60 real changes made)
replace top_phd3=1 if strpos(PhDInstitution3, "University of Wisconsin-Madison")
(5 real changes made)
replace top_phd4=1 if strpos(PhDInstitution4, "University of Wisconsin-Madison")
(0 real changes made)
replace top_phd5=1 if strpos(PhDInstitution5, "University of Wisconsin-Madison")
(0 real changes made)
replace top_phd6=1 if strpos(PhDInstitution6, "University of Wisconsin-Madison")
(0 real changes made)
replace top_phd7=1 if strpos(PhDInstitution7, "University of Wisconsin-Madison")
(0 real changes made)
replace top_phd8=1 if strpos(PhDInstitution8, "University of Wisconsin-Madison")
(0 real changes made)
replace top_phd9=1 if strpos(PhDInstitution9, "University of Wisconsin-Madison")
(0 real changes made)
replace top_phd10=1 if strpos(PhDInstitution10, "University of Wisconsin-Madison")
(0 real changes made)
replace top_phd11=1 if strpos(PhDInstitution11, "University of Wisconsin-Madison")
(0 real changes made)
|
▼ | 301 |
replace top_phd`i'=1 if strpos(PhDInstitution`i', "University of Michigan")
replace top_phd1=1 if strpos(PhDInstitution1, "University of Michigan")
(227 real changes made)
replace top_phd2=1 if strpos(PhDInstitution2, "University of Michigan")
(201 real changes made)
replace top_phd3=1 if strpos(PhDInstitution3, "University of Michigan")
(57 real changes made)
replace top_phd4=1 if strpos(PhDInstitution4, "University of Michigan")
(6 real changes made)
replace top_phd5=1 if strpos(PhDInstitution5, "University of Michigan")
(0 real changes made)
replace top_phd6=1 if strpos(PhDInstitution6, "University of Michigan")
(0 real changes made)
replace top_phd7=1 if strpos(PhDInstitution7, "University of Michigan")
(0 real changes made)
replace top_phd8=1 if strpos(PhDInstitution8, "University of Michigan")
(0 real changes made)
replace top_phd9=1 if strpos(PhDInstitution9, "University of Michigan")
(0 real changes made)
replace top_phd10=1 if strpos(PhDInstitution10, "University of Michigan")
(0 real changes made)
replace top_phd11=1 if strpos(PhDInstitution11, "University of Michigan")
(0 real changes made)
|
| 302 |
}
|
| 303 |
|
▼ | 304 |
capture drop share_top_phd
. capture drop share_top_phd
.
|
▼ | 305 |
egen share_top_phd = rowmean(top_phd`i'*)
egen share_top_phd = rowmean(top_phd*)
. egen share_top_phd = rowmean(top_phd`i'*)
.
|
| 306 |
|
▼ | 307 |
capture drop min_table
. capture drop min_table
.
|
▼ | 308 |
capture drop main_table
. capture drop main_table
.
|
▼ | 309 |
egen min_table = min(table), by(journal_article_cluster)
. egen min_table = min(table), by(journal_article_cluster)
.
|
▼ | 310 |
gen main_table = .
. gen main_table = .
(21,740 missing values generated)
.
|
▼ | 311 |
replace main_table = 1 if min_table == table
. replace main_table = 1 if min_table == table
(7,049 real changes made)
.
|
| 312 |
|
▼ | 313 |
gen rct_registered=0 if RCT!=.
. gen rct_registered=0 if RCT!=.
.
|
▼ | 314 |
replace rct_registered=1 if rct_pre_registered==1
. replace rct_registered=1 if rct_pre_registered==1
(280 real changes made)
.
|
▼ | 315 |
destring registered, replace
. destring registered, replace
registered: all characters numeric; replaced as byte
(17574 missing values generated)
.
|
▼ | 316 |
replace rct_registered=1 if registered==1
. replace rct_registered=1 if registered==1
(1,012 real changes made)
.
|
| 317 |
|
▼ | 318 |
gen DID_graph=DID
|
▼ | 319 |
replace DID_graph=0 if graph_did==0
. replace DID_graph=0 if graph_did==0
(914 real changes made)
.
|
| 320 |
|
▼ | 321 |
gen ambiguous=0 if sign_5pct!=.
. gen ambiguous=0 if sign_5pct!=.
.
|
▼ | 322 |
replace ambiguous=1 if journal_name=="Journal of Urban Economics" & table==7 & article==7 & year==2018
replace ambiguous=1 if journal_name=="Journal of Urban Economics" & table==7 & article==7 & year==2018
. replace ambiguous=1 if journal_name=="Journal of Urban Eco
> nomics" & table==7 & article==7 & year==2018
(8 real changes made)
.
|
▼ | 323 |
replace ambiguous=1 if Not_sure_shouldbe_included=="1"
. replace ambiguous=1 if Not_sure_shouldbe_included=="1"
(160 real changes made)
.
|
▼ | 324 |
replace ambiguous=1 if ambig==1
. replace ambiguous=1 if ambig==1
(128 real changes made)
.
|
▼ | 325 |
replace ambiguous=1 if abelcomments=="This is an RCT, I would code differently"
replace ambiguous=1 if abelcomments=="This is an RCT, I would code differently"
. replace ambiguous=1 if abelcomments=="This is an RCT, I w
> ould code differently"
(33 real changes made)
.
|
▼ | 326 |
replace ambiguous=1 if abelcomments=="not sure which tables to select here"
replace ambiguous=1 if abelcomments=="not sure which tables to select here"
. replace ambiguous=1 if abelcomments=="not sure which table
> s to select here"
(6 real changes made)
.
|
▼ | 327 |
replace ambiguous=1 if drop==1
. replace ambiguous=1 if drop==1
(80 real changes made)
.
|
| 328 |
|
| 329 |
* keep only variables that are needed for further analyses
|
▼ | 330 |
keep t t_orig t_new t_new_string mu_orig mu_new mu_new_string sd_new sd_new_string sd_orig RCT DID IV RDD year unique_j experience_avg experience_avg_sq share_top_authors share_top_phd ireport authored_solo share_female_authors editor_present journal_article_cluster FINANCE MACRO_GROWTH GEN_INT EXP DEV LABOR PUB URB sign_5pct aw sign_10pct sign_1pct fstat journal title table method report article journal_name top5
keep t t_orig t_new t_new_string mu_orig mu_new mu_new_string sd_new sd_new_string sd_orig RCT DID IV RDD year unique_j experience_avg experience_avg_sq share_top_authors share_top_phd ireport authored_solo share_female_authors editor_present journal_article_cluster FINANCE MACRO_GROWTH GEN_INT EXP DEV LABOR PUB URB sign_5pct aw sign_10pct sign_1pct fstat journal title table method report article journal_name top5
. keep t t_orig t_new t_new_string mu_orig mu_new mu_new_str
> ing sd_new sd_new_string sd_orig RCT DID IV RDD year unique_j experience_avg
> experience_avg_sq share_top_authors share_top_phd ireport authored_solo share
> _female_authors editor_present journal_article_cluster FINANCE MACRO_GROWTH G
> EN_INT EXP DEV LABOR PUB URB sign_5pct aw sign_10pct sign_1pct fstat journal
> title table method report article journal_name top5
.
|
| 331 |
|
| 332 |
* label variables that have no label
|
▼ | 333 |
label variable year "Year"
. label variable year "Year"
.
|
▼ | 334 |
label variable top5 "Published in Top 5 journal"
. label variable top5 "Published in Top 5 journal"
.
|
▼ | 335 |
label variable sign_5pct "significant at 5% level"
. label variable sign_5pct "significant at 5% level"
.
|
▼ | 336 |
label variable sign_1pct "significant at 1% level"
. label variable sign_1pct "significant at 1% level"
.
|
▼ | 337 |
label variable sign_10pct "significant at 10% level"
. label variable sign_10pct "significant at 10% level"
.
|
▼ | 338 |
label variable share_top_authors "share of authors share of authors affiliated with top institutions"
label variable share_top_authors "share of authors share of authors affiliated with top institutions"
. label variable share_top_authors "share of authors share o
> f authors affiliated with top institutions"
.
|
▼ | 339 |
label variable share_top_phd "share of authors who completed a PhD at a top institution"
label variable share_top_phd "share of authors who completed a PhD at a top institution"
. label variable share_top_phd "share of authors who complet
> ed a PhD at a top institution"
.
|
▼ | 340 |
label variable share_female_authors "share of female authors"
label variable share_female_authors "share of female authors"
. label variable share_female_authors "share of female autho
> rs"
.
|
▼ | 341 |
label variable journal "Journal"
. label variable journal "Journal"
.
|
▼ | 342 |
label variable journal_article_cluster "Article ID"
. label variable journal_article_cluster "Article ID"
.
|
▼ | 343 |
label variable experience_avg "Average experience since authors' phds in years"
label variable experience_avg "Average experience since authors' phds in years"
. label variable experience_avg "Average experience since au
> thors' phds in years"
.
|
▼ | 344 |
label variable experience_avg_sq "Average experience since authors' phds in years (squared)"
label variable experience_avg_sq "Average experience since authors' phds in years (squared)"
. label variable experience_avg_sq "Average experience since
> authors' phds in years (squared)"
.
|
▼ | 345 |
label variable editor_present "Editor of an economic journal among authors"
label variable editor_present "Editor of an economic journal among authors"
. label variable editor_present "Editor of an economic journ
> al among authors"
.
|
▼ | 346 |
label variable aw "Weights mapping the inverse number of tests per article"
label variable aw "Weights mapping the inverse number of tests per article"
. label variable aw "Weights mapping the inverse number of t
> ests per article"
.
|
▼ | 347 |
label variable authored_solo "Solo authorship"
. label variable authored_solo "Solo authorship"
.
|
▼ | 348 |
label variable DEV "Field: Development Economics"
. label variable DEV "Field: Development Economics"
.
|
▼ | 349 |
label variable URB "Field: Urban Economics"
. label variable URB "Field: Urban Economics"
.
|
▼ | 350 |
label variable FINANCE "Field: Finance"
. label variable FINANCE "Field: Finance"
.
|
▼ | 351 |
label variable LABOR "Field: Labor Economics"
. label variable LABOR "Field: Labor Economics"
.
|
▼ | 352 |
label variable PUB "Field: Public Economics"
. label variable PUB "Field: Public Economics"
.
|
▼ | 353 |
label variable MACRO_GROWTH "Field: Macroeconomics "
. label variable MACRO_GROWTH "Field: Macroeconomics "
.
|
▼ | 354 |
label variable GEN_INT "Field: General Interest"
. label variable GEN_INT "Field: General Interest"
.
|
▼ | 355 |
label variable EXP "Field: Experimental Economics"
. label variable EXP "Field: Experimental Economics"
.
|
▼ | 356 |
label variable DID "Method: Difference-in-Differences"
. label variable DID "Method: Difference-in-Differences"
.
|
▼ | 357 |
label variable IV "Method: Instrumental Variables"
. label variable IV "Method: Instrumental Variables"
.
|
▼ | 358 |
label variable RDD "Method: Regression Discontinuity Design"
label variable RDD "Method: Regression Discontinuity Design"
. label variable RDD "Method: Regression Discontinuity Desig
> n"
.
|
▼ | 359 |
label variable RCT "Method: Randomized Control Trial"
. label variable RCT "Method: Randomized Control Trial"
.
|
▼ | 360 |
label variable report "Which statistics reported"
. label variable report "Which statistics reported"
.
|
▼ | 361 |
label variable ireport "Which statistics reported"
. label variable ireport "Which statistics reported"
.
|
| 362 |
|
▼ | 363 |
saveold mm_data_ready, replace
. saveold mm_data_ready, replace
(saving in Stata 13 format)
(FYI, saveold has options version(12) and version(11) that write files in
older Stata formats)
file mm_data_ready.dta saved
.
|