log using collapse,text replace set obs 100000000 set rmsg on generate personid = int(_n/12) sort personid generate month_inc = runiform() preserve scollapse (sum) month_inc,by(personid) rename month_inc annual_inc restore by personid: gen annual_inc = sum(month_inc) by personid: keep if _n==_N