**Deriving mother's annual pay (sweep one) variables: motherpay, mothpayc and mpay **note this syntax uses 'mother' variables - details of how these were derived are in syntax 2 *"Deriving the sample for analysis 1 (same father-mother households s1-5)" gen motherpay = amneta00 if mother1==1 replace motherpay = 85 if apneta00 == 85 & mother2==1 replace motherpay = 165 if apneta00 == 165 & mother2==1 replace motherpay = 189 if apneta00 == 189 & mother2==1 replace motherpay = 420 if apneta00 == 420 & mother2==1 replace motherpay = 1100 if apneta00 == 1100 & mother2==1 replace motherpay = 0 if AMDWRK==2 & mother1==1 replace motherpay = 0 if APDWRK==2 & mother2==1 label var motherpay "Mother's take home pay, s1 (but refers to diff periods)" replace motherpay = 1 if motherpay==-1 & amemse==2 & amsepa==1 replace motherpay = 5 if motherpay==-1 & amemse==2 & amsepa==5 replace motherpay = 13 if motherpay==-1 & amemse==2 & amsepa==13 replace motherpay = 18 if motherpay==-1 & amemse==2 & amsepa==18 replace motherpay = 25 if motherpay==-1 & amemse==2 & amsepa==25 replace motherpay = 30 if motherpay==-1 & amemse==2 & amsepa==30 replace motherpay = 35 if motherpay==-1 & amemse==2 & amsepa==35 replace motherpay = 50 if motherpay==-1 & amemse==2 & amsepa==50 replace motherpay = 60 if motherpay==-1 & amemse==2 & amsepa==60 replace motherpay = 65 if motherpay==-1 & amemse==2 & amsepa==65 replace motherpay = 70 if motherpay==-1 & amemse==2 & amsepa==70 replace motherpay = 80 if motherpay==-1 & amemse==2 & amsepa==80 replace motherpay = 100 if motherpay==-1 & amemse==2 & amsepa==100 replace motherpay = 111 if motherpay==-1 & amemse==2 & amsepa==111 replace motherpay = 120 if motherpay==-1 & amemse==2 & amsepa==120 replace motherpay = 130 if motherpay==-1 & amemse==2 & amsepa==130 replace motherpay = 140 if motherpay==-1 & amemse==2 & amsepa==140 replace motherpay = 150 if motherpay==-1 & amemse==2 & amsepa==150 replace motherpay = 160 if motherpay==-1 & amemse==2 & amsepa==160 replace motherpay = 162 if motherpay==-1 & amemse==2 & amsepa==162 replace motherpay = 200 if motherpay==-1 & amemse==2 & amsepa==200 replace motherpay = 250 if motherpay==-1 & amemse==2 & amsepa==250 replace motherpay = 300 if motherpay==-1 & amemse==2 & amsepa==300 replace motherpay = 350 if motherpay==-1 & amemse==2 & amsepa==350 replace motherpay = 500 if motherpay==-1 & amemse==2 & amsepa==500 replace motherpay = 600 if motherpay==-1 & amemse==2 & amsepa==600 replace motherpay = 800 if motherpay==-1 & amemse==2 & amsepa==800 replace motherpay = 850 if motherpay==-1 & amemse==2 & amsepa==850 replace motherpay = 865 if motherpay==-1 & amemse==2 & amsepa==865 replace motherpay = 877 if motherpay==-1 & amemse==2 & amsepa==877 replace motherpay = 900 if motherpay==-1 & amemse==2 & amsepa==900 replace motherpay = 950 if motherpay==-1 & amemse==2 & amsepa==950 replace motherpay = 1000 if motherpay==-1 & amemse==2 & amsepa==1000 replace motherpay = 1200 if motherpay==-1 & amemse==2 & amsepa==1200 replace motherpay = 1330 if motherpay==-1 & amemse==2 & amsepa==1330 replace motherpay = 1400 if motherpay==-1 & amemse==2 & amsepa==1400 replace motherpay = 1500 if motherpay==-1 & amemse==2 & amsepa==1500 replace motherpay = 1600 if motherpay==-1 & amemse==2 & amsepa==1600 replace motherpay = 1750 if motherpay==-1 & amemse==2 & amsepa==1750 replace motherpay = 1800 if motherpay==-1 & amemse==2 & amsepa==1800 replace motherpay = 2000 if motherpay==-1 & amemse==2 & amsepa==2000 replace motherpay = 2400 if motherpay==-1 & amemse==2 & amsepa==2400 replace motherpay = 2500 if motherpay==-1 & amemse==2 & amsepa==2500 replace motherpay = 2750 if motherpay==-1 & amemse==2 & amsepa==2750 replace motherpay = 3000 if motherpay==-1 & amemse==2 & amsepa==3000 replace motherpay = 3200 if motherpay==-1 & amemse==2 & amsepa==3200 replace motherpay = 3500 if motherpay==-1 & amemse==2 & amsepa==3500 replace motherpay = 3600 if motherpay==-1 & amemse==2 & amsepa==3600 replace motherpay = 3750 if motherpay==-1 & amemse==2 & amsepa==3750 replace motherpay = 3900 if motherpay==-1 & amemse==2 & amsepa==3900 replace motherpay = 4000 if motherpay==-1 & amemse==2 & amsepa==4000 replace motherpay = 4200 if motherpay==-1 & amemse==2 & amsepa==4200 replace motherpay = 4500 if motherpay==-1 & amemse==2 & amsepa==4500 replace motherpay = 4800 if motherpay==-1 & amemse==2 & amsepa==4800 replace motherpay = 5000 if motherpay==-1 & amemse==2 & amsepa==5000 replace motherpay = 5200 if motherpay==-1 & amemse==2 & amsepa==5200 replace motherpay = 5400 if motherpay==-1 & amemse==2 & amsepa==5400 replace motherpay = 5500 if motherpay==-1 & amemse==2 & amsepa==5500 replace motherpay = 6000 if motherpay==-1 & amemse==2 & amsepa==6500 replace motherpay = 6100 if motherpay==-1 & amemse==2 & amsepa==6100 replace motherpay = 6500 if motherpay==-1 & amemse==2 & amsepa==6000 replace motherpay = 6600 if motherpay==-1 & amemse==2 & amsepa==6600 replace motherpay = 7000 if motherpay==-1 & amemse==2 & amsepa==7000 replace motherpay = 7200 if motherpay==-1 & amemse==2 & amsepa==7200 replace motherpay = 7500 if motherpay==-1 & amemse==2 & amsepa==7500 replace motherpay = 8000 if motherpay==-1 & amemse==2 & amsepa==8000 replace motherpay = 8500 if motherpay==-1 & amemse==2 & amsepa==8500 replace motherpay = 9000 if motherpay==-1 & amemse==2 & amsepa==9000 replace motherpay = 9100 if motherpay==-1 & amemse==2 & amsepa==9100 replace motherpay = 9500 if motherpay==-1 & amemse==2 & amsepa==9500 replace motherpay = 10000 if motherpay==-1 & amemse==2 & amsepa==10000 replace motherpay = 10500 if motherpay==-1 & amemse==2 & amsepa==10500 replace motherpay = 11000 if motherpay==-1 & amemse==2 & amsepa==11000 replace motherpay = 11500 if motherpay==-1 & amemse==2 & amsepa==11500 replace motherpay = 12000 if motherpay==-1 & amemse==2 & amsepa==12000 replace motherpay = 12500 if motherpay==-1 & amemse==2 & amsepa==12500 replace motherpay = 13000 if motherpay==-1 & amemse==2 & amsepa==13000 replace motherpay = 13500 if motherpay==-1 & amemse==2 & amsepa==13500 replace motherpay = 14000 if motherpay==-1 & amemse==2 & amsepa==14000 replace motherpay = 14500 if motherpay==-1 & amemse==2 & amsepa==14500 replace motherpay = 15000 if motherpay==-1 & amemse==2 & amsepa==15000 replace motherpay = 15600 if motherpay==-1 & amemse==2 & amsepa==15600 replace motherpay = 16000 if motherpay==-1 & amemse==2 & amsepa==16000 replace motherpay = 17000 if motherpay==-1 & amemse==2 & amsepa==17000 replace motherpay = 18000 if motherpay==-1 & amemse==2 & amsepa==18000 replace motherpay = 18827 if motherpay==-1 & amemse==2 & amsepa==18827 replace motherpay = 20000 if motherpay==-1 & amemse==2 & amsepa==20000 replace motherpay = 22000 if motherpay==-1 & amemse==2 & amsepa==22000 replace motherpay = 23000 if motherpay==-1 & amemse==2 & amsepa==23000 replace motherpay = 24000 if motherpay==-1 & amemse==2 & amsepa==24000 replace motherpay = 24240 if motherpay==-1 & amemse==2 & amsepa==24240 replace motherpay = 25000 if motherpay==-1 & amemse==2 & amsepa==25000 replace motherpay = 26000 if motherpay==-1 & amemse==2 & amsepa==26000 replace motherpay = 27000 if motherpay==-1 & amemse==2 & amsepa==27000 replace motherpay = 28000 if motherpay==-1 & amemse==2 & amsepa==28000 replace motherpay = 30000 if motherpay==-1 & amemse==2 & amsepa==30000 replace motherpay = 31000 if motherpay==-1 & amemse==2 & amsepa==31000 replace motherpay = 35000 if motherpay==-1 & amemse==2 & amsepa==35000 replace motherpay = 36000 if motherpay==-1 & amemse==2 & amsepa==36000 replace motherpay = 40000 if motherpay==-1 & amemse==2 & amsepa==40000 replace motherpay = 45000 if motherpay==-1 & amemse==2 & amsepa==45000 replace motherpay = 50000 if motherpay==-1 & amemse==2 & amsepa==50000 replace motherpay = 56000 if motherpay==-1 & amemse==2 & amsepa==56000 replace motherpay = 57000 if motherpay==-1 & amemse==2 & amsepa==57000 replace motherpay = 60000 if motherpay==-1 & amemse==2 & amsepa==60000 replace motherpay = 75000 if motherpay==-1 & amemse==2 & amsepa==75000 replace motherpay = 80000 if motherpay==-1 & amemse==2 & amsepa==80000 replace motherpay = 110000 if motherpay==-1 & amemse==2 & amsepa==110000 replace motherpay = 180000 if motherpay==-1 & amemse==2 & amsepa==180000 ****remaining mothers in paid work into average hourly earnings for full-time and part-time *in 2000-01, average (gross) pay for FT women = 18,811; PT women = 6972 **Mother's annual pro-rata pay **assumes mothers work 52 weeks a year. gen mothpayc = 0 replace mothpayc = 1 if motherpay ==0 replace mothpayc = 1 if AMDWRK ==2 & mother1==1 replace mothpayc = 1 if APDWRK ==2 & mother2==1 *annual replace mothpayc = 2 if motherpay >=1 & motherpay <=3000 & amnetp == 5 & mother1==1 replace mothpayc = 3 if motherpay >3000 & motherpay <=5000 & amnetp == 5 & mother1==1 replace mothpayc = 4 if motherpay >5000 & motherpay <=10000 & amnetp == 5 & mother1==1 replace mothpayc = 5 if motherpay >10000 & motherpay <=20000 & amnetp == 5 & mother1==1 replace mothpayc = 6 if motherpay >20000 & motherpay <=30000 & amnetp == 5 & mother1==1 replace mothpayc = 7 if motherpay >30000 & motherpay <=40000 & amnetp == 5 & mother1==1 replace mothpayc = 8 if motherpay >40000 & amnetp == 5 & mother1==1 replace mothpayc = 2 if motherpay >=1 & motherpay <=3000 & apnetp == 5 & mother2==1 replace mothpayc = 3 if motherpay >3000 & motherpay <=5000 & apnetp == 5 & mother2==1 replace mothpayc = 4 if motherpay >5000 & motherpay <=10000 & apnetp == 5 & mother2==1 replace mothpayc = 5 if motherpay >10000 & motherpay <=20000 & apnetp == 5 & mother2==1 replace mothpayc = 6 if motherpay >20000 & motherpay <=30000 & apnetp == 5 & mother2==1 replace mothpayc = 7 if motherpay >30000 & motherpay <=40000 & apnetp == 5 & mother2==1 replace mothpayc = 8 if motherpay >40000 & amnetp == 5 & mother2==1 label define mothpayc 1 "Not earning/in work" 2 "£1-3000 p/year" 3 ">£3,000-£5,000" /// 4 ">£5K-£10K" 5 ">£10K-£20K" 6 ">£20K-£30K" 7 ">£30K-£40K" /// 8 ">£40K", modify label values mothpayc mothpayc label var mothpayc "Mothers current, average, pro-rata annual take home pay, s1 (coded)" ***move those who answer per calendar month **e.g. for category 2 = 3000 / 12 = 250 *5000 / 12 = 417 *etc replace mothpayc = 2 if mothpayc==0 & amnetp==4 & motherpay >=1 & motherpay <=250 & mother1==1 replace mothpayc = 3 if mothpayc==0 & amnetp==4 & motherpay >250 & motherpay <=417 & mother1==1 replace mothpayc = 4 if mothpayc==0 & amnetp==4 & motherpay >417 & motherpay <=834 & mother1==1 replace mothpayc = 5 if mothpayc==0 & amnetp==4 & motherpay >834 & motherpay <=1667 & mother1==1 replace mothpayc = 6 if mothpayc==0 & amnetp==4 & motherpay >1667 & motherpay <=2500 & mother1==1 replace mothpayc = 7 if mothpayc==0 & amnetp==4 & motherpay >2500 & motherpay <=3333 & mother1==1 replace mothpayc = 8 if mothpayc==0 & amnetp==4 & motherpay >3333 & mother1==1 replace mothpayc = 2 if mothpayc==0 & apnetp==4 & motherpay >=1 & motherpay <=250 & mother2==1 replace mothpayc = 3 if mothpayc==0 & apnetp==4 & motherpay >250 & motherpay <=417 & mother2==1 replace mothpayc = 4 if mothpayc==0 & apnetp==4 & motherpay >417 & motherpay <=834 & mother2==1 replace mothpayc = 5 if mothpayc==0 & apnetp==4 & motherpay >834 & motherpay <=1667 & mother2==1 replace mothpayc = 6 if mothpayc==0 & apnetp==4 & motherpay >1667 & motherpay <=2500 & mother2==1 replace mothpayc = 7 if mothpayc==0 & apnetp==4 & motherpay >2500 & motherpay <=3333 & mother2==1 replace mothpayc = 8 if mothpayc==0 & apnetp==4 & motherpay >3333 & mother2==1 replace mothpayc = 2 if mothpayc==0 & amnetp==3 & motherpay >=1 & motherpay <=231 & mother1==1 replace mothpayc = 3 if mothpayc==0 & amnetp==3 & motherpay >231 & motherpay <=385 & mother1==1 replace mothpayc = 4 if mothpayc==0 & amnetp==3 & motherpay >385 & motherpay <=769 & mother1==1 replace mothpayc = 5 if mothpayc==0 & amnetp==3 & motherpay >769 & motherpay <=1538.5 & mother1==1 replace mothpayc = 6 if mothpayc==0 & amnetp==3 & motherpay >1538.5 & motherpay <=2308 & mother1==1 replace mothpayc = 7 if mothpayc==0 & amnetp==3 & motherpay >2308 & motherpay <=3077 & mother1==1 replace mothpayc = 8 if mothpayc==0 & amnetp==3 & motherpay >3077 & mother1==1 replace mothpayc = 2 if mothpayc==0 & apnetp==3 & motherpay >=1 & motherpay <=231 & mother2==1 replace mothpayc = 3 if mothpayc==0 & apnetp==3 & motherpay >231 & motherpay <=385 & mother2==1 replace mothpayc = 4 if mothpayc==0 & apnetp==3 & motherpay >385 & motherpay <=769 & mother2==1 replace mothpayc = 5 if mothpayc==0 & apnetp==3 & motherpay >769 & motherpay <=1538.5 & mother2==1 replace mothpayc = 6 if mothpayc==0 & apnetp==3 & motherpay >1538.5 & motherpay <=2308 & mother2==1 replace mothpayc = 7 if mothpayc==0 & apnetp==3 & motherpay >2308 & motherpay <=3077 & mother2==1 replace mothpayc = 8 if mothpayc==0 & apnetp==3 & motherpay >3077 & mother2==1 **move those that answered every 2 weeks (26 sets of 2 weeks in the year) **so if a mother gets £10 every 2 weeks ,she gets 10 x 26 = £260 per year *3000 / 26 = 115.5 (because 115.5 X 26 = 3003) replace mothpayc = 2 if mothpayc==0 & amnetp==2 & motherpay >=1 & motherpay <=115.5 & mother1==1 replace mothpayc = 3 if mothpayc==0 & amnetp==2 & motherpay >115.5 & motherpay <=192.5 & mother1==1 replace mothpayc = 4 if mothpayc==0 & amnetp==2 & motherpay >192.5 & motherpay <=385 & mother1==1 replace mothpayc = 5 if mothpayc==0 & amnetp==2 & motherpay >385 & motherpay <=769.5 & mother1==1 replace mothpayc = 6 if mothpayc==0 & amnetp==2 & motherpay >769.5 & motherpay <=1154 & mother1==1 replace mothpayc = 7 if mothpayc==0 & amnetp==2 & motherpay >1154 & motherpay <=1538.5 & mother1==1 replace mothpayc = 8 if mothpayc==0 & amnetp==2 & motherpay >1538.5 & mother1==1 replace mothpayc = 2 if mothpayc==0 & apnetp==2 & motherpay >=1 & motherpay <=115.5 & mother2==1 replace mothpayc = 3 if mothpayc==0 & apnetp==2 & motherpay >115.5 & motherpay <=192.5 & mother2==1 replace mothpayc = 4 if mothpayc==0 & apnetp==2 & motherpay >192.5 & motherpay <=385 & mother2==1 replace mothpayc = 5 if mothpayc==0 & apnetp==2 & motherpay >385 & motherpay <=769.5 & mother2==1 replace mothpayc = 6 if mothpayc==0 & apnetp==2 & motherpay >769.5 & motherpay <=1154 & mother2==1 replace mothpayc = 7 if mothpayc==0 & apnetp==2 & motherpay >1154 & motherpay <=1538.5 & mother2==1 replace mothpayc = 8 if mothpayc==0 & apnetp==2 & motherpay >1538.5 & mother2==1 **move mothers who get paid 1 week over 52 weeks in a year **so if a mother gets £10 every week ,she gets 10 x 52 = £520 per year *3000 / 52 = 57.5 (because 57.5 X 52 = 3003) replace mothpayc = 2 if mothpayc==0 & amnetp==1 & motherpay >=1 & motherpay <=57.5 & mother1==1 replace mothpayc = 3 if mothpayc==0 & amnetp==1 & motherpay >57.5 & motherpay <=96 & mother1==1 replace mothpayc = 4 if mothpayc==0 & amnetp==1 & motherpay >96 & motherpay <=192.5 & mother1==1 replace mothpayc = 5 if mothpayc==0 & amnetp==1 & motherpay >192.5 & motherpay <=384.5 & mother1==1 replace mothpayc = 6 if mothpayc==0 & amnetp==1 & motherpay >384.5 & motherpay <=577 & mother1==1 replace mothpayc = 7 if mothpayc==0 & amnetp==1 & motherpay >577 & motherpay <=769 & mother1==1 replace mothpayc = 8 if mothpayc==0 & amnetp==1 & motherpay >769 & mother1==1 replace mothpayc = 2 if mothpayc==0 & apnetp==1 & motherpay >=1 & motherpay <=57.5 & mother2==1 replace mothpayc = 3 if mothpayc==0 & apnetp==1 & motherpay >57.5 & motherpay <=96 & mother2==1 replace mothpayc = 4 if mothpayc==0 & apnetp==1 & motherpay >96 & motherpay <=192.5 & mother2==1 replace mothpayc = 5 if mothpayc==0 & apnetp==1 & motherpay >192.5 & motherpay <=384.5 & mother2==1 replace mothpayc = 6 if mothpayc==0 & apnetp==1 & motherpay >384.5 & motherpay <=577 & mother2==1 replace mothpayc = 7 if mothpayc==0 & apnetp==1 & motherpay >577 & motherpay <=769 & mother2==1 replace mothpayc = 8 if mothpayc==0 & apnetp==1 & motherpay >769 & mother2==1 **move those that answer every 3 weeks (17.3 sets of 2 weeks in the year) **so if a mother gets £10 every 3 weeks ,she gets 10 x 17.3 = £173 per year) *3000 / 17 = 176.5 (because 176 X 17 = 3000) replace mothpayc = 2 if mothpayc==0 & amnetp==51 & motherpay >=1 & motherpay <=176.5 & mother1==1 replace mothpayc = 3 if mothpayc==0 & amnetp==51 & motherpay >176.5 & motherpay <=294 & mother1==1 replace mothpayc = 4 if mothpayc==0 & amnetp==51 & motherpay >294 & motherpay <=588 & mother1==1 replace mothpayc = 5 if mothpayc==0 & amnetp==51 & motherpay >588 & motherpay <=1176.5 & mother1==1 replace mothpayc = 6 if mothpayc==0 & amnetp==51 & motherpay >1176.5 & motherpay <=1765 & mother1==1 replace mothpayc = 7 if mothpayc==0 & amnetp==51 & motherpay >1765 & motherpay <=2353 & mother1==1 replace mothpayc = 8 if mothpayc==0 & amnetp==51 & motherpay >2353 & mother1==1 replace mothpayc = 2 if mothpayc==0 & apnetp==51 & motherpay >=1 & motherpay <=176.5 & mother2==1 replace mothpayc = 3 if mothpayc==0 & apnetp==51 & motherpay >176.5 & motherpay <=294 & mother2==1 replace mothpayc = 4 if mothpayc==0 & apnetp==51 & motherpay >294 & motherpay <=588 & mother2==1 replace mothpayc = 5 if mothpayc==0 & apnetp==51 & motherpay >588 & motherpay <=1176.5 & mother2==1 replace mothpayc = 6 if mothpayc==0 & apnetp==51 & motherpay >1176.5 & motherpay <=1765 & mother2==1 replace mothpayc = 7 if mothpayc==0 & apnetp==51 & motherpay >1765 & motherpay <=2353 & mother2==1 replace mothpayc = 8 if mothpayc==0 & apnetp==51 & motherpay >2353 & mother2==1 replace mothpayc = 2 if mothpayc==0 & amnetp==52 & motherpay >=1 & motherpay <=288.5 & mother1==1 replace mothpayc = 3 if mothpayc==0 & amnetp==52 & motherpay >288.5 & motherpay <=481 & mother1==1 replace mothpayc = 4 if mothpayc==0 & amnetp==52 & motherpay >481 & motherpay <=961.5 & mother1==1 replace mothpayc = 5 if mothpayc==0 & amnetp==52 & motherpay >961.5 & motherpay <=1923 & mother1==1 replace mothpayc = 2 if mothpayc==0 & apnetp==52 & motherpay >=1 & motherpay <=288.5 & mother2==1 replace mothpayc = 3 if mothpayc==0 & apnetp==52 & motherpay >288.5 & motherpay <=481 & mother2==1 replace mothpayc = 4 if mothpayc==0 & apnetp==52 & motherpay >481 & motherpay <=961.5 & mother2==1 replace mothpayc = 5 if mothpayc==0 & apnetp==52 & motherpay >961.5 & motherpay <=1923 & mother2==1 replace mothpayc = 2 if mothpayc==0 & amnetp==53 & motherpay >=1 & motherpay <=345 & mother1==1 replace mothpayc = 3 if mothpayc==0 & amnetp==53 & motherpay >345 & motherpay <=575 & mother1==1 replace mothpayc = 4 if mothpayc==0 & amnetp==53 & motherpay >575 & motherpay <=1149 & mother1==1 replace mothpayc = 2 if mothpayc==0 & amnetp==54 & motherpay ==350 & mother1==1 replace mothpayc = 2 if mothpayc==0 & amnetp==56 & motherpay ==100 & mother1==1 replace mothpayc = 3 if mothpayc==0 & amnetp==56 & motherpay ==648 & mother1==1 replace mothpayc = 4 if mothpayc==0 & amnetp==56 & motherpay ==927 & mother1==1 replace mothpayc = 4 if mothpayc==0 & amnetp==56 & motherpay ==1197 & mother1==1 replace mothpayc = 2 if mothpayc==0 & amnetp==60 & motherpay ==300 & mother1==1 replace mothpayc = 2 if mothpayc==0 & amnetp==60 & motherpay ==500 & mother1==1 replace mothpayc = 4 if mothpayc==0 & amnetp==61 & motherpay ==3000 & mother1==1 replace mothpayc = 2 if mothpayc==0 & amnetp==63 & motherpay ==8 & mother1==1 replace mothpayc = 2 if mothpayc==0 & amnetp==63 & motherpay ==18 & mother1==1 replace mothpayc = 2 if mothpayc==0 & amnetp==63 & motherpay ==20 & mother1==1 replace mothpayc = 2 if mothpayc==0 & amnetp==63 & motherpay ==22 & mother1==1 replace mothpayc = 2 if mothpayc==0 & amnetp==63 & motherpay ==25 & mother1==1 replace mothpayc = 4 if mothpayc==0 & amnetp==63 & motherpay ==27 & mother1==1 replace mothpayc = 2 if mothpayc==0 & amnetp==63 & motherpay ==40 & mother1==1 replace mothpayc = 3 if mothpayc==0 & amnetp==63 & motherpay ==60 & mother1==1 replace mothpayc = 4 if mothpayc==0 & amnetp==63 & motherpay ==100 & mother1==1 replace mothpayc = 5 if mothpayc==0 & amnetp==63 & motherpay ==103 & mother1==1 replace mothpayc = 8 if mothpayc==0 & amnetp==63 & motherpay ==2230 & mother1==1 ***hourly paid. Hourly take home pay is: tab amwkhr if motherpay==215 & amnetp==62 *4 p/hour @ 16 hours p/week = £64 p/week. 64 X 52 = 3328 p/year *4 p/hour @ 21 hours p/week = £84 p/week. 84 X 52 = 4368 *5 p/hour @18 hours p/week = £90 p/week. 90 X 52 = 4680 *7 @6 hours p/week = 42 p/week. 42 X 52 = 2184 *9 @8 hours = 72 X 52 = 3744 *10 @1 hour = 10 X 52 = 520 *15 @6 hour = 90 X 52 = 4680 *16 @ 35 hours = 560 X 52 = 29,120 *215 @ 20 hours = 4300 X 52 = 223,600 replace mothpayc = 3 if mothpayc==0 & amnetp==62 & motherpay ==4 & mother1==1 replace mothpayc = 3 if mothpayc==0 & amnetp==62 & motherpay ==5 & mother1==1 replace mothpayc = 2 if mothpayc==0 & amnetp==62 & motherpay ==7 & mother1==1 replace mothpayc = 3 if mothpayc==0 & amnetp==62 & motherpay ==9 & mother1==1 replace mothpayc = 2 if mothpayc==0 & amnetp==62 & motherpay ==10 & mother1==1 replace mothpayc = 3 if mothpayc==0 & amnetp==62 & motherpay ==15 & mother1==1 replace mothpayc = 6 if mothpayc==0 & amnetp==62 & motherpay ==16 & mother1==1 replace mothpayc = 8 if mothpayc==0 & amnetp==62 & motherpay ==215 & mother1==1 replace mothpayc = 2 if motherpay == 16 & amnetp==64 **if self-emp, self-employed pay over a year tab amsepa if amemse == 2 & mothpayc ==0 & mother1==1 replace mothpayc = 2 if mothpayc == 0 & amsepa >0 & amsepa <=3000 & amemse==2 & mother1==1 replace mothpayc = 3 if mothpayc == 0 & amsepa >3000 & amsepa <=5000 & amemse==2 & mother1==1 replace mothpayc = 4 if mothpayc == 0 & amsepa >5000 & amsepa <=10000 & amemse==2 & mother1==1 replace mothpayc = 5 if mothpayc == 0 & amsepa >10000 & amsepa <=20000 & amemse==2 & mother1==1 replace mothpayc = 6 if mothpayc == 0 & amsepa >20000 & amsepa <=30000 & amemse==2 & mother1==1 replace mothpayc = 7 if mothpayc == 0 & amsepa >30000 & amsepa <=40000 & amemse==2 & mother1==1 replace mothpayc = 8 if mothpayc == 0 & amsepa >40000 & amemse==2 & mother1==1 tab AMDWRK if amsepa ==-8 & amemse == 2 & mothpayc ==0 & mother1==1 **filter into average pay for part-time and full-time women *in 2000-01, average (gross) pay for FT women = 18,811; 6972 for part time replace mothpayc = 4 if amsepa ==-8 & amemse == 2 & mothpayc ==0 & mother1==1 & mothhours1==2 replace mothpayc = 5 if amsepa ==-8 & amemse == 2 & mothpayc ==0 & mother1==1 & mothhours1==3 replace mothpayc = 5 if mothpayc == 0 & amneta==20000 replace mothpayc = 2 if mothpayc == 0 & amneta==1 replace mothpayc = 4 if mothpayc==0 & amneta==-8 & mother1==1 & mothhours1==2 replace mothpayc = 5 if mothpayc==0 & amneta==-8 & mother1==1 & mothhours1==3 replace mothpayc = 4 if mothpayc==0 & amneta==-9 & mother1==1 & mothhours1==2 replace mothpayc = 5 if mothpayc==0 & amneta==-9 & mother1==1 & mothhours1==3 replace mothpayc = 4 if mothpayc==0 & mother1==1 & mothhours1==2 replace mothpayc = 5 if mothpayc==0 & mother1==1 & mothhours1==3 replace mothpayc = 4 if mothpayc==0 & mother2==1 & mothhours1==2 **tests to see if coded correctly tab amnetp mothpayc tab motherpay if mothpayc == 2 & amnetp==5 tab motherpay if mothpayc == 4 & amnetp==4 tab motherpay if mothpayc == 5 & amnetp==3 tab motherpay if mothpayc == 6 & amnetp==2 tab motherpay if mothpayc == 6 & amnetp==1 ***collapse variable (mpay) gen mpay = mothpayc recode mpay 1=1 2=2 3=2 4=3 5=4 6=5 7=5 8=5 label define mpay 1 "Not earning" 2 "£5K a year or less" 3 "£5-10K" 4 "£10-20K" 5 "£20K or more", modify label values mpay mpay label var mpay "Mothers (pro-rata) annual net earnings" recode mpay 0=. gen mpayc=mpay recode mpayc 1=1 2=2 3=3 4=4 5=4