SIPP Technical Documentation http://www.census.gov/apsd/techdoc/sipp/sipp.html wget http://www.census.gov/apsd/techdoc/sipp/sipp04w12c.pdf ## Panel Questionnaires http://www.census.gov/sipp/core_content/2004/2004.html http://www.census.gov/sipp/core_content/2004/quests/wave2/2004w2core.pdf http://www.census.gov/sipp/core_content/2004/quests/wave1/2004w1core.pdf ## Topical Module Questionnaires 1-8 http://www.census.gov/sipp/top_mod/2004/topmod04rev.html http://www.census.gov/sipp/top_mod/2004/quests/2004w1tm.pdf duplicates report ssuid epppnum srefmon unique identifier http://www.allbusiness.com/government/government-bodies-offices/12386428-1.html looked interesting Complex sample design effects and health insurance variance estimation. By Nielsen, Robert B.,Davern, Michael,Jones, Arthur, Jr.,Boies, John L. Publication: Journal of Consumer Affairs Date: Monday, June 22 2009 *** readme_dir.txt *** NBERName,Title,Txt Data Dictionary Name,Zip Data Name,Min,Max,Dir sipp2004_lw1-12,Longitudnal Weight (Waves 1-12),lgt04w12d,lgtwgt2004w12,,,/homes/data/sipp/www.sipp.census.gov/pub/sipp/2004 sipp2004_lrwcyN,Longitudnal Replicate Weight for Calendar Year 200X,lrw04_xx,lrw04_cyN,1,4,/homes/data/sipp/www.sipp.census.gov/pub/cps/march/sipp2/2004 sipp2004_lrwpnlN,Longitudnal Replicate Weight for Panel through Year 200X,lrw04_xx,lrw04_pnlN,1,4,/homes/data/sipp/www.sipp.census.gov/pub/cps/march/sipp2/2004 sipp2004_coreN,Wave X Core Data,l04puw1d,l04puwX,1,12,/homes/data/sipp/www.sipp.census.gov/pub/sipp/2004 sipp2004_rwN,Wave X Replicate Weight,rw04wxd,rw04wX,1,12,/homes/data/sipp/www.sipp.census.gov/pub/cps/march/sipp2/2004 sipp2004_topN,Wave X Topical Module,p04tmXd,p04putmX,1,8,/homes/data/sipp/www.sipp.census.gov/pub/sipp/2004 *** readme_nber.txt **** NBERName,Title,Txt Data Dictionary Name,Zip Data Name,Min,Max,Dir sipp2004lw12,Longitudnal Weight (Waves 1-12),lgt04w12d,lgtwgt2004w12,,,/homes/data/sipp/www.sipp.census.gov/pub/sipp/2004 sipp2004lrwcyN,Longitudnal Replicate Weight for Calendar Year 200X,lrw04_xx,lrw04_cyN,1,4,/homes/data/sipp/www.sipp.census.gov/pub/cps/march/sipp2/2004 sipp2004lrwpnlN,Longitudnal Replicate Weight for Panel through Year 200X,lrw04_xx,lrw04_pnlN,1,4,/homes/data/sipp/www.sipp.census.gov/pub/cps/march/sipp2/2004 sipp2004cN,Wave X Core Data,l04puw1d,l04puwX,1,12,/homes/data/sipp/www.sipp.census.gov/pub/sipp/2004 sipp2004rwN,Wave X Replicate Weight,rw04wxd,rw04wX,1,12,/homes/data/sipp/www.sipp.census.gov/pub/cps/march/sipp2/2004 sipp2004tN,Wave X Topical Module,p04tmXd,p04putmX,1,8,/homes/data/sipp/www.sipp.census.gov/pub/sipp/2004 RHHTWLTH = RHHTHEQ + RHHVEHCL + RHHBEQ + RHHINTBK + RHHINTOT + RHHSTK + RHHORE + RHHOTAST + RHHIRA+RHHTHRIF ********************************************************************** ** Checking that sample unit and person ids are unique identifiers duplicates report ssuid epppnum assert `r(unique_value)'==`r(N)' ** Note that a sample unit may contain multiple households identified by shhadid ********************************************************************** ** Total Wealth describe thhtwlth thhtheq thhvehcl thhbeq thhintbk thhintot rhhstk thhore thhotast thhira thhthrif ** wealth needs to be a double to preserve precision gen double wealth = thhtheq+thhvehcl+thhbeq+thhintbk+thhintot+rhhstk +thhore+thhotast+thhira+thhthrif assert thhtwlth == wealth ********************************************************************** ** Home Equity describe thhtheq tpropval tmhval thhmortg gen home = (tpropval+tmhval)-thhmortg assert thhtheq == home ********************************************************************** ** Vehicle Equity describe thhvehcl tcarval1 ta1amt tcarval2 ta2amt tcarval3 ta3amt tov1val tov1amt tov2val tov2amt gen vehicle = (tcarval1-ta1amt)+(tcarval2-ta2amt)+(tcarval3-ta3amt)+(tov1val-tov1amt)+(tov2val-tov2amt) assert thhvehcl == vehicle ********************************************************************** ** Business Equity describe thhbeq evbow1 tvbva1 tvbde1 evbow1 tvbva1 tvbde1 ** The value of all the person's businesses in the household is applied to the household ** So, calculating person's business equity first, then applying the sum of all person's to the household gen p_business = (evbow1/100*(tvbva1-tvbde1))+(evbow2/100*(tvbva2-tvbde2)) bysort ssuid shhadid: egen business=sum(p_business) ** Truncating to the integer value works a bit better than rounding replace business=int(business) ** Checking that calculated household business equity is within $1 of Census' assert abs(thhbeq-business)>-1 & abs(thhbeq-business)<=1 ********************************************************************** ** Bank Interest ** Again, the sum of each person's wealth is applied to the household describe thhintbk tiajta tiaita gen p_bank_int = tiajta+tiaita bysort ssuid shhadid: egen bank_int=sum(p_bank_int) assert thhintbk == bank_int ********************************************************************** ** Other Interest ** The sum of each person's wealth is applied to the household describe thhintot timja timia gen p_oth_int = timja+timia bysort ssuid shhadid: egen oth_int=sum(p_oth_int) assert thhintot == oth_int ********************************************************************** ** Stocks ** The sum of each person's wealth is applied to the household describe rhhstk esmjv esmjmav esmiv emsimav gen p_stock = (esmjv-esmjmav)+(esmiv-esmimav) bysort ssuid shhadid: egen stock=sum(p_stock) assert rhhstk == stock ********************************************************************** ** Other real estate - Not home ** The sum of each person's wealth is applied to the household ** tothreva: All persons in HH get the reference person's response duplicated to their record ** trtsha: real estate jointly owned with other than spouse ** trjmv: joint, non-residence ASKED OF ONLY ONE SPOUSE. RESPONSE IS DIVIDED BY 2, AND THE DIVIDED AMOUNT IS COPIED TO BOTH SPOUSES RECORDS. ** trimv: owned in own name describe thhore tothreva trtsha trjmv trjpri trimv tripri ** trtsha, trimv, and trjmv apply to the whole hh, so hh-wise variables that are cum sums are needed bysort ssuid shhadid: egen h_trt=sum(trtsha) bysort ssuid shhadid: egen h_trj=sum(trjmv-trjpri) bysort ssuid shhadid: egen h_tri=sum(trimv-tripri) gen oreal = tothreva+h_trt+h_trj+h_tri sort ssuid shhadid epppnum *list ssuid shhadid epppnum thhore *real* tothreva trtsha trjmv trjpri trimv tripri if ssuid=="066925123035" , nol assert thhore == oreal ********************************************************************** ** Other assets ** The sum of each person's wealth is applied to the household describe thhotast tmjp tmip eoaeq ealowa talsbv taljcha talicha gen p_oth_ass = tmjp+tmip+eoaeq+ealowa+talsbv+taljcha+talicha bysort ssuid shhadid: egen oth_ass=sum(p_oth_ass) assert thhotast == oth_ass list ssuid shhadid epppnum thhotast *ass tmjp tmip eoaeq ealowa talsbv taljcha talicha if thhotast!=oth_ass , nol list ssuid shhadid epppnum thhotast *ass tmjp tmip eoaeq ealowa talsbv taljcha talicha if ssuid=="077344437402" , nol list ssuid shhadid epppnum thhotast *ass tmjp tmip eoaeq ealowa talsbv taljcha talicha if ssuid=="104344074647" , nol ********************************************************************** ** IRA and KEOGH ** The sum of each person's wealth is applied to the household describe thhira talrb talkb gen p_ira = talrb+talkb bysort ssuid shhadid: egen ira=sum(p_ira) assert thhira == ira ********************************************************************** ** 401K and Thrift ** The sum of each person's wealth is applied to the household describe thhthrif taltb bysort ssuid shhadid: egen thrift=sum(taltb) assert thhthrif == thrift ********************************************************************** 1993 t4 & t7 asset modules: tm8666 real estate ? (tm8788-tm8796)+(tm8790-tm8798) vehicle business ownership does not seem to be asked 1993 t7 ONLY: hh_twlth = hh_theq + hh_vehcl + hh_beq + hh_intbk + hh_intot + hh_stk + hh_ore + hh_otast + hh_ira Note: the 401K/Thrift savings account question does not seem to be asked