-------------
      name:  <unnamed>
       log:  C:\D\projekte\Replication McCabe_Snyder\McCabe_Snyder_ReStat_Table_5.smcl
  log type:  smcl
 opened on:  24 Mar 2017, 11:39:39

.
. **********************************************************************
. *
. * Program McCabe_Snyder_ReStat_Table_5.DO
. *
. * Computes descriptive statistics for self-archiving of pre-prints
. * in Table 5. Uses information collected by research assistants on
. * subsample of 1,500 articles.
. *
. * McCabe & Snyder August 2013
. *
. **********************************************************************
.
. * Set initial Stata parameters
. version 12

. set more 1

.
. use McCabe_Snyder_ReStat_archiving

.
. gen pre_archive = (pre_nber_ind + pre_cepr_ind + pre_ssrn_ind + pre_repec_ind + pre_inst_ind) > 0

. gen pre_sole = (pre_nber_ind + pre_cepr_ind + pre_ssrn_ind + pre_repec_ind + pre_inst_ind) == 1

. gen post_archive = (post_nber_ind + post_cepr_ind + post_ssrn_ind + post_repec_ind + post_inst_ind) > 0

. gen post_sole = (post_nber_ind + post_cepr_ind + post_ssrn_ind + post_repec_ind + post_inst_ind) == 1

.
. * Columns for percent in repository
.
. sort pyear

. by pyear: summ pre_*_ind pre_archive

-------------
-> pyear = 1995

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
pre_nber_ind |        283    .0318021    .1757838          0          1
pre_cepr_ind |        283    .0212014    .1443104          0          1
pre_ssrn_ind |        283           0           0          0          0
pre_repec_~d |        283    .0424028    .2018634          0          1
pre_inst_ind |        283    .1024735    .3038072          0          1
-------------+---------------------------------------------------------
 pre_archive |        283     .155477    .3630007          0          1

-------------
-> pyear = 2000

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
pre_nber_ind |        305    .0622951    .2420879          0          1
pre_cepr_ind |        305    .0163934    .1271917          0          1
pre_ssrn_ind |        305          .2    .4006574          0          1
pre_repec_~d |        305    .0098361    .0988502          0          1
pre_inst_ind |        305    .2229508    .4169096          0          1
-------------+---------------------------------------------------------
 pre_archive |        305     .347541    .4769719          0          1

-------------
-> pyear = 2005

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
pre_nber_ind |        315    .0634921    .2442339          0          1
pre_cepr_ind |        315     .015873    .1251831          0          1
pre_ssrn_ind |        315    .3269841    .4698578          0          1
pre_repec_~d |        315           0           0          0          0
pre_inst_ind |        315    .3968254    .4900176          0          1
-------------+---------------------------------------------------------
 pre_archive |        315    .5333333    .4996814          0          1


. by pyear: summ post_*_ind post_archive

-------------
-> pyear = 1995

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
post_nber_~d |        283    .0035336    .0594438          0          1
post_cepr_~d |        283           0           0          0          0
post_ssrn_~d |        283    .0565371    .2313651          0          1
post_repec~d |        283    .0070671    .0839171          0          1
post_inst_~d |        283    .0070671    .0839171          0          1
-------------+---------------------------------------------------------
post_archive |        283    .0706714    .2567291          0          1

-------------
-> pyear = 2000

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
post_nber_~d |        305           0           0          0          0
post_cepr_~d |        305           0           0          0          0
post_ssrn_~d |        305    .0819672    .2747656          0          1
post_repec~d |        305           0           0          0          0
post_inst_~d |        305    .0065574    .0808443          0          1
-------------+---------------------------------------------------------
post_archive |        305    .0885246    .2845231          0          1

-------------
-> pyear = 2005

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
post_nber_~d |        315           0           0          0          0
post_cepr_~d |        315           0           0          0          0
post_ssrn_~d |        315    .0507937    .2199254          0          1
post_repec~d |        315           0           0          0          0
post_inst_~d |        315    .0031746    .0563436          0          1
-------------+---------------------------------------------------------
post_archive |        315    .0539683    .2263146          0          1


. summ pre_*_ind pre_archive

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
pre_nber_ind |        903    .0531561    .2244691          0          1
pre_cepr_ind |        903    .0177187    .1320002          0          1
pre_ssrn_ind |        903    .1816168    .3857421          0          1
pre_repec_~d |        903    .0166113    .1278807          0          1
pre_inst_ind |        903    .2458472     .430827          0          1
-------------+---------------------------------------------------------
 pre_archive |        903    .3521595    .4779081          0          1

. summ post_*_ind post_archive

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
post_nber_~d |        903    .0011074    .0332779          0          1
post_cepr_~d |        903           0           0          0          0
post_ssrn_~d |        903    .0631229    .2433187          0          1
post_repec~d |        903    .0022148     .047036          0          1
post_inst_~d |        903    .0055371    .0742465          0          1
-------------+---------------------------------------------------------
post_archive |        903    .0708749    .2567579          0          1

.
. * Columns for precent in repository solely
.
.  foreach var in nber cepr ssrn repec inst {
  2.    gen pre_`var'_ind_sole = pre_`var'_ind * pre_sole
  3.    gen post_`var'_ind_sole = post_`var'_ind * post_sole
  4.    }

.
. gen pre_archive_sole = pre_archive * pre_sole

. gen post_archive_sole = post_archive * post_sole

. sort pyear

. by pyear: summ pre_*_ind_sole pre_archive_sole

-------------
-> pyear = 1995

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
pre_nber_i~e |        283    .0106007     .102594          0          1
pre_cepr_i~e |        283    .0070671    .0839171          0          1
pre_ssrn_i~e |        283           0           0          0          0
pre_repec~le |        283    .0282686    .1660327          0          1
pre_inst_i~e |        283    .0742049    .2625684          0          1
-------------+---------------------------------------------------------
pre_archi~le |        283    .1201413    .3257027          0          1

-------------
-> pyear = 2000

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
pre_nber_i~e |        305    .0032787    .0572598          0          1
pre_cepr_i~e |        305    .0032787    .0572598          0          1
pre_ssrn_i~e |        305    .0885246    .2845231          0          1
pre_repec~le |        305           0           0          0          0
pre_inst_i~e |        305    .1278689    .3344925          0          1
-------------+---------------------------------------------------------
pre_archi~le |        305    .2229508    .4169096          0          1

-------------
-> pyear = 2005

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
pre_nber_i~e |        315           0           0          0          0
pre_cepr_i~e |        315    .0063492    .0795549          0          1
pre_ssrn_i~e |        315    .1238095    .3298882          0          1
pre_repec~le |        315           0           0          0          0
pre_inst_i~e |        315    .1904762    .3933015          0          1
-------------+---------------------------------------------------------
pre_archi~le |        315    .3206349    .4674632          0          1


. by pyear: summ post_*_ind_sole post_archive_sole

-------------
-> pyear = 1995

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
post_nber~le |        283           0           0          0          0
post_cepr~le |        283           0           0          0          0
post_ssrn~le |        283    .0530035    .2244374          0          1
post_repe~le |        283    .0070671    .0839171          0          1
post_inst~le |        283    .0070671    .0839171          0          1
-------------+---------------------------------------------------------
post_arch~le |        283    .0671378    .2507038          0          1

-------------
-> pyear = 2000

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
post_nber~le |        305           0           0          0          0
post_cepr~le |        305           0           0          0          0
post_ssrn~le |        305    .0819672    .2747656          0          1
post_repe~le |        305           0           0          0          0
post_inst~le |        305    .0065574    .0808443          0          1
-------------+---------------------------------------------------------
post_arch~le |        305    .0885246    .2845231          0          1

-------------
-> pyear = 2005

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
post_nber~le |        315           0           0          0          0
post_cepr~le |        315           0           0          0          0
post_ssrn~le |        315    .0507937    .2199254          0          1
post_repe~le |        315           0           0          0          0
post_inst~le |        315    .0031746    .0563436          0          1
-------------+---------------------------------------------------------
post_arch~le |        315    .0539683    .2263146          0          1


. summ pre_*_ind_sole pre_archive_sole

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
pre_nber_i~e |        903    .0044297    .0664451          0          1
pre_cepr_i~e |        903    .0055371    .0742465          0          1
pre_ssrn_i~e |        903    .0730897    .2604279          0          1
pre_repec~le |        903    .0088594    .0937582          0          1
pre_inst_i~e |        903    .1328904    .3396443          0          1
-------------+---------------------------------------------------------
pre_archi~le |        903    .2248062     .417686          0          1

. summ post_*_ind_sole post_archive_sole

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
post_nber~le |        903           0           0          0          0
post_cepr~le |        903           0           0          0          0
post_ssrn~le |        903    .0620155    .2413174          0          1
post_repe~le |        903    .0022148     .047036          0          1
post_inst~le |        903    .0055371    .0742465          0          1
-------------+---------------------------------------------------------
post_arch~le |        903    .0697674    .2548959          0          1

.
end of do-file

. exit, clear