use table1.dta
bys No: egen tot_money=total(money)
keep No tot_money
duplicates drop
save temp
use table2.dta, clear
bys No: egen tot_chengben = total(chengben)
keep No tot_chengben
duplicates drop
merge 1:1 No using temp
drop _merge
erase temp
gen ratio=tot_money/tot_chengben

太感谢您了，多谢多谢