------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ log: C:\Documents and Settings\yhuang7\Desktop\2008 Spring Angrist\QOB_VI.log log type: text opened on: 6 May 2008, 13:41:58 . . set mem 500m Current memory allocation current memory usage settable value description (1M = 1024k) -------------------------------------------------------------------- set maxvar 5000 max. variables allowed 1.909M set memory 500M max. data space 500.000M set matsize 400 max. RHS vars in models 1.254M ----------- 503.163M . use "C:\Documents and Settings\yhuang7\Desktop\2008 Spring Angrist\QOB_stata_data.dta" . rename v1 AGE . rename v2 AGEQ . rename v4 EDUC . rename v5 ENOCENT . rename v6 ESOCENT . rename v9 LWKLYWGE . rename v10 MARRIED . rename v11 MIDATL . rename v12 MT . rename v13 NEWENG . rename v16 CENSUS . rename v18 QOB . rename v19 RACE . rename v20 SMSA . rename v21 SOATL . rename v24 WNOCENT . rename v25 WSOCENT . rename v27 YOB . drop v8 . gen COHORT=20.29 . replace COHORT=30.39 if YOB<=39 & YOB >=30 (329509 real changes made) . replace COHORT=40.49 if YOB<=49 & YOB >=40 (486926 real changes made) . replace AGEQ=AGEQ-1900 if CENSUS==80 (816435 real changes made) . gen AGEQSQ= AGEQ*AGEQ . . ** Generate YOB dummies ********** . gen YR20=0 . replace YR20=1 if YOB==1920 (23725 real changes made) . replace YR20=1 if YOB==30 (33602 real changes made) . replace YR20=1 if YOB==40 (38218 real changes made) . gen YR21=0 . replace YR21=1 if YOB==1921 (24978 real changes made) . replace YR21=1 if YOB==31 (30583 real changes made) . replace YR21=1 if YOB==41 (38387 real changes made) . gen YR22=0 . replace YR22=1 if YOB==1922 (24264 real changes made) . replace YR22=1 if YOB==32 (32211 real changes made) . replace YR22=1 if YOB==42 (45018 real changes made) . gen YR23=0 . replace YR23=1 if YOB==1923 (24345 real changes made) . replace YR23=1 if YOB==33 (30751 real changes made) . replace YR23=1 if YOB==43 (46349 real changes made) . gen YR24=0 . replace YR24=1 if YOB==1924 (25548 real changes made) . replace YR24=1 if YOB==34 (31916 real changes made) . replace YR24=1 if YOB==44 (44387 real changes made) . gen YR25=0 . replace YR25=1 if YOB==1925 (24834 real changes made) . replace YR25=1 if YOB==35 (32773 real changes made) . replace YR25=1 if YOB==45 (44546 real changes made) . gen YR26=0 . replace YR26=1 if YOB==1926 (24431 real changes made) . replace YR26=1 if YOB==36 (32676 real changes made) . replace YR26=1 if YOB==46 (54122 real changes made) . gen YR27=0 . replace YR27=1 if YOB==1927 (25650 real changes made) . replace YR27=1 if YOB==37 (33969 real changes made) . replace YR27=1 if YOB==47 (60788 real changes made) . gen YR28=0 . replace YR28=1 if YOB==1928 (24614 real changes made) . replace YR28=1 if YOB==38 (35223 real changes made) . replace YR28=1 if YOB==48 (57692 real changes made) . gen YR29=0 . replace YR29=1 if YOB==1929 (24810 real changes made) . replace YR29=1 if YOB==39 (35805 real changes made) . replace YR29=1 if YOB==49 (57419 real changes made) . . ** Generate QOB dummies *********** . gen QTR1=0 . replace QTR1=1 if QOB==1 (262019 real changes made) . gen QTR2=0 . replace QTR2=1 if QOB==2 (255733 real changes made) . gen QTR3=0 . replace QTR3=1 if QOB==3 (280749 real changes made) . gen QTR4=0 . replace QTR4=1 if QOB==4 (265133 real changes made) . . ** Generate YOB*QOB dummies ******** . gen QTR120= QTR1*YR20 . gen QTR121= QTR1*YR21 . gen QTR122= QTR1*YR22 . gen QTR123= QTR1*YR23 . gen QTR124= QTR1*YR24 . gen QTR125= QTR1*YR25 . gen QTR126= QTR1*YR26 . gen QTR127= QTR1*YR27 . gen QTR128= QTR1*YR28 . gen QTR129= QTR1*YR29 . . gen QTR220= QTR2*YR20 . gen QTR221= QTR2*YR21 . gen QTR222= QTR2*YR22 . gen QTR223= QTR2*YR23 . gen QTR224= QTR2*YR24 . gen QTR225= QTR2*YR25 . gen QTR226= QTR2*YR26 . gen QTR227= QTR2*YR27 . gen QTR228= QTR2*YR28 . gen QTR229= QTR2*YR29 . . gen QTR320= QTR3*YR20 . gen QTR321= QTR3*YR21 . gen QTR322= QTR3*YR22 . gen QTR323= QTR3*YR23 . gen QTR324= QTR3*YR24 . gen QTR325= QTR3*YR25 . gen QTR326= QTR3*YR26 . gen QTR327= QTR3*YR27 . gen QTR328= QTR3*YR28 . gen QTR329= QTR3*YR29 . . . keep if COHORT>40.00 (576708 observations deleted) . . ** Col 1 3 5 7 *** . reg LWKLYWGE EDUC YR20-YR28 Source | SS df MS Number of obs = 486926 -------------+------------------------------ F( 10,486915) = 4396.64 Model | 16795.7577 10 1679.57577 Prob > F = 0.0000 Residual | 186007.985486915 .382013257 R-squared = 0.0828 -------------+------------------------------ Adj R-squared = 0.0828 Total | 202803.743486925 .416498932 Root MSE = .61807 ------------------------------------------------------------------------------ LWKLYWGE | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- EDUC | .0573383 .0002981 192.37 0.000 .0567541 .0579224 YR20 | .2510504 .0040846 61.46 0.000 .2430446 .2590561 YR21 | .2426493 .004078 59.50 0.000 .2346565 .2506421 YR22 | .2309454 .0038924 59.33 0.000 .2233165 .2385743 YR23 | .2186718 .0038606 56.64 0.000 .2111052 .2262385 YR24 | .1822308 .0039072 46.64 0.000 .1745728 .1898889 YR25 | .1538481 .0039026 39.42 0.000 .1461991 .1614972 YR26 | .1206861 .0037029 32.59 0.000 .1134286 .1279437 YR27 | .0851009 .0035969 23.66 0.000 .0780511 .0921508 YR28 | .0402911 .0036434 11.06 0.000 .03315 .0474321 _cons | 4.878781 .0048444 1007.10 0.000 4.869286 4.888276 ------------------------------------------------------------------------------ . reg LWKLYWGE EDUC YR20-YR28 AGEQ AGEQSQ Source | SS df MS Number of obs = 486926 -------------+------------------------------ F( 12,486913) = 3668.22 Model | 16814.1046 12 1401.17538 Prob > F = 0.0000 Residual | 185989.638486913 .381977146 R-squared = 0.0829 -------------+------------------------------ Adj R-squared = 0.0829 Total | 202803.743486925 .416498932 Root MSE = .61804 ------------------------------------------------------------------------------ LWKLYWGE | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- EDUC | .0573461 .0002981 192.38 0.000 .0567619 .0579304 YR20 | .110682 .0292461 3.78 0.000 .0533606 .1680035 YR21 | .0991362 .0257848 3.84 0.000 .0485988 .1496737 YR22 | .0890475 .0230196 3.87 0.000 .0439299 .1341651 YR23 | .0828728 .0207946 3.99 0.000 .042116 .1236296 YR24 | .0574244 .0186061 3.09 0.002 .020957 .0938917 YR25 | .0446047 .0162411 2.75 0.006 .0127727 .0764367 YR26 | .0327306 .013272 2.47 0.014 .0067179 .0587434 YR27 | .0207241 .0100957 2.05 0.040 .0009369 .0405114 YR28 | .0059328 .0062818 0.94 0.345 -.0063793 .018245 AGEQ | .1799818 .0389345 4.62 0.000 .1036715 .2562922 AGEQSQ | -.0023404 .0005592 -4.19 0.000 -.0034364 -.0012444 _cons | 1.5622 .6709312 2.33 0.020 .2471952 2.877204 ------------------------------------------------------------------------------ . reg LWKLYWGE EDUC RACE MARRIED SMSA NEWENG MIDATL ENOCENT WNOCENT SOATL ESOCENT WSOCENT MT YR20-YR28 Source | SS df MS Number of obs = 486926 -------------+------------------------------ F( 21,486904) = 3447.63 Model | 26252.3155 21 1250.11026 Prob > F = 0.0000 Residual | 176551.427486904 .362600075 R-squared = 0.1294 -------------+------------------------------ Adj R-squared = 0.1294 Total | 202803.743486925 .416498932 Root MSE = .60216 ------------------------------------------------------------------------------ LWKLYWGE | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- EDUC | .0520464 .0002971 175.19 0.000 .0514641 .0526287 RACE | -.2107128 .0032215 -65.41 0.000 -.2170268 -.2043988 MARRIED | .2445162 .0022017 111.06 0.000 .2402009 .2488314 SMSA | -.1418395 .0022877 -62.00 0.000 -.1463234 -.1373556 NEWENG | -.0925392 .0043444 -21.30 0.000 -.1010541 -.0840243 MIDATL | -.0143339 .0032692 -4.38 0.000 -.0207415 -.0079263 ENOCENT | .0428862 .0031058 13.81 0.000 .036799 .0489734 WNOCENT | -.0701283 .0039399 -17.80 0.000 -.0778503 -.0624063 SOATL | -.1050696 .0032102 -32.73 0.000 -.1113615 -.0987776 ESOCENT | -.1202768 .0041859 -28.73 0.000 -.128481 -.1120727 WSOCENT | -.0583213 .0036588 -15.94 0.000 -.0654924 -.0511502 MT | -.0674863 .0044884 -15.04 0.000 -.0762833 -.0586892 YR20 | .2239961 .0039853 56.21 0.000 .2161849 .2318072 YR21 | .2158427 .0039785 54.25 0.000 .2080449 .2236405 YR22 | .2031091 .0037979 53.48 0.000 .1956653 .2105529 YR23 | .1929448 .0037664 51.23 0.000 .1855627 .2003269 YR24 | .1619856 .0038101 42.51 0.000 .1545179 .1694532 YR25 | .1365743 .0038049 35.89 0.000 .1291169 .1440317 YR26 | .1049269 .0036098 29.07 0.000 .0978518 .112002 YR27 | .0731486 .0035057 20.87 0.000 .0662775 .0800196 YR28 | .0350116 .00355 9.86 0.000 .0280537 .0419695 _cons | 4.853827 .0057009 851.41 0.000 4.842654 4.865001 ------------------------------------------------------------------------------ . reg LWKLYWGE EDUC RACE MARRIED SMSA NEWENG MIDATL ENOCENT WNOCENT SOATL ESOCENT WSOCENT MT YR20-YR28 AGEQ AGEQSQ Source | SS df MS Number of obs = 486926 -------------+------------------------------ F( 23,486902) = 3149.93 Model | 26267.5972 23 1142.06944 Prob > F = 0.0000 Residual | 176536.145486902 .362570179 R-squared = 0.1295 -------------+------------------------------ Adj R-squared = 0.1295 Total | 202803.743486925 .416498932 Root MSE = .60214 ------------------------------------------------------------------------------ LWKLYWGE | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- EDUC | .0520558 .0002971 175.21 0.000 .0514735 .0526382 RACE | -.2107622 .0032214 -65.43 0.000 -.217076 -.2044484 MARRIED | .2444055 .0022017 111.01 0.000 .2400903 .2487207 SMSA | -.1418543 .0022876 -62.01 0.000 -.146338 -.1373705 NEWENG | -.0926402 .0043443 -21.32 0.000 -.1011548 -.0841256 MIDATL | -.0143314 .0032691 -4.38 0.000 -.0207387 -.0079241 ENOCENT | .0429411 .0031057 13.83 0.000 .0368541 .0490281 WNOCENT | -.070033 .0039397 -17.78 0.000 -.0777548 -.0623113 SOATL | -.1050156 .0032101 -32.71 0.000 -.1113074 -.0987239 ESOCENT | -.1202851 .0041857 -28.74 0.000 -.1284889 -.1120812 WSOCENT | -.058082 .0036589 -15.87 0.000 -.0652533 -.0509108 MT | -.0675454 .0044882 -15.05 0.000 -.0763421 -.0587487 YR20 | .0875108 .0284969 3.07 0.002 .0316579 .1433638 YR21 | .0789526 .0251245 3.14 0.002 .0297093 .1281959 YR22 | .0697974 .0224299 3.11 0.002 .0258356 .1137592 YR23 | .0668501 .0202619 3.30 0.001 .0271373 .1065629 YR24 | .0472473 .0181292 2.61 0.009 .0117145 .08278 YR25 | .0369685 .0158246 2.34 0.019 .0059527 .0679842 YR26 | .0253141 .0129317 1.96 0.050 -.0000316 .0506598 YR27 | .015208 .0098365 1.55 0.122 -.0040714 .0344873 YR28 | .0042516 .0061205 0.69 0.487 -.0077443 .0162475 AGEQ | .1517973 .0379337 4.00 0.000 .0774484 .2261462 AGEQSQ | -.0019453 .0005448 -3.57 0.000 -.0030131 -.0008774 _cons | 2.029773 .65369 3.11 0.002 .7485607 3.310985 ------------------------------------------------------------------------------ . . . ** Col 2 4 6 8 *** . ivregress 2sls LWKLYWGE YR20-YR28 (EDUC = QTR120-QTR129 QTR220-QTR229 QTR320-QTR329 YR20-YR28) Instrumental variables (2SLS) regression Number of obs = 486926 Wald chi2(10) = 6974.38 Prob > chi2 = 0.0000 R-squared = 0.0827 Root MSE = .61809 ------------------------------------------------------------------------------ LWKLYWGE | Coef. Std. Err. z P>|z| [95% Conf. Interval] -------------+---------------------------------------------------------------- EDUC | .0552978 .0137563 4.02 0.000 .0283359 .0822597 YR20 | .2497603 .0096072 26.00 0.000 .2309305 .2685901 YR21 | .2415559 .0084228 28.68 0.000 .2250475 .2580643 YR22 | .2302052 .0063281 36.38 0.000 .2178023 .242608 YR23 | .2180262 .0058173 37.48 0.000 .2066244 .229428 YR24 | .1816571 .0054976 33.04 0.000 .170882 .1924321 YR25 | .1535557 .0043722 35.12 0.000 .1449863 .1621251 YR26 | .1206802 .0037033 32.59 0.000 .113422 .1279384 YR27 | .0852128 .0036752 23.19 0.000 .0780095 .0924161 YR28 | .040319 .0036484 11.05 0.000 .0331682 .0474698 _cons | 4.906853 .1892754 25.92 0.000 4.53588 5.277826 ------------------------------------------------------------------------------ Instrumented: EDUC Instruments: YR20 YR21 YR22 YR23 YR24 YR25 YR26 YR27 YR28 QTR120 QTR121 QTR122 QTR123 QTR124 QTR125 QTR126 QTR127 QTR128 QTR129 QTR220 QTR221 QTR222 QTR223 QTR224 QTR225 QTR226 QTR227 QTR228 QTR229 QTR320 QTR321 QTR322 QTR323 QTR324 QTR325 QTR326 QTR327 QTR328 QTR329 . ivregress 2sls LWKLYWGE YR20-YR28 AGEQ AGEQSQ (EDUC = QTR120-QTR129 QTR220-QTR229 QTR320-QTR329 YR20-YR28) note: QTR329 dropped due to collinearity Instrumental variables (2SLS) regression Number of obs = 486926 Wald chi2(12) = 6805.98 Prob > chi2 = 0.0000 R-squared = 0.0532 Root MSE = .62797 ------------------------------------------------------------------------------ LWKLYWGE | Coef. Std. Err. z P>|z| [95% Conf. Interval] -------------+---------------------------------------------------------------- EDUC | .0947988 .0222744 4.26 0.000 .0511417 .1384558 YR20 | .0819031 .034292 2.39 0.017 .014692 .1491141 YR21 | .0786832 .0288848 2.72 0.006 .0220699 .1352964 YR22 | .0726292 .0253455 2.87 0.004 .0229529 .1223054 YR23 | .0733603 .0218729 3.35 0.001 .0304902 .1162305 YR24 | .0540046 .0190141 2.84 0.005 .0167376 .0912716 YR25 | .041836 .016584 2.52 0.012 .009332 .07434 YR26 | .0291723 .0136503 2.14 0.033 .0024182 .0559264 YR27 | .0176111 .0104236 1.69 0.091 -.0028188 .038041 YR28 | .005663 .0063848 0.89 0.375 -.0068509 .0181769 AGEQ | .1325366 .0485908 2.73 0.006 .0373003 .2277729 AGEQSQ | -.001582 .0007254 -2.18 0.029 -.0030038 -.0001602 _cons | 1.788565 .6948756 2.57 0.010 .4266337 3.150496 ------------------------------------------------------------------------------ Instrumented: EDUC Instruments: YR20 YR21 YR22 YR23 YR24 YR25 YR26 YR27 YR28 AGEQ AGEQSQ QTR120 QTR121 QTR122 QTR123 QTR124 QTR125 QTR126 QTR127 QTR128 QTR129 QTR220 QTR221 QTR222 QTR223 QTR224 QTR225 QTR226 QTR227 QTR228 QTR229 QTR320 QTR321 QTR322 QTR323 QTR324 QTR325 QTR326 QTR327 QTR328 . ivregress 2sls LWKLYWGE YR20-YR28 RACE MARRIED SMSA NEWENG MIDATL ENOCENT WNOCENT SOATL ESOCENT WSOCENT MT (EDUC = QTR120-QTR129 QTR220-QTR229 QTR320-QTR329 YR20-YR28) Instrumental variables (2SLS) regression Number of obs = 486926 Wald chi2(21) =41560.34 Prob > chi2 = 0.0000 R-squared = 0.1261 Root MSE = .60329 ------------------------------------------------------------------------------ LWKLYWGE | Coef. Std. Err. z P>|z| [95% Conf. Interval] -------------+---------------------------------------------------------------- EDUC | .0392721 .0144917 2.71 0.007 .0108689 .0676752 YR20 | .2159624 .0099482 21.71 0.000 .1964644 .2354605 YR21 | .2090259 .0086986 24.03 0.000 .191977 .2260749 YR22 | .1982641 .0066839 29.66 0.000 .1851639 .2113644 YR23 | .1887218 .0060976 30.95 0.000 .1767708 .2006728 YR24 | .1582408 .0057106 27.71 0.000 .1470482 .1694334 YR25 | .134654 .0043903 30.67 0.000 .1260491 .1432589 YR26 | .1046187 .0036334 28.79 0.000 .0974973 .1117401 YR27 | .073587 .0035473 20.74 0.000 .0666344 .0805395 YR28 | .0351145 .0035586 9.87 0.000 .0281399 .0420892 RACE | -.2266122 .0183196 -12.37 0.000 -.2625179 -.1907065 MARRIED | .2442122 .0022326 109.39 0.000 .2398364 .248588 SMSA | -.1535466 .0134745 -11.40 0.000 -.1799562 -.127137 NEWENG | -.0967104 .0064286 -15.04 0.000 -.1093101 -.0841107 MIDATL | -.0204337 .0076545 -2.67 0.008 -.0354363 -.0054311 ENOCENT | .0326842 .0119822 2.73 0.006 .0091996 .0561688 WNOCENT | -.0755498 .007307 -10.34 0.000 -.0898712 -.0612284 SOATL | -.1157321 .0125137 -9.25 0.000 -.1402586 -.0912056 ESOCENT | -.1361323 .0184657 -7.37 0.000 -.1723245 -.0999401 WSOCENT | -.066576 .0100545 -6.62 0.000 -.0862823 -.0468696 MT | -.0678943 .0045205 -15.02 0.000 -.0767544 -.0590343 _cons | 5.040699 .2120262 23.77 0.000 4.625135 5.456262 ------------------------------------------------------------------------------ Instrumented: EDUC Instruments: YR20 YR21 YR22 YR23 YR24 YR25 YR26 YR27 YR28 RACE MARRIED SMSA NEWENG MIDATL ENOCENT WNOCENT SOATL ESOCENT WSOCENT MT QTR120 QTR121 QTR122 QTR123 QTR124 QTR125 QTR126 QTR127 QTR128 QTR129 QTR220 QTR221 QTR222 QTR223 QTR224 QTR225 QTR226 QTR227 QTR228 QTR229 QTR320 QTR321 QTR322 QTR323 QTR324 QTR325 QTR326 QTR327 QTR328 QTR329 . ivregress 2sls LWKLYWGE YR20-YR28 RACE MARRIED SMSA NEWENG MIDATL ENOCENT WNOCENT SOATL ESOCENT WSOCENT MT AGEQ AGEQSQ (EDUC = QTR120-QTR129 QTR220-QTR229 QTR320-QTR329 > YR20-YR28) note: QTR329 dropped due to collinearity Instrumental variables (2SLS) regression Number of obs = 486926 Wald chi2(23) =41126.04 Prob > chi2 = 0.0000 R-squared = 0.1160 Root MSE = .60678 ------------------------------------------------------------------------------ LWKLYWGE | Coef. Std. Err. z P>|z| [95% Conf. Interval] -------------+---------------------------------------------------------------- EDUC | .0778813 .0238716 3.26 0.001 .0310937 .1246688 YR20 | .0694183 .0332306 2.09 0.037 .0042876 .134549 YR21 | .0661273 .0279558 2.37 0.018 .011335 .1209196 YR22 | .0598049 .0244168 2.45 0.014 .0119488 .1076609 YR23 | .0612152 .0210718 2.91 0.004 .0199153 .1025152 YR24 | .0454753 .0183422 2.48 0.013 .0095253 .0814252 YR25 | .035314 .0160197 2.20 0.027 .0039161 .066712 YR26 | .0233475 .0131575 1.77 0.076 -.0024407 .0491357 YR27 | .0134789 .0100403 1.34 0.179 -.0061997 .0331576 YR28 | .0041179 .0061688 0.67 0.504 -.0079728 .0162086 RACE | -.1786485 .0298588 -5.98 0.000 -.2371707 -.1201263 MARRIED | .2450111 .0022881 107.08 0.000 .2405265 .2494958 SMSA | -.1181933 .0219904 -5.37 0.000 -.1612936 -.075093 NEWENG | -.084209 .0089382 -9.42 0.000 -.1017275 -.0666905 MIDATL | -.0019909 .0118722 -0.17 0.867 -.02526 .0212781 ENOCENT | .0635777 .0193289 3.29 0.001 .0256938 .1014617 WNOCENT | -.0590542 .0108964 -5.42 0.000 -.0804108 -.0376976 SOATL | -.0834603 .0201839 -4.13 0.000 -.1230201 -.0439006 ESOCENT | -.0882384 .0299187 -2.95 0.003 -.146878 -.0295988 WSOCENT | -.0413572 .0158919 -2.60 0.009 -.0725048 -.0102097 MT | -.0667398 .0045836 -14.56 0.000 -.0757236 -.057756 AGEQ | .1214883 .0473919 2.56 0.010 .0286019 .2143748 AGEQSQ | -.0014595 .0007092 -2.06 0.040 -.0028496 -.0000694 _cons | 2.124536 .6645233 3.20 0.001 .822094 3.426978 ------------------------------------------------------------------------------ Instrumented: EDUC Instruments: YR20 YR21 YR22 YR23 YR24 YR25 YR26 YR27 YR28 RACE MARRIED SMSA NEWENG MIDATL ENOCENT WNOCENT SOATL ESOCENT WSOCENT MT AGEQ AGEQSQ QTR120 QTR121 QTR122 QTR123 QTR124 QTR125 QTR126 QTR127 QTR128 QTR129 QTR220 QTR221 QTR222 QTR223 QTR224 QTR225 QTR226 QTR227 QTR228 QTR229 QTR320 QTR321 QTR322 QTR323 QTR324 QTR325 QTR326 QTR327 QTR328 . . . print @Results . end of do-file . exit, clear