levelsof year, local(years)
egen flag = tag(id_job year)
gen stateratio = .
foreach y of local years {
summ occ if year == `y' & flag, meanonly
local odds = `r(mean)'*100
replace stateratio = `odds' if year == `y'
}