* transforming csv files to stata files
clear
import delimited Z:\JHR_conference_R&R\SecondRevision_R&R\FinalDataset_forpublication\dataforpublicationJuly2020\MAINDATApaperlevel.csv
save "Z:\JHR_conference_R&R\SecondRevision_R&R\FinalDataset_forpublication\dataforpublicationJuly2020\MAINDATApaperlevel.dta", replace
clear
import delimited Z:\JHR_conference_R&R\SecondRevision_R&R\FinalDataset_forpublication\dataforpublicationJuly2020\MAINDATAauthorpaperlevel.csv
save "Z:\JHR_conference_R&R\SecondRevision_R&R\FinalDataset_forpublication\dataforpublicationJuly2020\MAINDATAauthorpaperlevel.dta", replace

*******************************************************************************************************************************************************
************************************************************* TABLE 1 *********************************************************************************
*******************************************************************************************************************************************************

use "Z:\JHR_conference_R&R\SecondRevision_R&R\FinalDataset_forpublication\dataforpublicationJuly2020\MAINDATApaperlevel.dta", clear

sum numbauthors soloauthor  top10 top10_100 belowtop100 haspublic ac_y2impfactor inssrn 
sum numbauthors soloauthor  top10 top10_100 belowtop100 haspublic ac_y2impfactor inssrn if apsa==1
sum numbauthors soloauthor  top10 top10_100 belowtop100 haspublic ac_y2impfactor inssrn if apsa==0


*******************************************************************************************************************************************************
************************************************************* TABLE 2 *********************************************************************************
*******************************************************************************************************************************************************

*panel A
sum r1p1downloads39monthsafter_j foundssrn_j  downloads39monthsafter_j 
*number of observations by apsa/MPSA
sum r1p1downloads39monthsafter_j foundssrn_j  downloads39monthsafter_j if apsa==1
sum r1p1downloads39monthsafter_j foundssrn_j  downloads39monthsafter_j if apsa==0

* PANEL B
sum foundgs_2y_f anycitation_2y atleast2citation_2y atleast5citation_2y atleast10citation_2y ncitation_2yearsafter_j
sum anycitation_4y_3entries atleast2citation_4y_3entries atleast5citation_4y_3entries atleast10citation_4y_3entries  ncitation_4y_3entries 
*number of observations by apsa/MPSA
sum foundgs_2y_f foundgsoutsidessrn_2yearsafter_j anycitation_2y atleast2citation_2y atleast5citation_2y atleast10citation_2y ncitation_2yearsafter_j anycitation_4y_3entries atleast2citation_4y_3entries atleast5citation_4y_3entries atleast10citation_4y_3entries  ncitation_4y_3entries if apsa==1
sum foundgs_2y_f foundgsoutsidessrn_2yearsafter_j anycitation_2y atleast2citation_2y atleast5citation_2y atleast10citation_2y ncitation_2yearsafter_j anycitation_4y_3entries atleast2citation_4y_3entries atleast5citation_4y_3entries atleast10citation_4y_3entries  ncitation_4y_3entries if apsa==0

* PANEL B, continuation
sum anycitation_4y_10entries atleast2citation_4y_10entries atleast5citation_4y_10entries atleast10citation_4y_10entries ncitation_4yearsafter_j 
*number of observations by apsa/MPSA
sum anycitation_4y_10entries atleast2citation_4y_10entries atleast5citation_4y_10entries atleast10citation_4y_10entries ncitation_4yearsafter_j if apsa==1
sum anycitation_4y_10entries atleast2citation_4y_10entries atleast5citation_4y_10entries atleast10citation_4y_10entries ncitation_4yearsafter_j if apsa==0


*******************************************************************************************************************************************************
************************************************************* TABLE 3 *********************************************************************************
*******************************************************************************************************************************************************

************************************************ ROWS 1-3 *****************************************************************
     foreach var of varlist r1p1downloads39monthsafter_j foundssrn_j downloads39monthsafter_j {
      *column1
	  reg `var' apsa2012 apsa year2012 year2011 year2010 apsa_yeartrend if r1p1downloads39monthsafter_j<500, robust
	  *column 2
	  reg `var' apsa2012 apsa year2012 year2011 year2010 apsa_yeartrend inssrn numbauthors ac_y2impfactor schools* if r1p1downloads39monthsafter_j<500, robust 
	  *column 3
	  reg `var' apsa2012 apsa year2012 year2011 year2010 apsa_yeartrend inssrn numbauthors ac_y2impfactor schools* if r1p1downloads39monthsafter_j<500&matchedsampleallsample==1, robust 
        }

************************************************ ROWS 4-6 *****************************************************************

     foreach var of varlist r1p1downloads39monthsafter_j foundssrn_j downloads39monthsafter_j {
      *column1
	  reg `var' apsa2012 apsa year2012 year2011 year2010 apsa_yeartrend if r1p1downloads39monthsafter_j<500&apsaandmpsa==0, robust
	  *column 2
	  reg `var' apsa2012 apsa year2012 year2011 year2010 apsa_yeartrend inssrn numbauthors ac_y2impfactor schools* if r1p1downloads39monthsafter_j<500&apsaandmpsa==0, robust 
	  *column 3
	  reg `var' apsa2012 apsa year2012 year2011 year2010 apsa_yeartrend inssrn numbauthors ac_y2impfactor schools* if r1p1downloads39monthsafter_j<500&matchedsampleallsample==1&apsaandmpsa==0, robust 
        }



*******************************************************************************************************************************************************
************************************************************* TABLE 4 *********************************************************************************
*******************************************************************************************************************************************************


use "Z:\JHR_conference_R&R\SecondRevision_R&R\FinalDataset_forpublication\dataforpublicationJuly2020\MAINDATApaperlevel.dta", clear
     foreach var of varlist anycitation_2y atleast2citation_2y atleast5citation_2y atleast10citation_2y foundgs_2y_f foundgsoutsidessrn {
      *row 1
	  reg `var' apsa2012 apsa year2012 year2011 year2010 apsa_yeartrend , robust 
	  *row 2 
	  reg `var' apsa2012 apsa year2012 year2011 year2010 apsa_yeartrend inssrn numbauthors ac_y2impfactor schools* , robust    
	  *row 4
	  reg `var' apsa2012 apsa year2012 year2011 year2010 apsa_yeartrend inssrn numbauthors ac_y2impfactor schools* if apsaandmpsa==0, robust
	  *row 5
	  reg `var' apsa2012 apsa year2012 year2011 year2010 apsa_yeartrend inssrn numbauthors ac_y2impfactor schools* if matchedsamplemozendasample==1, robust
        }

use "Z:\JHR_conference_R&R\SecondRevision_R&R\FinalDataset_forpublication\dataforpublicationJuly2020\MAINDATAauthorpaperlevel.dta", clear
	 foreach var of varlist anycitation_2y atleast2citation_2y atleast5citation_2y atleast10citation_2y foundgs_2y_f foundgsoutsidessrn {  
	  *row 3
	  xtset author
	  xtreg `var' apsa2012 apsa year2012 year2011 year2010 apsa_yeartrend inssrn numbauthors ac_y2impfactor , robust fe   
	  *row 6
	  xtreg `var' apsa2012 apsa year2012 year2011 year2010 apsa_yeartrend inssrn numbauthors ac_y2impfactor if matchedsamplemozendasample==1, robust fe
        }



*******************************************************************************************************************************************************
************************************************************* TABLE 5 *********************************************************************************
*******************************************************************************************************************************************************

use "Z:\JHR_conference_R&R\SecondRevision_R&R\FinalDataset_forpublication\dataforpublicationJuly2020\MAINDATApaperlevel.dta", clear
     foreach var of varlist anycitation_4y_10entries atleast2citation_4y_10entries atleast5citation_4y_10entries atleast10citation_4y_10entries {
      *row 1
	  reg `var' apsa2012 apsa year2012 year2011 year2010 apsa_yeartrend , robust 
	  *row 2 
	  reg `var' apsa2012 apsa year2012 year2011 year2010 apsa_yeartrend inssrn numbauthors ac_y2impfactor schools* , robust    
	  *row 4
	  reg `var' apsa2012 apsa year2012 year2011 year2010 apsa_yeartrend inssrn numbauthors ac_y2impfactor schools* if apsaandmpsa==0, robust 
	  *row 5
	  reg `var' apsa2012 apsa year2012 year2011 year2010 apsa_yeartrend inssrn numbauthors ac_y2impfactor schools* if matchedsamplemozendasample==1, robust 
        }

use "Z:\JHR_conference_R&R\SecondRevision_R&R\FinalDataset_forpublication\dataforpublicationJuly2020\MAINDATAauthorpaperlevel.dta", clear
	 foreach var of varlist anycitation_4y_10entries atleast2citation_4y_10entries atleast5citation_4y_10entries atleast10citation_4y_10entries {  
	  *row 3
	  xtset author
	  xtreg `var' apsa2012 apsa year2012 year2011 year2010 apsa_yeartrend inssrn numbauthors ac_y2impfactor , robust fe  
	  *row 6
	  xtreg `var' apsa2012 apsa year2012 year2011 year2010 apsa_yeartrend inssrn numbauthors ac_y2impfactor if matchedsamplemozendasample==1, robust fe
        }
		
		

*******************************************************************************************************************************************************
************************************************************* TABLE 6 *********************************************************************************
*******************************************************************************************************************************************************


use "Z:\JHR_conference_R&R\SecondRevision_R&R\FinalDataset_forpublication\dataforpublicationJuly2020\MAINDATApaperlevel.dta", clear
sum citedbyconfpart1to10_f citedbysamesession1to10_f citedbynotconfpart1to10_f 

	 foreach var of varlist citedbyconfpart1to10_f citedbysamesession1to10_f citedbynotconfpart1to10_f  {  
	  *Column 1
	  reg `var' apsa2012 apsa year2012 year2011 year2010 apsa_yeartrend inssrn numbauthors ac_y2impfactor schools* , robust
        } 

use "Z:\JHR_conference_R&R\SecondRevision_R&R\FinalDataset_forpublication\dataforpublicationJuly2020\MAINDATAauthorpaperlevel.dta", clear
sum citedbyconfpart1to10_f citedbysamesession1to10_f citedbynotconfpart1to10_f 
	 foreach var of varlist citedbyconfpart1to10_f citedbysamesession1to10_f citedbynotconfpart1to10_f  {  
	  *Column 2
	  xtset author
	  xtreg `var' apsa2012 apsa year2012 year2011 year2010 apsa_yeartrend inssrn numbauthors ac_y2impfactor , robust fe
        }


*******************************************************************************************************************************************************
************************************************************* TABLE 7 *********************************************************************************
*******************************************************************************************************************************************************

use "Z:\JHR_conference_R&R\SecondRevision_R&R\FinalDataset_forpublication\dataforpublicationJuly2020\MAINDATAauthorpaperlevel.dta", clear

	 foreach var of varlist anycitation_4y_10entries atleast2citation_4y_10entries atleast5citation_4y_10entries atleast10citation_4y_10entries citedbynotconfpart1to10_f citedbyconfpart1to10_f citedbysamesession1to10_f  {  
	  *Panel A
	  xtset author
	  xtreg `var' apsa2012 apsa year2012 year2011 year2010 apsa_yeartrend inssrn numbauthors ac_y2impfactor , robust fe
        }

	 foreach var of varlist anycitation_4y_10entries atleast2citation_4y_10entries atleast5citation_4y_10entries atleast10citation_4y_10entries citedbynotconfpart1to10_f citedbyconfpart1to10_f citedbysamesession1to10_f  {  
	  *Panel B
	  xtset author
	  xtreg `var' apsa2012type4 apsa2012type1 apsa2012type2 apsa2012type3  type1-type4 apsa year2012 year2011 year2010 apsa_yeartrendtype* author_hcited1a inssrn numbauthors ac_y2impfactor  , robust fe
        }

 				
*******************************************************************************************************************************************************
************************************************************* TABLE 8 *********************************************************************************
*******************************************************************************************************************************************************

use "Z:\JHR_conference_R&R\SecondRevision_R&R\FinalDataset_forpublication\dataforpublicationJuly2020\MAINDATApaperlevel.dta", clear

** PANEL A: PER RANKING (columns 1-3)
	 foreach var of varlist top10 top10_100 belowtop100 {  
	  *row 1
	  reg anycitation_4y_10entries apsa2012 apsa year2012 year2011 year2010 apsa_yeartrend inssrn numbauthors ac_y2impfactor if `var'==1, robust 
	  *row 2
	  reg atleast2citation_4y_10entries apsa2012 apsa year2012 year2011 year2010 apsa_yeartrend inssrn numbauthors ac_y2impfactor if `var'==1, robust 
	  *row 3
	  reg atleast5citation_4y_10entries apsa2012 apsa year2012 year2011 year2010 apsa_yeartrend inssrn numbauthors ac_y2impfactor if `var'==1, robust 
	  *row 4
	  reg atleast10citation_4y_10entries apsa2012 apsa year2012 year2011 year2010 apsa_yeartrend inssrn numbauthors ac_y2impfactor if `var'==1, robust
	  *row 5
	  reg citedbynotconfpart1to10_f apsa2012 apsa year2012 year2011 year2010 apsa_yeartrend inssrn numbauthors ac_y2impfactor if `var'==1, robust
	  *row 6
	  reg citedbyconfpart1to10_f apsa2012 apsa year2012 year2011 year2010 apsa_yeartrend inssrn numbauthors ac_y2impfactor if `var'==1, robust 
	  *row 7
	  reg citedbysamesession1to10_f apsa2012 apsa year2012 year2011 year2010 apsa_yeartrend inssrn numbauthors ac_y2impfactor if `var'==1, robust 
        } 


** PANEL A: by citations (columns 4-5)

	 foreach var of varlist anycitation_4y_10entries atleast2citation_4y_10entries atleast5citation_4y_10entries atleast10citation_4y_10entries citedbynotconfpart1to10_f citedbyconfpart1to10_f citedbysamesession1to10_f {  
	  *column 4 (rows 1-7)
	  reg `var' apsa2012 apsa year2012 year2011 year2010 apsa_yeartrend inssrn numbauthors ac_y2impfactor if ac_previouscitationsp==0, robust
	  *column 5 (rows 1-7)
	  reg `var' apsa2012 apsa year2012 year2011 year2010 apsa_yeartrend inssrn numbauthors ac_y2impfactor if ac_previouscitationsp>0, robust
}



** PANEL B
	 foreach var of varlist anycitation_4y_10entries atleast2citation_4y_10entries atleast5citation_4y_10entries atleast10citation_4y_10entries citedbynotconfpart1to10_f citedbyconfpart1to10_f citedbysamesession1to10_f {  
	  *column 1 (rows 1-7)
	  reg `var' apsa2012 apsa year2012 year2011 year2010 apsa_yeartrend inssrn numbauthors  schools* if ac_npublication==0, robust 
	  *column 2 (rows 1-7)
	  reg `var' apsa2012 apsa year2012 year2011 year2010 apsa_yeartrend inssrn numbauthors  schools* if (ac_npublication==1|ac_npublication==2), robust
	  *column 3 (rows 1-7)
	  reg `var' apsa2012 apsa year2012 year2011 year2010 apsa_yeartrend inssrn numbauthors  schools* if ac_npublication>2, robust 
	  *column 4 (rows 1-7)
	  reg `var' apsa2012 apsa year2012 year2011 year2010 apsa_yeartrend inssrn numbauthors  schools* if topublic_author_j==0, robust 
	  *column 5 (rows 1-7)
	  reg `var' apsa2012 apsa year2012 year2011 year2010 apsa_yeartrend inssrn numbauthors  schools* if topublic_author_j==1, robust 
	  
}