----------------------------------------------------------------------------------------------- log: /disk/nber10/SCCS/sipp/2004/master_wealth.log log type: text opened on: 4 Aug 2009, 12:52:34 . set mem 500m (512000k) . use ~/bulk/sipp/sipp04t3 . append using ~/bulk/sipp/sipp93t7 (note: ssuid is float in using data but will be str12 now) (note: shhadid is str2 in using data but will be int now) . append using ~/bulk/sipp/sipp93t4 tm8538 was byte now long tm8540 was byte now long (label state already defined) (label item36b already defined) (label intvw already defined) (label pp_mis1l already defined) (label pp_mis2l already defined) (label pp_mis3l already defined) (label pp_mis4l already defined) (label pp_mis5l already defined) (label rrp already defined) (label age already defined) (label sex already defined) (label race already defined) (label ms already defined) (label pnsp already defined) (label pnpt already defined) (label higrade already defined) (label grd_cmpl already defined) (label ethnicty already defined) (label tm8032l already defined) (label tm8034l already defined) (label tm8042l already defined) (label tm8044l already defined) (label tm8052l already defined) (label tm8054l already defined) (label tm8068l already defined) (label tm8072l already defined) (label tm8074l already defined) (label tm8076l already defined) (label tm8078l already defined) (label tm8092l already defined) (label tm8096l already defined) (label tm8098l already defined) (label tm8100l already defined) (label tm8102l already defined) (label tm8116l already defined) (label tm8118l already defined) (label tm8120l already defined) (label tm8122l already defined) (label tm8130l already defined) (label tm8132l already defined) (label tm8204l already defined) (label tm8206l already defined) (label tm8208l already defined) (label tm8209l already defined) (label tm8210l already defined) (label tm8232l already defined) (label tm8233l already defined) (label tm8258l already defined) (label tm8260l already defined) (label tm8262l already defined) (label tm8264l already defined) (label tm8284l already defined) (label tm8286l already defined) (label tm8288l already defined) (label tm8308l already defined) (label tm8312l already defined) (label tm8400l already defined) (label tm8402l already defined) (label tm8404l already defined) (label tm8406l already defined) (label tm8408l already defined) (label tm8410l already defined) (label tm8412l already defined) (label tm8416l already defined) (label tm8418l already defined) (label tm8420l already defined) (label tm8422l already defined) (label tm8424l already defined) (label tm8426l already defined) (label tm8428l already defined) (label tm8526l already defined) (label tm8530l already defined) (label tm8538l already defined) (label tm8540l already defined) (label tm8564l already defined) (label tm8658l already defined) (label tm8660l already defined) (label tm8662l already defined) (label tm8664l already defined) (label tm8666l already defined) (label tm8714l already defined) (label tm8716l already defined) (label tm8730l already defined) (label tm8754l already defined) (label tm8760l already defined) (label tm8763l already defined) (label tm8766l already defined) (label tm8732l already defined) (label tm8756l already defined) (label tm8761l already defined) (label tm8764l already defined) (label tm8768l already defined) (label tm8734l already defined) (label tm8758l already defined) (label tm8762l already defined) (label tm8765l already defined) (label tm8788l already defined) (label tm8792l already defined) (label tm8796l already defined) (label tm8800l already defined) (label tm8790l already defined) (label tm8794l already defined) (label tm8798l already defined) . ** Subsequent waves have more information . ** 1993t4 has no home equity! . gen wealth1993t4 = vehicle +bank_int+oth_int+stock_no_debt+oreal+oth_ass4+ira . note wealth1993t4: vehicle +bank_int+oth_int+stock_no_debt+oreal+oth_ass4+ira . label variable wealth1993t4 " vehicle +bank_int+oth_int+stock_no_debt+oreal+oth_ > ass4+ira" . gen wealth1993t7 = home+vehicle +bank_int+oth_int+stock +oreal+oth_ass +ira (52954 missing values generated) . note wealth1993t7: home+vehicle +bank_int+oth_int+stock +oreal+oth_ass +ira . label variable wealth1993t7 " home+vehicle +bank_int+oth_int+stock +oreal+oth_ > ass +ira" . ** wealth needs to be a double to preserve precision . gen double wealth2004t3 = home+vehicle+business+bank_int+oth_int+stock +oreal+oth_ass > +ira+thrift (103616 missing values generated) . note wealth2004t3: home+vehicle+business+bank_int+oth_int+stock +oreal+oth_ass +ira+th > rift . label var wealth2004t3 " home+vehicle+business+bank_int+oth_int+stock +oreal+oth_ass + > ira+thrift" . note home: (tpropval+tmhval)-thhmortg OR (tm8598+tm8630)-hh_mortg . #delimit ; delimiter now ; . note vehicle: (tcarval1-ta1amt)+(tcarval2-ta2amt)+(tcarval3-ta3amt)+(tov1val-tov1amt)+(tov2va > l-tov2amt) > OR (tmcarvl1-tm8760)+(tmcarvl2-tm8761)+(tmcarvl3-tm8762)+(tm8788-tm8796)+(tm8790-tm8798) ; . note business: (evbow1/100*(tvbva1-tvbde1))+(evbow2/100*(tvbva2-tvbde2)) , not replicable in > pre-1996 data ; . note bank_int: tiajta+tiaita OR sc4314_a+sc4322_a ; . note oth_int: timja+timia OR tm4414_a+tm4422_a OR sc4414_a+sc4422_a ; . note stock: (esmjv-esmjmav)+(esmiv-esmimav) OR (tm8034_a-tm8040)+(tm8044-tm8050) ; . note stock_no_debt: (esmjv)+(esmiv) OR (tm8034_a)+(tm8044) ; . note oreal: tothreva+trtsha+(trjmv-trjpri)+(trimv-tripri) OR tm8122_a+(tm8068-tm8074_a)+(tm80 > 92-tm8098_a) ; . note oth_ass: tmjp+tmip+eoaeq+ealowa+talsbv+taljcha+talicha OR tm8126_a+tm8128_a+tm8132_a+tm8 > 202+tm8206+tm8210_a+tm8233_a ; . note oth_ass4: eoaeq+talsbv+taljcha+talicha OR tm8132_a+tm8206+tm8210_a+tm8233_a ; . note ira: talrb+talkb OR tm8264+tm8288 ; . note thrift: taltb , not asked in 1993 ; . #delimit cr delimiter now cr . sum wealth2004t3 thhtwlth Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- wealth2004t3 | 99978 206461.6 888339.9 -267185 1.05e+08 thhtwlth | 99978 206553.9 888564.6 -267185 1.05e+08 . sum wealth2004t3 thhtwlth if thhotast==oth_ass Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- wealth2004t3 | 99909 205677.3 887839.3 -267185 1.05e+08 thhtwlth | 99909 205677.3 887839.3 -267185 1.05e+08 . assert abs(thhtwlth-wealth2004t3)<=1 if thhotast==oth_ass & fileid=="2004t3" . sum thhotast oth_ass if thhotast!=oth_ass & fileid=="2004t3" Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- thhotast | 69 622106.5 306882.7 215000 2050000 oth_ass | 69 488352.9 193064.7 200000 670000 . bysort fileid: sum wealth1993t4 ----------------------------------------------------------------------------------------------- -> fileid = 1993t4 Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- wealth1993t4 | 52954 42688.26 104449.1 -9700 2271425 ----------------------------------------------------------------------------------------------- -> fileid = 1993t7 Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- wealth1993t4 | 50662 46842.34 111321.1 -10800 2731498 ----------------------------------------------------------------------------------------------- -> fileid = 2004t3 Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- wealth1993t4 | 99978 76190.18 847766.9 -317533 1.05e+08 . bysort fileid: sum wealth1993t7 ----------------------------------------------------------------------------------------------- -> fileid = 1993t4 Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- wealth1993t7 | 0 ----------------------------------------------------------------------------------------------- -> fileid = 1993t7 Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- wealth1993t7 | 50662 91611.96 149708.1 -17485 3026343 ----------------------------------------------------------------------------------------------- -> fileid = 2004t3 Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- wealth1993t7 | 99978 164715.2 869714.4 -241826 1.05e+08 . bysort fileid: sum wealth2004t3 ----------------------------------------------------------------------------------------------- -> fileid = 1993t4 Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- wealth2004t3 | 0 ----------------------------------------------------------------------------------------------- -> fileid = 1993t7 Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- wealth2004t3 | 0 ----------------------------------------------------------------------------------------------- -> fileid = 2004t3 Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- wealth2004t3 | 99978 206461.6 888339.9 -267185 1.05e+08 . sum wealth?????? if fileid=="2004t3" Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- wealth1993t4 | 99978 76190.18 847766.9 -317533 1.05e+08 wealth1993t7 | 99978 164715.2 869714.4 -241826 1.05e+08 wealth2004t3 | 99978 206461.6 888339.9 -267185 1.05e+08 . sum wealth1993t? if fileid=="1993t7" Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- wealth1993t4 | 50662 46842.34 111321.1 -10800 2731498 wealth1993t7 | 50662 91611.96 149708.1 -17485 3026343 . sum wealth1993t4 if fileid=="1993t4" Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- wealth1993t4 | 52954 42688.26 104449.1 -9700 2271425 . end of do-file . exit,clear