Content

* cb5A

* could do with collapse but if we want the count
* appended to the current dataset...

use cb5a, clear
list

* generate rowid = state + string(year)

egen rowid = concat(state year)
reshape long cand, i(rowid) j(candnr)
list
save cb5along, replace

bysort state cand: generate byte last=(_n == _N)
egen totcand = total(last), by(state)
drop last
quietly reshape wide
list, sepby(state)

use cb5a, clear
generate rowid = state + string(year)
reshape long cand, i(rowid) j(candnr)
bysort state cand: generate byte last=(_n == _N)
tabstat last, stat(sum) nototal by(state)

use cb5along, clear
egen indivcount = tag(state cand)
egen totcand = total(indivcount), by(state)
tabstat totcand, nototal by(state)