Support Providers p79-99 Issued Feb 2005 by Timothy S. Grall John J. Hisnanick, Longitudnal Income Statistics Branch, John.J.Hisnanick@census.gov, (301) 763-6685 <- dept line (301) 763-2295 <- person line sipp01tm5 ESUPKDYN=1 ( kid ) or ESUPOTPY=1 ( others, not kids ) are support providers. WPFINWGT is the weight variable in sipp01tm5 . Data was collected June-October 2002 ( June, July, August, September, October ) Rotation info is below. Amount paid variables. All have allocation flags with "A" as 1st letter rather than "T". Topcode listed. child support: TSUPAMPD Universe is court ordered ( ESUPAGRM = 1 ). Topcode = 13500. TSUPAMAL Universe is multi ( another ) child support agreement ( (E)SUPOTHA=1 ). Topcode = 5375. TSUPAMAD Universe is made payments w/o agreement ( ESUPWOAG=1 ) Topcode = 12000. other person: TSUPOTAM Universe is provided support to any other person ( ESUPOTPY=1 ) Topcode = 24000. TSUPOTPA Universe is more than one other person supported ( TSUPOTNP>1 ) refers to person 1 Topcode = 14000. TSUPOTNT Universe is more than one other person supported ( TSUPOTNP>2 ) refers to person 2-4 Topcode = 40000. The 7.8 million is the sum of TSUPAMPD,TSUPAMAL,TSUPAMAD,TSUPOTAM,TSUPOTPA,TSUPOTNT weighted by wpfinwgt. Actual weighted sum is 7756726: 7,756,726. ( 7816 is the 1000s table amount ). Generated by sum sum [aw=wpfinwgt] if dum where dum=1 if sum>0 . 4794.161 is mean total support. egen med = median(sum) if sum produces median total support of 3300. Matches table exactly. egen sumegen = sum(sum) ** applies the sum of sum to all _n gen sumegenw = sumegen * wpfinwgt ** multiply sum times weight; last value is total financial support format %15.0fc sumegenw list sumegenw in l sum kidsum [aw=wpfinwgt] if kiddum = 5404823.4 / 4280 ( 5,729 / 4243 thousands is table amount ) egen kidegen = sum(kidsum) ** repeat to get child support sum: 26,635,657,216 , $24 billion in table gen kidegenw = kidegen * wpfinwgt format %15.0fc kidegenw list kidegenw in l sum othersum [aw=wpfinwgt] if othersum > 0 = 2645033 ( 2,087 thousands in table ) Hmm, sum of 5404823.4 + 2645033 = 8049856, not 7756726. sum kidsum [aw=wpfinwgt] if kiddum & !othersum gives: Variable | Obs Weight Mean Std. Dev. Min Max kidsum | 1222 5111693.04 4221.215 3376.126 1 13500 egen medkid = median(kidsum) if kidsum & !othersum yields 3600 . 3380 is table value. egen medother = median(othersum) if othersum yields 2400 . 2200 is table value. Poverty status and labor force status are in core wave file. rotation reference months ( srefmon is in order 1, 2, 3, 4 ) -------- ---------------- 1 Feb, Mar, Apr, May 2 Mar, Apr, May, June 3 Apr, May, Jun, July 4 May, Jun, July, Aug wave srotaton srefmon rhcalmn rhcalyr n 5 1 1 February 2002 17300 5 1 2 March 2002 17309 5 1 3 April 2002 17332 5 1 4 May 2002 17357 5 2 1 March 2002 17556 5 2 2 April 2002 17506 5 2 3 May 2002 17512 5 2 4 June 2002 17535 5 3 1 April 2002 17040 5 3 2 May 2002 17011 5 3 3 June 2002 17030 5 3 4 July 2002 17040 5 4 1 May 2002 17398 5 4 2 June 2002 17414 5 4 3 July 2002 17426 5 4 4 August 2002 17481