. * ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~--; . encode Race4, gen(race4); . drop Race4; . encode RelAtt, gen(relatt); . drop RelAtt; . encode Sex, gen(sex); . drop Sex; . label list race4; race4: 1 Black 2 Hisp 3 Other 4 White . label list relatt; relatt: 1 1/mo 2 1/wk 3 2-3/mo 4 Infreq 5 None 6 Wkly+ . label list sex; sex: 1 Female 2 Male . * ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~--; . generate int black =race4 ==1 if race4 ~=. ; . generate int hisp =race4 ==2 if race4 ~=. ; . generate int OthRace =race4 ==3 if race4 ~=. ; . generate int monthly=relatt==1 if relatt ~=. ; (17 missing values generated) . generate int wkplus=relatt==6 if relatt ~=. ; (17 missing values generated) . generate int 23month=relatt==2 if relatt ~=. ; 23month invalid name r(198); . generate int infreq=relatt==3 if relatt ~=. ; (17 missing values generated) . generate int weekly=relatt==4 if relatt ~=. ; (17 missing values generated) . * omitted dummy: ; . generate int nochurch=relatt==5 if relatt ~=. ; (17 missing values generated) . generate int wkly = (relatt==6 or relatt=4) if relatt ~=.; invalid syntax r(198); . generate int gender=sex==2 if sex ~=. ; . generate IQSquare = (zIQYr89+3)^2; (808 missing values generated) . generate EdSquare = (zEd90+5.5)^2; (2328 missing values generated) . generate interact= (zIQYr89+3)*(zEd90+5.5); (2800 missing values generated) . * ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~--; . summarize KInc89 zIQYr89 BornWher zEd90 ; Variable | Obs Mean Std. Dev. Min Max ---------+----------------------------------------------------- KInc89 | 8688 33866.27 26994.15 0 154876.9 zIQYr89 | 11878 -.2652904 1.008244 -3 3 BornWher | 12685 .0689003 .2532945 0 1 zEd90 | 10358 -.1599363 1.023902 -5.47883 2.866014 . * ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~--; . regress KInc89 zIQYr89 zEd90 [aweight=Wgt90]; (sum of wgt is 2.7120e+07) Source | SS df MS Number of obs = 8237 ---------+------------------------------ F( 2, 8234) = 562.66 Model | 8.2160e+11 2 4.1080e+11 Prob > F = 0.0000 Residual | 6.0117e+12 8234 730102801 R-square = 0.1202 ---------+------------------------------ Adj R-square = 0.1200 Total | 6.8333e+12 8236 829683031 Root MSE = 27020 ---------------------------------------------------------------------- -------- KInc89 | Coef. Std. Err. t P>|t| [95% Conf. Interval] --------- +-------------------------------------------------------------------- zIQYr89 | 5224.398 398.7219 13.103 0.000 4442.803 6005.993 zEd90 | 5932.933 393.3984 15.081 0.000 5161.772 6704.093 _cons | 37504.64 298.2981 125.729 0.000 36919.9 38089.38 ---------------------------------------------------------------------- -------- . regress KInc89 zIQYr89 zEd90 interact [aweight=Wgt90]; (sum of wgt is 2.7120e+07) Source | SS df MS Number of obs = 8237 ---------+------------------------------ F( 3, 8233) = 375.09 Model | 8.2166e+11 3 2.7389e+11 Prob > F = 0.0000 Residual | 6.0116e+12 8233 730184199 R-square = 0.1202 ---------+------------------------------ Adj R-square = 0.1199 Total | 6.8333e+12 8236 829683031 Root MSE = 27022 ---------------------------------------------------------------------- -------- KInc89 | Coef. Std. Err. t P>|t| [95% Conf. Interval] --------- +-------------------------------------------------------------------- zIQYr89 | 4805.103 1516.665 3.168 0.002 1832.057 7778.148 zEd90 | 5684.825 951.0638 5.977 0.000 3820.5 7549.15 interact | 75.99566 265.2193 0.287 0.774 -443.901 595.8924 _cons | 36203.94 4549.134 7.958 0.000 27286.49 45121.39 ---------------------------------------------------------------------- -------- . regress KInc89 zIQYr89 IQSquare zEd90 EdSquare [aweight= Wgt90]; (sum of wgt is 2.7120e+07) Source | SS df MS Number of obs = 8237 ---------+------------------------------ F( 4, 8232) = 287.56 Model | 8.3775e+11 4 2.0944e+11 Prob > F = 0.0000 Residual | 5.9955e+12 8232 728318352 R-square = 0.1226 ---------+------------------------------ Adj R-square = 0.1222 Total | 6.8333e+12 8236 829683031 Root MSE = 26987 ---------------------------------------------------------------------- -------- KInc89 | Coef. Std. Err. t P>|t| [95% Conf. Interval] --------- +-------------------------------------------------------------------- zIQYr89 | 11740.46 1505.246 7.800 0.000 8789.802 14691.12 IQSquare | -1073.943 240.2585 -4.470 0.000 -1544.91 - 602.9758 zEd90 | -1119.893 2454.002 -0.456 0.648 -5930.355 3690.569 EdSquare | 625.5904 210.9232 2.966 0.003 212.1278 1039.053 _cons | 28666.26 6165.611 4.649 0.000 16580.11 40752.42 ---------------------------------------------------------------------- -------- . regress KInc89 zIQYr89 IQSquare zEd90 EdSquare interact > [aweight=Wgt90]; (sum of wgt is 2.7120e+07) Source | SS df MS Number of obs = 8237 ---------+------------------------------ F( 5, 8231) = 231.77 Model | 8.4332e+11 5 1.6866e+11 Prob > F = 0.0000 Residual | 5.9900e+12 8231 727730659 R-square = 0.1234 ---------+------------------------------ Adj R-square = 0.1229 Total | 6.8333e+12 8236 829683031 Root MSE = 26976 ---------------------------------------------------------------------- -------- KInc89 | Coef. Std. Err. t P>|t| [95% Conf. Interval] --------- +-------------------------------------------------------------------- zIQYr89 | 6808.533 2333.325 2.918 0.004 2234.628 11382.44 IQSquare | -1764.148 346.3624 -5.093 0.000 -2443.106 - 1085.191 zEd90 | 1902.446 2685.451 0.708 0.479 -3361.716 7166.607 EdSquare | -88.46343 333.3481 -0.265 0.791 -741.9097 564.9828 interact | 1633.534 590.6861 2.765 0.006 475.6402 2791.428 _cons | 29863.63 6178.313 4.834 0.000 17752.58 41974.68 ---------------------------------------------------------------------- -------- . regress KInc89 gender BornWher [aweight=Wgt90]; (sum of wgt is 2.8550e+07) Source | SS df MS Number of obs = 8687 ---------+------------------------------ F( 2, 8684) = 4.74 Model | 7.7871e+09 2 3.8935e+09 Prob > F = 0.0088 Residual | 7.1358e+12 8684 821717331 R-square = 0.0011 ---------+------------------------------ Adj R-square = 0.0009 Total | 7.1436e+12 8686 822424638 Root MSE = 28666 ---------------------------------------------------------------------- -------- KInc89 | Coef. Std. Err. t P>|t| [95% Conf. Interval] --------- +-------------------------------------------------------------------- gender | 1720.516 615.126 2.797 0.005 514.723 2926.309 BornWher | 2031.102 1577.165 1.288 0.198 -1060.516 5122.72 _cons | 36918.98 440.7292 83.768 0.000 36055.05 37782.92 ---------------------------------------------------------------------- -------- . regress KInc89 zIQYr89 zEd90 rel2 rel3 rel4 rel5 rel6 > [aweight=Wgt90]; rel2 not found r(111); . regress wkly zIQYr89 zEd90 [aweight=Wgt90]; wkly not found r(111); . regress nochurch zIQYr89 zEd90 [aweight=Wgt90]; (sum of wgt is 3.1793e+07) Source | SS df MS Number of obs = 9874 ---------+------------------------------ F( 2, 9871) = 133.83 Model | 40.9516905 2 20.4758452 Prob > F = 0.0000 Residual | 1510.2655 9871 .153000253 R-square = 0.0264 ---------+------------------------------ Adj R-square = 0.0262 Total | 1551.21719 9873 .157117106 Root MSE = .39115 ---------------------------------------------------------------------- -------- nochurch | Coef. Std. Err. t P>|t| [95% Conf. Interval] --------- +-------------------------------------------------------------------- zIQYr89 | .0097459 .0051723 1.884 0.060 -.0003928 .0198846 zEd90 | -.0705796 .0051776 -13.632 0.000 -.0807286 - .0604305 _cons | .1966596 .0039384 49.934 0.000 .1889395 .2043797 ---------------------------------------------------------------------- -------- . regress KInc89 zIQYr89 zEd90 black hisp OthRace BornWher > [aweight=Wgt90]; (sum of wgt is 2.7114e+07) Source | SS df MS Number of obs = 8236 ---------+------------------------------ F( 6, 8229) = 199.90 Model | 8.6935e+11 6 1.4489e+11 Prob > F = 0.0000 Residual | 5.9644e+12 8229 724804033 R-square = 0.1272 ---------+------------------------------ Adj R-square = 0.1266 Total | 6.8338e+12 8235 829843442 Root MSE = 26922 ---------------------------------------------------------------------- -------- KInc89 | Coef. Std. Err. t P>|t| [95% Conf. Interval] --------- +-------------------------------------------------------------------- zIQYr89 | 3962.696 438.2684 9.042 0.000 3103.579 4821.812 zEd90 | 6448.596 399.9198 16.125 0.000 5664.653 7232.54 black | -7301.72 983.2484 -7.426 0.000 -9229.135 - 5374.305 hisp | -2646.299 1332.087 -1.987 0.047 -5257.526 - 35.07262 OthRace | -3089.505 1392.44 -2.219 0.027 -5819.04 - 359.9709 BornWher | 4761.82 1622.005 2.936 0.003 1582.281 7941.359 _cons | 38617.22 353.0091 109.394 0.000 37925.23 39309.21 ---------------------------------------------------------------------- -------- . regress zIQYr89 black hisp OthRace gender BornWher [aweight=Wgt90]; (sum of wgt is 3.1984e+07) Source | SS df MS Number of obs = 9960 ---------+------------------------------ F( 5, 9954) = 431.17 Model | 1763.85638 5 352.771276 Prob > F = 0.0000 Residual | 8144.10772 9954 .818174374 R-square = 0.1780 ---------+------------------------------ Adj R-square = 0.1776 Total | 9907.9641 9959 .994875399 Root MSE = .90453 ---------------------------------------------------------------------- -------- zIQYr89 | Coef. Std. Err. t P>|t| [95% Conf. Interval] --------- +-------------------------------------------------------------------- black | -1.109859 .0261927 -42.373 0.000 -1.161202 - 1.058516 hisp | -.8069482 .038699 -20.852 0.000 -.882806 - .7310903 OthRace | -.3003512 .0428323 -7.012 0.000 -.3843112 - .2163912 gender | .0515745 .01813 2.845 0.004 .016036 .087113 BornWher | -.2154726 .0471562 -4.569 0.000 -.3079082 - .1230369 _cons | .1990593 .0139931 14.226 0.000 .17163 .2264885 ---------------------------------------------------------------------- -------- . * ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~--; . * ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~--; . save nation1.dta,replace; file nation1.dta saved . * ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~--; . * ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~--; . end of do-file . exit,clear