. sum att if hteam == "OAK" && attendance > 35000 Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- attendance | 96 43800.69 5904.989 35016 55989 . display 96*(43800.69-35000) 844866.24 . list if hteam == "OAK" && attendance >35000 +-------------------------------------+ | date vteam hteam attend~e | |-------------------------------------| 11. | 20040405 TEX OAK 45122 | 384. | 20040504 NYA OAK 35081 | 399. | 20040505 NYA OAK 43227 | 413. | 20040506 NYA OAK 38417 | 1070. | 20040625 SFN OAK 48189 | |-------------------------------------| 1085. | 20040626 SFN OAK 55989 | 1101. | 20040627 SFN OAK 53974 | 1140. | 20040630 ANA OAK 35016 | 1326. | 20040716 CHA OAK 40891 | 1506. | 20040728 SEA OAK 40988 | |-------------------------------------| 1735. | 20040814 KCA OAK 36942 | 1750. | 20040815 KCA OAK 37748 | 1885. | 20040825 BAL OAK 35260 | 1927. | 20040828 TBA OAK 48099 | 2043. | 20040906 BOS OAK 37839 | |-------------------------------------| 2069. | 20040908 BOS OAK 39575 | 2395. | 20041001 ANA OAK 47081 | 2411. | 20041002 ANA OAK 42832 | 2432. | 19990405 NYA OAK 46380 | 3609. | 19990703 ANA OAK 50916 | |-------------------------------------| 3752. | 19990716 SFN OAK 44671 | 3768. | 19990717 SFN OAK 51263 | 4123. | 19990811 NYA OAK 43683 | 4868. | 20000403 DET OAK 53498 | 5645. | 20000602 SFN OAK 51768 | |-------------------------------------| 5660. | 20000603 SFN OAK 45392 | 5675. | 20000604 SFN OAK 48128 | 6134. | 20000708 ARI OAK 54268 | 6394. | 20000729 BOS OAK 36325 | 6761. | 20000825 NYA OAK 47773 | |-------------------------------------| 6777. | 20000826 NYA OAK 43099 | 6792. | 20000827 NYA OAK 39348 | 7269. | 20000930 TEX OAK 35546 | 7284. | 20001001 TEX OAK 45606 | 7337. | 20010406 ANA OAK 42826 | |-------------------------------------| 7728. | 20010506 BOS OAK 40186 | 7858. | 20010516 NYA OAK 43932 | 7916. | 20010520 CHA OAK 39249 | 8168. | 20010608 SFN OAK 41904 | 8183. | 20010609 SFN OAK 50273 | |-------------------------------------| 8198. | 20010610 SFN OAK 47859 | 8323. | 20010620 SEA OAK 40639 | 8503. | 20010703 ANA OAK 51838 | 8590. | 20010712 LAN OAK . | 8620. | 20010714 LAN OAK 35163 | |-------------------------------------| 8828. | 20010728 KCA OAK 40242 | 8972. | 20010808 BOS OAK 50863 | 9001. | 20010810 NYA OAK 38728 | 9016. | 20010811 NYA OAK 45253 | 9031. | 20010812 NYA OAK 47725 | |-------------------------------------| 9163. | 20010822 CLE OAK 40992 | 9193. | 20010824 DET OAK 41646 | 9502. | 20010922 SEA OAK 45734 | 9517. | 20010923 SEA OAK 38628 | 9719. | 20020401 TEX OAK 43908 | |-------------------------------------| 9995. | 20020423 NYA OAK 40360 | 10010. | 20020424 NYA OAK 54513 | 10196. | 20020508 BOS OAK 40155 | 10576. | 20020605 SEA OAK 35647 | 10632. | 20020609 HOU OAK 35065 | |-------------------------------------| 10880. | 20020628 SFN OAK 46345 | 10895. | 20020629 SFN OAK 53501 | 10910. | 20020630 SFN OAK 54123 | 10975. | 20020705 KCA OAK 53802 | 11109. | 20020717 ANA OAK 38547 | |-------------------------------------| 11300. | 20020731 CLE OAK 47574 | 11491. | 20020814 TOR OAK 40528 | 11532. | 20020817 CHA OAK 40658 | 11726. | 20020831 MIN OAK 42841 | 11742. | 20020901 MIN OAK 37676 | |-------------------------------------| 11784. | 20020904 KCA OAK 55528 | 11913. | 20020913 SEA OAK 38210 | 11928. | 20020914 SEA OAK 40309 | 11943. | 20020915 SEA OAK 38783 | 11981. | 20020918 ANA OAK 50730 | |-------------------------------------| 12039. | 20020922 TEX OAK 35697 | 12155. | 20030401 SEA OAK 41723 | 12483. | 20030426 CLE OAK 36346 | 12653. | 20030509 NYA OAK 40317 | 12668. | 20030510 NYA OAK 44486 | |-------------------------------------| 12683. | 20030511 NYA OAK 45390 | 12871. | 20030525 KCA OAK 37705 | 13091. | 20030611 ATL OAK 35618 | 13205. | 20030620 SFN OAK 47074 | 13219. | 20030621 SFN OAK 52888 | |-------------------------------------| 13233. | 20030622 SFN OAK 55413 | 13416. | 20030705 ANA OAK 55601 | 13514. | 20030712 BAL OAK 44807 | 13758. | 20030801 NYA OAK 41407 | 13773. | 20030802 NYA OAK 44234 | |-------------------------------------| 13789. | 20030803 NYA OAK 44528 | 13923. | 20030813 BOS OAK 44868 | 13938. | 20030814 BOS OAK 37293 | 14155. | 20030830 TBA OAK 45150 | 14433. | 20030919 SEA OAK 41035 | |-------------------------------------| 14449. | 20030920 SEA OAK 40226 | 14464. | 20030921 SEA OAK 40643 | +-------------------------------------+ . table vteam if hteam == "OAK" && attendance > 35000, contents( freq ) ---------------------- vTeam | Freq. ----------+----------- ANA | 9 ARI | 1 ATL | 1 BAL | 2 BOS | 8 CHA | 3 CLE | 3 DET | 2 HOU | 1 KCA | 6 LAN | 2 MIN | 2 NYA | 20 SEA | 12 SFN | 17 TBA | 2 TEX | 5 TOR | 1 ---------------------- . gen attincrease10 = attendance *1.1 (4 missing values generated) . gen attincrease20 = attendance *1.2 (4 missing values generated) . sum attincrease10 if hteam == "OAK" && attincrease10 > 35000 Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- attincrea~10 | 112 46502.73 7295.839 35057 61587.9 . display 112*(46502.73-35000) 1288305.8 . sum attincrease20 if hteam == "OAK" && attincrease20 > 35000 Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- attincrea~20 | 144 47631.38 9120.52 35097.6 67186.8 . display 144*(47631.38-35000) 1818918.7