*Project Title: Devins-Lewis Independent Agency Paper
*Date Started: March 6, 2017//August 10, 2021
*Current date: Feburary 12, 2022
*Data: updated_time_to_maj_data_072021.xlos
*Notes: Devins and Lewis Analysis of the time to majorities

**This command loads the Excel data
 import excel "C:\Users\lewisde\Documents\Devins Independent Agency Project\updated_time_to_maj_data_072021.xlsx", sheet("Sheet1") firstrow
 
**Now I take the time in days and convert to months

generate mtimetopmaj=TimetoPmaj/30
generate mtimetoabmaj=TimetoAbmaj/30

**Now I sort by president and simply summarize the time to majority data. First BU article agencies only.
bysort President: summarize mtimetopmaj if BUAg==1

**Now All agencies
bysort President: summarize mtimetopmaj

**Now vacancies by president
bysort President: summarize VacantSlots