import delimited "revere_measures_r1.csv"
count

gen ln_outdeg = ln(1+outdeg)
label variable ln_outdeg "natural log of 1+number of customers"
* Translate absqtr coding (1960Q1 = 7841) to Stata (1960Q1 = 0)
replace absqtr = absqtr - 7841

rename absqtr year_qtr
format year_qtr %tq	
unique cusip year_qtr
assert `r(N)' == `r(unique)'
order cusip year_qtr

save "..\revere_measures.dta", replace

