clear input age_from age_to p_male d_male p_female d_female 0 1 162700 997 154750 742 1 2 171090 191 163570 149 2 3 172005 191 164335 149 3 4 176755 191 169660 149 4 5 185515 191 175890 149 5 6 194000 132 185975 113 6 7 199195 132 188960 113 7 8 201135 132 190840 113 8 9 205935 132 196340 113 9 10 211205 132 202555 113 10 11 215755 163 204600 123 11 12 216235 163 206155 123 12 13 208460 163 198755 123 13 14 203840 163 194455 123 14 15 207155 163 197690 123 15 16 212750 87 201070 57 16 17 213510 131 201310 58 17 18 211215 146 200755 57 18 19 208305 182 199100 67 19 20 206370 182 198945 66 20 21 206205 205 201000 48 21 22 202435 186 198160 80 22 23 194830 181 193770 64 23 24 189780 196 189280 61 24 25 189030 175 191315 71 25 26 187535 174 190580 69 26 27 186935 173 191780 66 27 28 181685 173 188870 61 28 29 186680 182 192695 73 29 30 192675 184 198760 83 30 31 203690 188 210675 92 31 32 205340 239 211120 108 32 33 204260 207 211015 93 33 34 205820 218 213250 105 34 35 212145 249 219415 117 35 36 227420 284 233990 163 36 37 246260 286 253600 172 37 38 255455 329 261950 185 38 39 259780 391 265775 225 39 40 256090 377 262545 237 40 41 260595 391 268160 259 41 42 257915 447 264845 247 42 43 252580 457 260680 301 43 44 253045 493 258600 312 44 45 247590 568 254760 354 45 46 240870 561 247300 378 46 47 240700 652 247425 376 47 48 231430 658 238865 435 48 49 222215 736 228410 474 49 50 215940 751 220380 467 50 51 212555 756 217035 485 51 52 207890 890 211510 569 52 53 204085 932 208375 525 53 54 205090 1009 208175 650 54 55 203740 1103 207300 701 55 56 171150 1018 174405 653 56 57 162920 1069 165275 685 57 58 158970 1192 162300 719 58 59 154100 1253 157000 762 59 60 142065 1274 146050 771 60 61 136350 1390 141905 767 61 62 127475 1435 133120 871 62 63 124455 1608 130360 900 63 64 119350 1511 125515 966 64 65 113935 1626 121305 1026 65 66 114150 1760 122125 1168 66 67 109610 1927 118575 1281 67 68 106565 2082 115030 1295 68 69 107485 2289 117515 1479 69 70 106010 2555 116555 1616 70 71 102685 2761 116140 1783 71 72 97845 2788 112960 1882 72 73 90905 2885 107765 2042 73 74 88380 3040 107115 2168 74 75 81965 3274 103445 2315 75 76 78490 3319 102555 2460 76 77 72710 3459 98765 2821 77 78 67225 3617 95540 2968 78 79 62270 3571 90320 3083 79 80 58125 3752 87665 3331 80 81 51825 3804 80900 3512 81 82 45365 3749 73815 3650 82 83 35775 3083 61330 3443 83 84 31840 3069 55770 3490 84 85 27840 3123 51675 3707 85 86 24930 2957 47425 3815 86 87 22245 2915 44345 3971 87 88 18090 2735 38545 3976 88 89 14810 2436 32765 3856 89 90 11365 1981 27275 3550 90 91 9005 1733 22815 3335 91 92 7060 1468 18565 3069 92 93 5140 1324 14840 2719 93 94 4005 1074 11785 2571 94 95 2810 798 9070 1983 95 96 1945 589 6890 1744 96 97 1375 481 4915 1311 97 98 985 337 3750 1079 98 99 655 252 2545 856 99 100 420 157 1745 638 100 101 740 268 3055 1310 end gen l = 10000 if _n == 1 gen q = d_male/p_male /* not quite right, student to REFINE */ gen p = 1 - q replace l = 10000 * q if _n == 1 /* _n is a subscript ie indexing variable */ replace l = l[_n - 1] * q if _n > 1 /* WRONG formula, student to CORRECT */ gen d = 10000 - l if _n == 1 replace d = l[_n-1] + l if _n > 1 /* WRONG formula, student to CORRECT */ list age_to q p l d /* can comment out list once formulae ok */ /* once formulae fixed, can get statistics , curves etc... */