[Ali Atia]

tempfile se_ranks master
save `master'
gen n = 1
collapse (first) n, by(Topics se_rank)
bysort Topics: replace n = _n
save `se_ranks'
use `master', clear
bysort Topic j_order (idd): egen totaln = total(idd!=idd[_n-1])
collapse (first) j_rank_ln, by(Topic j_order totaln)
expand totaln
drop totaln
gsort Topics -j_order
by Topics: gen n = _n
merge 1:1 Topics n using `se_ranks'
keep Topics se_rank j_rank_ln
rename j_rank_ln j2
merge 1:m Topics se_rank using `master', nogen

[Davis Nguyen]

Thank you very much! I’ll check to see if it works for the entire data set.