* Note: This file manipulates the datafile "2018.10.02 Associate Professors.dta" to produce the results for associate professors * in [citation]. clear all use "[path]\2018.10.02 Associate Professors.dta" set more off log using "[path]\2018.10.02 Associate Professors.log", replace log off *************************************************************************************************************************************************. *************************************************************************************************************************************************. *************************************************************************************************************************************************. * Drop the University of Texas - Austin because years because they are missing from recent years of the ASA Guide to Graduate Programs. *************************************************************************************************************************************************. *************************************************************************************************************************************************. *************************************************************************************************************************************************. drop if job_dept=="Texas" *************************************************************************************************************************************************. *************************************************************************************************************************************************. *************************************************************************************************************************************************. * Generate an "era" variable that groups years that people started their first jobs into 3-year increments. *************************************************************************************************************************************************. *************************************************************************************************************************************************. *************************************************************************************************************************************************. gen era=. replace era=1 if job_yr>=1991 & job_yr<=1993 replace era=2 if job_yr>=1994 & job_yr<=1996 replace era=3 if job_yr>=1997 & job_yr<=1999 replace era=4 if job_yr>=2000 & job_yr<=2002 replace era=5 if job_yr>=2003 & job_yr<=2005 replace era=6 if job_yr>=2006 & job_yr<=2008 replace era=7 if job_yr>=2009 & job_yr<=2011 replace era=8 if job_yr>=2012 & job_yr<=2014 replace era=9 if job_yr>=2015 & job_yr<=2017 *************************************************************************************************************************************************. *************************************************************************************************************************************************. *************************************************************************************************************************************************. * Generate measures of number of publications that disregard order of authorship. *************************************************************************************************************************************************. *************************************************************************************************************************************************. *************************************************************************************************************************************************. gen phd_asr= phd_asr1+phd_asr2 gen phd_peer= phd_peer1+phd_peer2 gen phd_chap= phd_chap1+phd_chap2 gen phd_book= phd_book1+phd_book2 gen phd_other= phd_other1+phd_other2 gen phd_total= phd_asr+phd_peer+phd_chap+phd_book+phd_other *************************************************************************************************************************************************. *************************************************************************************************************************************************. *************************************************************************************************************************************************. * Generate Figure 2a: Number of new assistant professors by year (as era). *************************************************************************************************************************************************. *************************************************************************************************************************************************. *************************************************************************************************************************************************. log on tab era log off *************************************************************************************************************************************************. *************************************************************************************************************************************************. *************************************************************************************************************************************************. * Generate Figure 2b: Number of new assistant professors by department. *************************************************************************************************************************************************. *************************************************************************************************************************************************. *************************************************************************************************************************************************. log on tab job_dept log off *************************************************************************************************************************************************. *************************************************************************************************************************************************. *************************************************************************************************************************************************. * Generate Figure 3b, 4a, 4b: Number of publications, by era and type of publication. *************************************************************************************************************************************************. *************************************************************************************************************************************************. *************************************************************************************************************************************************. log on * Figure 3b bysort era: summ phd_asr phd_peer phd_chap phd_book phd_other * Figure 4a bysort era: summ phd_asr phd_peer phd_chap phd_book phd_other if phd_book==0 * Figure 4b bysort era: summ phd_asr phd_peer phd_chap phd_book phd_other if phd_book != 0 *************************************************************************************************************************************************. *************************************************************************************************************************************************. *************************************************************************************************************************************************. * Generate Figure 8: Mean number of years between PhD and promotion to associate. *************************************************************************************************************************************************. *************************************************************************************************************************************************. *************************************************************************************************************************************************. * Create a variable expressing the number of years between obtaining PhD and being promoted gen time= job_yr- phd_yr * Figure 8 log on bysort era: summ time log off *************************************************************************************************************************************************. *************************************************************************************************************************************************. *************************************************************************************************************************************************. * Generate Figure 11b: Number of FIRST AUTHORED publications, by era and type of publication. *************************************************************************************************************************************************. *************************************************************************************************************************************************. *************************************************************************************************************************************************. log on bysort era: summ phd_asr1 phd_peer1 phd_chap1 phd_book1 phd_other1 *************************************************************************************************************************************************. *************************************************************************************************************************************************. *************************************************************************************************************************************************. * Generate Figure 12: Percentage of newly promoted associate professors who are female *************************************************************************************************************************************************. *************************************************************************************************************************************************. *************************************************************************************************************************************************. log on tab era sex, row nof log off *************************************************************************************************************************************************. *************************************************************************************************************************************************. *************************************************************************************************************************************************. * Generate Figure 14, 15: Number of publications, by era, type of publication, gender, and whether they ever published a book *************************************************************************************************************************************************. *************************************************************************************************************************************************. *************************************************************************************************************************************************. * Figure 14 bysort sex era: summ phd_asr phd_peer phd_chap phd_book phd_other if phd_book==0 * Figure 15 bysort sex era: summ phd_asr phd_peer phd_chap phd_book phd_other if phd_book != 0 log off log close