*Syntax to create the MTUS World 5.53 files for Germany 1998-1999. Written by Mr. José Ignacio Gimenez Nadal, University of Zaragoza, Spain *Cleaning the workspace and extending the size of the memory clear clear matrix set more off set mem 500m *Creating a working directory where all the files will be stored. The output data is in the working directory and all the original files must be in this directory before starting with the harmonization process. cd "/Users/LK/Documents/Time Use/GER2001/" **First we have to merge the three datasets: *zbe01-02_haus95_201003: Household information (5171 observations) *zbe01-02_person95_201003: Personal information (13859 observations) *zbe01-02_sum95_231003: Diaries (35813 observations)--> There are three diareis for each individual, 1 for the normal day (Monday-Friday), 1 for Saturday, 1 for Sunday. The normal day is the same for all the household members use zbe01-02_sum95_231003.dta, clear sort idhh idpers save zbe01-02_sum95_231003.dta, replace use zbe01-02_person95_201003, clear sort idhh idpers save zbe01-02_person95_201003.dta, replace use zbe01-02_haus95_201003, clear sort idhh save zbe01-02_haus95_201003.dta, replace use zbe01-02_sum95_231003.dta, clear merge idhh idpers using zbe01-02_person95_201003.dta, drop if _merge==2 drop _merge sort idhh merge idhh using zbe01-02_haus95_201003.dta drop if _merge==2 drop _merge compress save Germany_2001.dta, replace **at the end of the process, we have the 35813 observations ******************************************************************************************************************** /*ONCE WE HAVE THE GERMAN DATA READY TO BE CONVERTED TO MTUS FORMAT, WE ASSIGN THE DIFFERENT MTUS VARIABLES*/ use Germany_2001.dta, clear sort idhh idpers compress *DIARY, SURVEY AND CASE INFORMATION *********************************** /*COUNTRY NUMBER FOR SPAIN HAS BEEN DEFINED BEFORE, SO WE ASSIGN THE NUMBER 13 FOR GERMANY*/ generate COUNTRY=13 /* IN THE SURVEY THERE ARE DATA COLLECTED IN THE LAST NINE MONTHS OF THE YEAR 2002, AND THE FIRST THREE MONTHS OF THE YEAR 2002, SO WE ASSES 2001 AS THE YEAR OR REFERENCE*/ generate SURVEY=2001 /*THIS VARIABLE IS USED FOR DIFFERENCING BETWEEN WAVES IN THE CASE IN WHICH THERE ARE MORE THAN A YEAR. IN THE GERMAN CASE THERE IS ONLY ONE WAVE*/ generate SWAVE=0 /*THIS VARIABLE IS USED FOR DIFFERENCING THE DATA IN CASE THAT THERE IS INFORMATION COMING FROM DIFFERENT SURVEYS. IN THE GERMAN CASE ALL THE INFORMATION COME FROM THE SAME SURVEY*/ generate MSAMP=0 /*WE USE THE ORIGINAL GERMAN HOUSEHOLD IDENTIFIERS FOR DIFFEENCING ACROSS HOUSEHOLDS*/ generate HLDID=idhh /*WE USE THE ORIGINAL GERMAN PERSON IDENTIFIERS FOR DIFFERENCING ACROSS INDIVIDUALS*/ generate PERSID=idpers /* THE SURVEY RECORDS DATA FOR VARIOUS DAYS, SO WE USE THE ID ASSIGNED BY THE GERMAN STATISTICAL AGENCY*/ generate ID=idtag /* IN THE DATA THE VARIABLE "wt" INDICATES THE DAY OF THE WEEK, AND NUMBER 1 CORRESPONDS TO MONDAY, 2 TO TUESDAY, AND SO ON FINISHING WITH THE NUMBER 7 ON SUNDAY*/ generate DAY= 1 if wt==7 replace DAY=2 if wt==1 replace DAY=3 if wt==2 replace DAY=4 if wt==3 replace DAY=5 if wt==4 replace DAY=6 if wt==5 replace DAY=7 if wt==6 replace DAY=-8 if DAY==. /* IN THE GERMAN SURVEY THE MONTH TO WHICH THE DIARY QUESTIONNAIRE IS REFERRED IS DIRECTLY REPORTED */ generate MONTH=1 if monat==1 replace MONTH=2 if monat==2 replace MONTH=3 if monat==3 replace MONTH=4 if monat==4 replace MONTH=5 if monat==5 replace MONTH=6 if monat==6 replace MONTH=7 if monat==7 replace MONTH=8 if monat==8 replace MONTH=9 if monat==9 replace MONTH=10 if monat==10 replace MONTH=11 if monat==11 replace MONTH=12 if monat==12 /* YEAR WHEN THE DIARY WAS KEPT*/ generate YEAR=2001 if jahr==2001 replace YEAR=2002 if jahr==2002 /*THIS VARIABLE IS USED FOR DIFFERENCING IN THE CASE IN WHICH THERE ARE MORE THAN 1 DAY IN THE DIARY QUESTIONNAIRE, BUT IN THE GERMAN SURVEY THERE IS ONLY ONE DAY REPORTED*/ generate DIARY=idtag /*WE USE THE GERMAN VARIABLE "NMH" WHICH DIRECTLY ASSIGNS THE HOUSEHOLD SIZE*/ generate HHLDSIZE=hgroesse /* PERSON IDENTIFER OF SPOUSE OF PARTNER */ generate PARTID=idpart replace PARTID=-7 if PARTID==. /* MARITAL STATUS */ generate MARRIED=1 if ph01e==1 replace MARRIED=0 if ph01e!=1 replace PARTID=-8 if PARTID==-7 & MARRIED==1 /* CIVIC STATUS */ generate CIVSTAT=1 if typpart==1 | typpart==2 replace CIVSTAT=2 if typpart==3 /* COHABITING */ generate COHAB=1 if typpart==2 replace COHAB=0 if typpart!=2 /* SEX OF THE DIARIST */ generate SEX=1 if ph01c==1 replace SEX=2 if ph01c==2 /* AGE OF THE DIARIST */ generate AGE=ph01b2x replace AGE=80 if ph01b2x>=80 /*DOES HOUSEHOLD HAVE A COMPUTER */ generate COMPUTER=1 if h0713>0 replace COMPUTER=0 if h0713==0 /* WHETHER DIARIST'S HOUSEHOLD OWNS OR RENTS HOME */ generate OWNHOME=1 if h05==1 replace OWNHOME=2 if h05==2 replace OWNHOME=3 if h05==3 replace OWNHOME=-8 if OWNHOME==. /*DOES HOUSEHOLD HAVE ACCESS TO A PRIVATE VEHICLE */ generate number_vehicles=h0722 + h0723 replace number_vehicles=h0722 if number_vehicles==. replace number_vehicles=h0723 if number_vehicles==. generate VEHICLE=3 if number_vehicles==1 replace VEHICLE=4 if number_vehicles>1 replace VEHICLE=0 if number_vehicles==. | number_vehicles==0 /* CREATING THE VARIABLE OF THE NUMBER OF CHILDREN UNDER 18 IN THE HOUSEHOLD. THIS VARIABLE WILL BE CONSTRUCTED USING THE VARIABLE "ph01b2x" THAT INDICATES THE RESPONDENT'S AGE INDEPENDENTLY OF WHETHER THE CHILD IS RELATED WITH THE REFERENCE PERSON OR NOT*/ sort idhh gen CHILD=1 if ph01b2x<18 & DIARY==1 by idhh: egen NCHILD=count(CHILD) by idhh: replace NCHILD=0 if NCHILD==. drop CHILD by idhh: egen MIN_AGE=min(ph01b2x) by idhh: egen MIN_AGE_inter=min(juki) replace NCHILD=NCHILD+1 if MIN_AGE>MIN_AGE_inter * PERSON IDENTIFER OF 1ST AND 2ND PARENT OF DIARIST * for num 1/10: generate PARNTID_X=. sort idhh local ipers=1 while `ipers'<11{ local irel=2 while `irel'<11{ by idhh: replace PARNTID_`irel'=`ipers' if idpers==`irel' & ph01f`ipers'==6 & PARNTID_`irel'==. by idhh: replace PARNTID_`ipers'=`irel' if idpers==`ipers' & ph01f`ipers'[`irel']==4 & PARNTID_`ipers'==. local irel=`irel'+1 } local ipers=`ipers'+1 } for num 1/10: generate PARNTID_X_bis=. sort idhh local ipers=1 while `ipers'<11{ local irel=2 while `irel'<11{ by idhh: replace PARNTID_`irel'_bis=`ipers' if idpers==`irel' & ph01f`ipers'==6 by idhh: replace PARNTID_`ipers'_bis=`irel' if idpers==`ipers' & ph01f`ipers'[`irel']==4 local irel=`irel'+1 } local ipers=`ipers'+1 } for num 1/10: replace PARNTID_X=0 if PARNTID_X==. for num 1/10: replace PARNTID_X_bis=0 if PARNTID_X_bis==. egen PARNTID1=rsum(PARNTID_1 - PARNTID_10) egen PARNTID2=rsum(PARNTID_1_bis - PARNTID_10_bis) replace PARNTID2=-7 if PARNTID1==PARNTID2 replace PARNTID1=-7 if PARNTID1==0 replace PARNTID2=-7 if PARNTID2==0 replace PARNTID1=-7 if HHLDSIZE==1 replace PARNTID2=-7 if HHLDSIZE==1 for num 1/10:drop PARNTID_X_bis PARNTID_X /* CREATING THE VARIABLE OF THE AGE OF YOUNGEST CHILDREN IN THE HOUSEHOLD (CATEGORIES) */ capture drop CHILD generate CHILD=. local ipers=1 while `ipers'<11{ local irel=1 while `irel'<11{ by idhh: replace CHILD=1 if idpers==`ipers' & ph01f`ipers'[`irel']==6 by idhh: replace CHILD=1 if idpers==`irel' & ph01f`ipers'==4 local irel=`irel'+1 } local ipers=`ipers'+1 } replace CHILD=0 if CHILD==. generate CHILDAGE=ph01b2x if ph01b2x<18 replace CHILDAGE=ph01b2x if CHILD==1 by idhh: egen KID_one=min(CHILDAGE) by idhh: egen KID_two=min(juki) generate KID=-7 if KID_one==. & KID_two==. replace KID=KID_one if KID_one!=. & KID_two==. replace KID=KID_two if KID_one==. & KID_two!=. replace KID=KID_one if KID_one<=KID_two & KID==. replace KID=KID_two if KID_one>KID_two & KID==. generate AGEKID=1 if (KID>=0 & KID<=4) replace AGEKID=2 if (KID>=5 & KID<=12) replace AGEKID=3 if (KID>=13 & KID<=17) replace AGEKID=4 if (KID>=18) replace AGEKID=-7 if KID==-7 /* CREATING THE VARIABLE OF THE AGE OF YOUNGEST CHILDREN IN THE HOUSEHOLD */ gen AGEKID2=KID replace AGEKID2=-7 if AGEKID2==. replace AGEKID2=80 if AGEKID2>=80 /*WE CONSTRUCT THIS VARIABLE TO BE ABLE TO COMPUTE THE POPULATION WEIGHTS LATER, ALTHOUGH WE WILL NOT KEEP THIS VARIABLE*/ generate AGEGR5Y=1 if ph01b2x>=0 & ph01b2x<=4 replace AGEGR5Y=2 if ph01b2x>=5 & ph01b2x<=9 replace AGEGR5Y=3 if ph01b2x>=10 & ph01b2x<=14 replace AGEGR5Y=4 if ph01b2x>=15 & ph01b2x<=19 replace AGEGR5Y=5 if ph01b2x>=20 & ph01b2x<=24 replace AGEGR5Y=6 if ph01b2x>=25 & ph01b2x<=29 replace AGEGR5Y=7 if ph01b2x>=30 & ph01b2x<=34 replace AGEGR5Y=8 if ph01b2x>=35 & ph01b2x<=39 replace AGEGR5Y=9 if ph01b2x>=40 & ph01b2x<=44 replace AGEGR5Y=10 if ph01b2x>=45 & ph01b2x<=49 replace AGEGR5Y=11 if ph01b2x>=50 & ph01b2x<=54 replace AGEGR5Y=12 if ph01b2x>=55 & ph01b2x<=59 replace AGEGR5Y=13 if ph01b2x>=60 & ph01b2x<=64 replace AGEGR5Y=14 if ph01b2x>=65 & ph01b2x<=69 replace AGEGR5Y=15 if ph01b2x>=70 & ph01b2x<=74 replace AGEGR5Y=16 if ph01b2x>=75 & ph01b2x<=79 replace AGEGR5Y=17 if ph01b2x>=80 ** RELATION TO REFERENCE PERSON * ********************************* generate RELREFP=1 if idpers==1 replace RELREFP=2 if ph01f1==2 | ph01f1==3 replace RELREFP=3 if ph01f1==4 replace RELREFP=4 if ph01f1==6 replace RELREFP=5 if ph01f1==5 replace RELREFP=7 if ph01f1==8 replace RELREFP=9 if ph01f1==7 | ph01f1==8 | ph01f1==9 replace RELREFP=10 if ph01f1==10 replace RELREFP=-8 if RELREFP==. /* WHETHER THE DIARIST IS A CITIZEN OF THE COUNTRY */ generate CITIZEN=1 if ph01d==1 replace CITIZEN=0 if ph01d==2 replace CITIZEN=-8 if CITIZEN==. /* HOUSEHOLD TYPE */ generate HHTYPE=. replace HHTYPE=1 if h_typ1==1 replace HHTYPE=2 if h_typ1==2 & HHLDSIZE==2 replace HHTYPE=3 if h_typ1==4 | (h_typ1==3 & HHLDSIZE>2) replace HHTYPE=4 if h_typ1==3 | h_typ1==5 /* WHETHER DIARIST IS A SINGLE PARENT */ generate SINGPAR=1 if h_typ1==3 replace SINGPAR=0 if h_typ1!=3 /* UNMARRIED CHILD LIVING IN PARENTAL HOME */ ** NOW, WE CREATE THE VARIABLE USING THE INFORMATION ON WHETHER THEY ARE MARRIED OR COHABITING (PARTNER==1) AND WHETHER THEY ARE LIVING WITH THE PARENTS (CHILD) ** generate CPHOME=1 if CIVSTAT==2 & COHAB==0 & CHILD==1 replace CPHOME=0 if CPHOME==. /* FAMSTAT */ /* INDIVIDUAL LEVEL FAMILY STATUS */ generate FAMSTAT=. replace FAMSTAT=0 if NCHILD==0 & (AGEKID==-7 | AGEKID==4) & (ph01b2x>=18 & ph01b2x<40) replace FAMSTAT=3 if NCHILD==0 & (AGEKID==-7 | AGEKID==4) & (ph01b2x>=40) replace FAMSTAT=1 if NCHILD>0 & AGEKID==1 & ph01b2x>=18 replace FAMSTAT=2 if NCHILD>0 & (AGEKID==2 | AGEKID==3 | AGEKID==4) & ph01b2x>=18 replace FAMSTAT=4 if ph01b2x<18 & CHILD==1 replace FAMSTAT=5 if ph01b2x<18 & CHILD==0 /*IN THE GERMAN DATA THE VARIABLE IS CALLED "h153". THE VARIABLE COVERS THE NET HOUSEHOLD INCOME IN "DM (EURO)" SLOTS */ generate INCORIG=h153 /* HARMONIZED INCOME VARIABLE WE HAVE TO TABULATE THE ORIGINAL INCOME VARAIBLE, TO SEE WHERE WE HAVE TO CUT THE DISTRIBUTION tab h153 ******** HF15 Freq. Percent Cum. unter 1950 DM (1000- Euro) 1,525 4.55 4.55 1950 - 2440 DM (1000 - 1250 Euro) 1,509 4.50 9.05 2440 - 2930 DM (1250 - 1500 Euro) 1,993 5.95 15.00 2930 - 4880 DM (1500 - 2500 Euro) 10,341 30.86 45.86 4880 - 7310 DM (2500 - 3750 Euro) 11,736 35.02 80.87 7310 - 9750 DM (3750 - 5000 Euro) 4,478 13.36 94.24 9750 DM oder mehr (5000+) 1,932 5.76 100.00 */ generate INCOME=1 if h153<=3 replace INCOME=2 if h153==4 | h153==5 replace INCOME=3 if h153==6 | h153==7 replace INCOME=-8 if INCOME==. /* EMPLOYMENT STATUS. WE USE TOO THE VARIABLE "H1A5" THAT REFLECTS IF THE PERSON HAS REPORTED FULL/PART TIME */ generate EMPSTAT=1 if vo_te_n==1 replace EMPSTAT=2 if vo_te_n==2 replace EMPSTAT=3 if vo_te_n==3 replace EMPSTAT=4 if vo_te_n==4 /* IN PAID WORK */ generate EMP=1 if EMPSTAT==1 | EMPSTAT==2 | EMPSTAT==3 replace EMP=0 if EMPSTAT==4 /*THOSE WHO ARE WORKING ARE ASKED TO FILL A "WORK QUESTIONNAIRE", AND IN THIS QUESTIONNAIRE THEY ARE ASKED ABOUT THE NUMBER OF WEEKS WORKED DURING THE LAST WEEK WITH THE VARIABLE "I6A"*/ generate WORKHRS=std65 replace WORKHRS=-8 if WORKHRS==. & EMP==1 replace WORKHRS=-7 if WORKHRS==. /* UNEMPLOYED */ generate UNEMP=1 if stat==13 replace UNEMP=0 if stat!=13 /* STUDENT STATUS */ generate STUDENT= 1 if stat>=9 & stat<=11 replace STUDENT=0 if STUDENT==. /* RETIREMENT STATUS */ generate RETIRED= 1 if stat==12 replace RETIRED=0 if stat!=12 /* EMPLOYMENT STATUS OF SPOUSE/PARTNER */ for num 1/10: generate EMPSTATX=EMPSTAT if idpers==X generate EMPSP=. sort idhh local idpers=1 while `idpers'<11{ by idhh: egen EMPSP`idpers'=max(EMPSTAT`idpers') by idhh: replace EMPSP=EMPSP`idpers' if PARTID==`idpers' local idpers=`idpers'+1 } replace EMPSP=-8 if (CIVSTAT==1 | COHAB==1) & EMPSP==. replace EMPSP=-7 if EMPSP==. replace EMPSP=1 if et_part==1 & EMPSP==-8 replace EMPSP=2 if et_part==2 & EMPSP==-8 replace EMPSP=4 if et_part==3 & EMPSP==-8 for num 1/10: drop EMPSTATX EMPSPX /* DIARIST LOOKS AFTER AN ADULT OR CHILD WITH A DISABILITY */ generate CARER=1 if p078a==1 | p0818==1 | p0868==1 | p0878==1 | p0888==1 | p0898==1 replace CARER=-8 if p078a>2 replace CARER=0 if CARER==. /* DIARIST'S GENERAL HEALTH */ generate HEALTH=0 if p10==4 | p10==5 replace HEALTH=1 if p10==3 replace HEALTH=2 if p10==2 replace HEALTH=3 if p10==1 replace HEALTH=-8 if HEALTH==. /*WE COMPUTE THE INCOME. WE HAVE TO SORT OUT IF THE INCOME */ generate EMPINCLM=p30 replace EMPINCLM=-8 if EMPINCLM==. & EMP==1 replace EMPINCLM=-7 if EMPINCLM==. replace EMPINCLM=p37 if EMPINCLM==-8 /*THE VARIABLE "p121" INDICATES THE HIGHER LEVEL OF STUDIES REACHED */ generate EDUCA=1 if p121==5 | p121==4 replace EDUCA=2 if p121==3 replace EDUCA=3 if p121==2 | p121==1 replace EDUCA=3 if baa_n==2 | baa_n==3 | baa_n==4 replace EDUCA=2 if baa_n==1 replace EDUCA=1 if baa_n==5 | baa_n==6 replace EDUCA=-8 if EDUCA==. /*WITH THE GERMAN VARIABLE PREVIOUSLY DEFINED (I32) WE ASSIGN THE THREE LEVELS OF EDUCATION.*/ generate EDTRY=1 if EDUCA==1 replace EDTRY=2 if EDUCA==2 replace EDTRY=3 if EDUCA==3 replace EDTRY=-8 if EDTRY==. /* SECTOR OF EMPLOYMENT */ generate SECTOR=1 if p23==1 replace SECTOR=2 if p23==2 replace SECTOR=-8 if EMP==1 & SECTOR==. replace SECTOR=-7 if SECTOR==. /* OCCUPATION (variable p202x)*/ generate OCCUP=12 if p202x==1 replace OCCUP=13 if p202x==2 replace OCCUP=13 if p202x==3 replace OCCUP=13 if p202x==4 replace OCCUP=3 if p202x==5 replace OCCUP=13 if p202x==6 replace OCCUP=13 if p202x==7 replace OCCUP=8 if p202x==8 replace OCCUP=3 if p202x==9 replace OCCUP=7 if p202x==10 replace OCCUP=13 if p202x==11 replace OCCUP=13 if p202x==12 replace OCCUP=11 if p202x==13 replace OCCUP=11 if p202x==14 replace OCCUP=13 if p202x==15 replace OCCUP=3 if p202x==16 replace OCCUP=9 if p202x==17 replace OCCUP=11 if p202x==18 replace OCCUP=11 if p202x==19 replace OCCUP=10 if p202x==20 replace OCCUP=9 if p202x==21 replace OCCUP=9 if p202x==22 replace OCCUP=10 if p202x==23 replace OCCUP=9 if p202x==24 replace OCCUP=6 if p202x==25 replace OCCUP=4 if p202x==26 replace OCCUP=5 if p202x==27 replace OCCUP=3 if p202x==28 replace OCCUP=7 if p202x==29 replace OCCUP=7 if p202x==30 replace OCCUP=-8 if EMPSTAT>0 & EMPSTAT<4 & OCCUP==. replace OCCUP=-7 if OCCUP==. *********************************************************************************************************************************** *********************************************************************************************************************************** *********************************************************************************************************************************** /*URBAN OR RURAL HOUSEHOLD */ generate URBAN=-9 /* WHETHER THE DIARIST GENERALLY FEELS RUSHED */ generate RUSHED=-9 /*DIARIST HAS A DISABILITY OR LONG-TERM LIMITING HEALTH CONDITION */ generate DISAB=-9 **************************************************************************************************************************************** **************************************************************************************************************************************** **************************************************************************************************************************************** replace NCHILD=0 if AGEKID==4 **TIME USE VARIABLES ******************** generate AV1=zh100+zh110+zh111+zh130+zh131+zh132+zh133+zh134+zh135+zh136+zh137+zh138+zh139+zh140+zh141+zh142+zh143+zh149+zh161 generate AV2=0 generate AV3=zh120+zh121 generate AV4=zh21+zh23+zh24+zh200 generate AV5=zh150+zh151+zh152+zh159+zh911+zh912+zh913+zh919+zh921+zh922+zh929 generate AV6=zh310+zh311+zh312+zh313+zh314+zh319 generate AV7=zh320+zh321+zh322+zh324+zh329+zh330+zh331+zh332+zh339 generate AV8=zh35+zh37+zh39+zh42+zh300+zh323+zh334+zh342+zh344+zh345+zh347 generate AV9=zh340+zh341+zh343+zh349 generate AV10=zh360+zh361+zh362+zh369 generate AV11=zh380+zh381+zh382+zh383+zh384+zh385+zh386+zh387+zh388+zh389 generate AV12=zh901+zh931+zh932+zh933+zh934+zh935+zh936+zh939+zh942+zh991 generate AV13=zh000+zh030+zh031+zh039 generate AV14=zh363+zh364 generate AV15=zh020+zh021 generate AV16=zh010+zh011+zh012 generate AV17=zh952+zh953+zh959+zh961+zh971+zh981+zh990+zh992+zh993 generate AV18=zh500+zh523+zh524+zh526 generate AV19=zh600+zh610+zh614+zh615+zh616+zh617+zh618+zh619+zh620+ /// zh621+zh622+zh623+zh624+zh625+zh626+zh627+zh628+zh629+zh639+zh640+zh641+zh649+zh650+zh651 generate AV20=zh525 generate AV21=zh346+zh611+zh612+zh613+zh642 generate AV22=zh442+zh443 generate AV23=zh400+zh410+zh411+zh412+zh419+zh441+zh449+zh941+zh944+zh949+zh951+zh995 generate AV24=zh521+zh522 generate AV25= zh510+zh513+zh519+zh520+zh529 generate AV26=0 generate AV27=0 generate AV28=zh527 generate AV29=zh512 generate AV30=zh831 generate AV31=zh820+zh821+zh822 generate AV32=zh830+zh832 generate AV33=zh840+zh841+zh842+zh843+zh849+zh22 generate AV34=zh813 generate AV35=zh810+zh811+zh812+zh814+zh819 generate AV36=zh53 generate AV37=zh511+zh514 generate AV38=0 generate AV39=zh333 generate AV40=zh833+zh800+zh998+zh7 generate AV41=zh999 *CREATING THE VARIABLE WHICH GATHER THE TOTAL AMOUNT OF TIME REPORTED BY THE DIARIST TO SEE WHETHER THE DAIRIST egen TOTTIME=rsum(AV*) generate marker=1 if TOTTIME>1440 gen TOTTIME_bis= zh0+ zh1+ zh2+ zh3+ zh4+ zh5+ zh6+ zh7+zh8 if marker==1 generate marker_bis=1 if TOTTIME_bis==1440 ******************************************** for num 1/9: gen TOTTIME_prueba_X=TOTTIME-zh9X if marker_bis==1 replace AV17=zh941+zh944+zh949+zh951+zh952+zh953+zh959+zh961+zh981+zh990+zh992+zh993 if marker_bis==1 drop TOTTIME egen TOTTIME=rsum(AV1 - AV41) replace AV17=0 if TOTTIME>1440 drop TOTTIME egen TOTTIME=rsum(AV1 - AV41) replace AV41=AV41+(1440-TOTTIME) if TOTTIME<1440 drop TOTTIME egen TOTTIME=rsum(AV1 - AV41) tab TOTTIME replace AV2=-9 replace AV26=-9 replace AV27=-9 replace AV38=-9 ******************************************************************************************************************************************************** ********************************************************************************************************************************************************** *NOW WE CORRECT FOR THE QUALITY OF THE DIARIES ********************************************** ********************************************************************************************************************************************************** ********************************************************************************************************************************************************** **NO AGE OR GENDER ****************** generate loss_sex_age=1 if SEX<0 | AGE<0 replace loss_sex_age=0 if loss_sex_age==. **91+ MISSING MINUTES OF ACTIVITY ********************************* generate missing_91=1 if AV41>90 replace missing_91=1 if TOTTIME>1440 replace missing_91=0 if missing_91==. **DIARIES WITH LESS THAN SEVEN EPISODES *************************************** local i=0 while `i'<10{ local j=0 while `j'<10{ local k=0 while `k'<10{ capture gen ZH`i'`j'`k'=1 if zh`i'`j'`k'>0 local k=`k'+1 } local j=`j'+1 } local i=`i'+1 } egen number_episodes=rsum(ZH*) drop ZH* *2+ OR MORE OF THESE BASIC ACTIVITIES MISSING: SLEEP OR REST, EATING OR DRINKING, PERSONAL CARE, TRAVEL/EXERCISE **************************************************************************************************************** generate eat=zh310+zh311+zh312+zh313+zh314+zh319+zh020+zh021+zh527 replace eat=-8 if eat==0 replace eat=0 if eat>0 replace eat=1 if eat==-8 generate rest=zh010+zh011+zh012+zh53 replace rest=-8 if rest==0 replace rest=0 if rest>0 replace rest=1 if rest==-8 gen pcare=zh030+zh031+zh039+zh000+zh901 replace pcare=-8 if pcare==0 replace pcare=0 if pcare>0 replace pcare=1 if pcare==-8 gen trav=zh911+zh913+zh919+zh150+zh151+zh152+zh159+zh912+zh921+zh922+zh929+zh991+zh931+zh932+zh933+zh935+zh936+zh939+zh942+zh981+zh990+zh992+zh993+zh952+zh953+zh959+zh961+zh971+zh610+zh600+zh614+zh615+zh616+zh617+zh618+zh619+zh620+zh621+zh622+zh623+zh624+zh625+zh626+zh627+zh628+zh629+zh639+zh640+zh641+zh649+zh650+zh651+zh346+zh611+zh612+zh613+zh642+zh526+zh523+zh500+zh524 replace trav=-8 if trav==0 replace trav=0 if trav>0 replace trav=1 if trav==-8 generate misbasic=eat+rest+pcare+trav generate caremark=zh380+zh381+zh382+zh383+zh384+zh385+zh386+zh387+zh388+zh389+zh934+zh344+zh345+zh346+zh347 generate misbasic2=0 replace misbasic2=1 if misbasic>1 & caremark==0 replace misbasic2=0 if caremark>0 generate loss_basic_activities=1 if misbasic2==1 replace loss_basic_activities=0 if loss_basic_activities==. generate missing_day=1 if DAY==. replace missing_day=0 if DAY!=. **WITH THE FOUR INDICATORS, WE COMPUTE THE "BADCASE" VARIABLE ************************************************************* /* BAD CASE MARKER */ generate BADCASE=. replace BADCASE=0 if loss_sex_age==0 & missing_day==0 & missing_91==0 & number_episodes>=7 & loss_basic_activities==0 replace BADCASE=1 if loss_sex_age==1 & missing_day==0 & missing_91==0 & number_episodes>=7 & loss_basic_activities==0 replace BADCASE=2 if loss_sex_age==0 & missing_day==1 & missing_91==0 & number_episodes>=7 & loss_basic_activities==0 replace BADCASE=3 if loss_sex_age==0 & missing_day==0 & missing_91==1 & number_episodes>=7 & loss_basic_activities==0 replace BADCASE=4 if loss_sex_age==0 & missing_day==0 & missing_91==0 & number_episodes<7 & loss_basic_activities==0 replace BADCASE=5 if loss_sex_age==0 & missing_day==0 & missing_91==0 & number_episodes>=7 & loss_basic_activities==1 replace BADCASE=6 if loss_sex_age==1 & missing_day==1 & missing_91==0 & number_episodes>=7 & loss_basic_activities==0 replace BADCASE=7 if loss_sex_age==1 & missing_day==0 & missing_91==1 & number_episodes>=7 & loss_basic_activities==0 replace BADCASE=8 if loss_sex_age==1 & missing_day==0 & missing_91==0 & number_episodes<7 & loss_basic_activities==0 replace BADCASE=9 if loss_sex_age==1 & missing_day==0 & missing_91==0 & number_episodes>=7 & loss_basic_activities==1 replace BADCASE=10 if loss_sex_age==0 & missing_day==1 & missing_91==1 & number_episodes>=7 & loss_basic_activities==0 replace BADCASE=11 if loss_sex_age==0 & missing_day==1 & missing_91==0 & number_episodes<7 & loss_basic_activities==0 replace BADCASE=12 if loss_sex_age==0 & missing_day==1 & missing_91==0 & number_episodes>=7 & loss_basic_activities==1 replace BADCASE=13 if loss_sex_age==0 & missing_day==0 & missing_91==1 & number_episodes<7 & loss_basic_activities==0 replace BADCASE=14 if loss_sex_age==0 & missing_day==0 & missing_91==1 & number_episodes>=7 & loss_basic_activities==1 replace BADCASE=15 if loss_sex_age==0 & missing_day==0 & missing_91==0 & number_episodes<7 & loss_basic_activities==1 replace BADCASE=16 if loss_sex_age==1 & missing_day==1 & missing_91==1 & number_episodes>=7 & loss_basic_activities==0 replace BADCASE=17 if loss_sex_age==1 & missing_day==1 & missing_91==0 & number_episodes<7 & loss_basic_activities==0 replace BADCASE=18 if loss_sex_age==1 & missing_day==1 & missing_91==0 & number_episodes>=7 & loss_basic_activities==1 replace BADCASE=19 if loss_sex_age==1 & missing_day==0 & missing_91==1 & number_episodes<7 & loss_basic_activities==0 replace BADCASE=20 if loss_sex_age==1 & missing_day==0 & missing_91==1 & number_episodes>=7 & loss_basic_activities==1 replace BADCASE=21 if loss_sex_age==1 & missing_day==0 & missing_91==0 & number_episodes<7 & loss_basic_activities==1 replace BADCASE=22 if loss_sex_age==0 & missing_day==1 & missing_91==1 & number_episodes<7 & loss_basic_activities==0 replace BADCASE=23 if loss_sex_age==0 & missing_day==1 & missing_91==1 & number_episodes>=7 & loss_basic_activities==1 replace BADCASE=24 if loss_sex_age==0 & missing_day==1 & missing_91==0 & number_episodes<7 & loss_basic_activities==1 replace BADCASE=25 if loss_sex_age==0 & missing_day==0 & missing_91==1 & number_episodes<7 & loss_basic_activities==1 replace BADCASE=26 if loss_sex_age==1 & missing_day==1 & missing_91==1 & number_episodes<7 & loss_basic_activities==0 replace BADCASE=27 if loss_sex_age==1 & missing_day==1 & missing_91==1 & number_episodes>=7 & loss_basic_activities==1 replace BADCASE=28 if loss_sex_age==1 & missing_day==1 & missing_91==0 & number_episodes<7 & loss_basic_activities==1 replace BADCASE=29 if loss_sex_age==1 & missing_day==0 & missing_91==1 & number_episodes<7 & loss_basic_activities==1 replace BADCASE=30 if loss_sex_age==0 & missing_day==1 & missing_91==1 & number_episodes<7 & loss_basic_activities==1 replace BADCASE=31 if loss_sex_age==1 & missing_day==1 & missing_91==1 & number_episodes<7 & loss_basic_activities==1 ************************************************************************************************************************************** *SAMPLE WEIGHTS. /*IN THE GERMAN DATA THERE ARE WEIGHTS FOR THE INDIVIDUALS BUT THE PROBLEM IS THAT NOT EVERY PEOPLE REPORTS 1440 MINUTES OF ACTIVITIES AND WE HAVE TO DELETE THOSE WHICH MORE THAN 60 MINUTES OF Missing ACTIVITIES. AS A RESULT THE ORIGINAL POPULATION WEIGHTS ARE NOT CORRECT AND WE HAVE TO RECONSTRUCT THE WEIGHTS. IN THE MTUS DATA FILES THERE ARE THREE KIND OF WEIGHTS, ALL OF THEM OBTAINED AFTER THE FINAL SAMPLE HAVE BEEN SELECTED: POPWT2: POST-HOC POPULATION WEIGHTS (age-sex spedific) DAYWT2: POST-HOC DAY WEIGHT (age-sex specific) PROPWT: PROPOSED WEIGHT (population and day combined weight reescaled if needed) WE CONSTRUCT FIRST THE DAYWT2, AFTER THE POPWT2 WEIGHTS AND FINALLY (FROM THE PREVIOUS WEIGHTS CONSTRUCTED) THE PROPWT, REESCALING THAT PROPOSED WEIGHT WE MUST TAKE INTO ACCOUNT THE PRESENCE OF BAD DIARIES IN THE SAMPLE*/ generate OCOMBWT=g_pzv95n egen COUNTP=count(TOTTIME) if BADCASE==0 sort SEX AGEGR5Y DAY egen DAYWT=group(SEX AGEGR5Y DAY) if BADCASE==0 egen NGROUPSD=max(DAYWT) if BADCASE==0 by SEX AGEGR5Y DAY: egen DAYCOUNT2=count(DAYWT) if BADCASE==0 sort SEX AGEGR5Y egen WEEKWT=group(SEX AGEGR5Y) if BADCASE==0 egen NGROUPSP=max(WEEKWT) if BADCASE==0 by SEX AGEGR5Y: egen WKCOUNT2=count(WEEKWT) if BADCASE==0 generate PROPWT=((WKCOUNT2/7)/DAYCOUNT2) if BADCASE==0 replace PROPWT=0 if BADCASE!=0 egen COUNTT=count(idhh) rename COUNTP countp egen COUNTP=max(countp) replace PROPWT=PROPWT*(COUNTT/COUNTP) ************************************************************************************************************************************************** ************************************************************************************************************************************************** **AFTER COMPUTING ALL THE VARIABLES, WE MAKE SOME CORRECTIONS AFTER THE QUALITY CHECKS ************************************************************************************************************************************************** ************************************************************************************************************************************************** /* 1) there are some cases where FAMSTAT=4 (aged<18 with parents) or FAMSTAT=2 (living with children aged 5-17) but nchild=0 > nchild should be 1 or greater for all famstat=2 and famstat=4-->DONE 2)similarly (possibly the same problem) there are some diarists aged 15-17 in households with nchild=0-->DONE 3)the 109 cases of agekid(x)=4 adult child but famstat=2 are probably cases where agekid(x) should =3 4)3 cases famstat=4 and cphome=0 -> they either should be famstat=5 cphome=0 or famstat=4 and cphome=1 */ **1) **** tab AGE if NCHILD==0 & FAMSTAT==4 tab HLDID if NCHILD==0 & FAMSTAT==4 replace NCHILD=2 if NCHILD==0 & FAMSTAT==4 tab jukigr1 if NCHILD==0 & FAMSTAT==2 replace FAMSTAT=0 if (AGE>=18 & AGE<40) & FAMSTAT==2 & NCHILD==0 replace FAMSTAT=3 if AGE>=40 & FAMSTAT==2 & NCHILD==0 **2)--> DONE WHEN DOING POINT 1) ******************************** tab AGE if NCHILD==0 **3)--> DONE WITH POINT 2 ************************* tab AGEKID if FAMSTAT==2 **4) **** tab FAMSTAT CPHOME tab RELREFP if FAMSTAT==4 & CPHOME==0 replace CPHOME=1 if FAMSTAT==4 & CPHOME==0 /* There are two missing values for FAMSTAT */ tab HLDID HHLDSIZE if FAMSTAT==. tab AGE if FAMSTAT==. replace FAMSTAT=3 if FAMSTAT==. /* INCORIG AND EMPINCLM *********************** There are some missing values for the income variable. There should be no missing cases. If the original variables have some missing cases, then there are three possibilities. It might be that some children have not been assigned household level variables. If this is the case, you need to copy these values to the whole househole. It might be these cases are missing for people who are retired. No empinclm might be for people who are not employed. If the people for whom the data is missing would not have a relevant value, they should be - 7. Otherwise they should be -8.*/ sort HLDID by HLDID: egen check_child_inform=max(h153) tab check_child_inform **WE GET 2299 MISSING CASES,SO WE HAVE NOT GOT THAT SOME CHILDREN HAVE NOT BEEN ASSIGNED HOUSEHOLD LEVEL VARIABLES by HLDID: egen check_retired=sum(RETIRED) replace INCORIG=-7 if check_retired==HHLDSIZE replace INCOME=-7 if check_retired==HHLDSIZE by HLDID: egen check_unemployed=sum(UNEMP) replace INCORIG=-7 if check_unemployed==HHLDSIZE replace INCOME=-7 if check_unemployed==HHLDSIZE replace INCORIG=-8 if EMPINCLM==. ******************************************************************** * Stata syntax to change variables from upper case to lower case * ******************************************************************** rename COUNTRY country rename SURVEY survey rename SWAVE swave rename MSAMP msamp rename HLDID hldid rename PERSID persid rename ID id rename PARNTID1 parntid1 rename PARNTID2 parntid2 rename PARTID partid rename DAY day rename MONTH month rename YEAR year rename DIARY diary rename BADCASE badcase rename HHTYPE hhtype rename HHLDSIZE hhldsize rename NCHILD nchild rename AGEKID agekid rename AGEKID2 agekid2 rename INCORIG incorig rename INCOME income rename OWNHOME ownhome rename URBAN urban rename COMPUTER computer rename VEHICLE vehicle rename SEX sex rename AGE age rename FAMSTAT famstat rename CPHOME cphome rename SINGPAR singpar rename RELREFP relrefp rename CIVSTAT civstat rename COHAB cohab rename CITIZEN citizen rename EMPSTAT empstat rename EMP emp rename UNEMP unemp rename STUDENT student rename RETIRED retired rename EMPSP empsp rename WORKHRS workhrs rename EMPINCLM empinclm rename OCCUP occup rename SECTOR sector rename EDUCA educa rename EDTRY edtry rename RUSHED rushed rename HEALTH health rename CARER carer rename DISAB disab rename OCOMBWT ocombwt rename PROPWT propwt for num 1/41: rename AVX avX ****************************************************************** * Stata syntax to harmonise all the MTUS W5.3 variable labels * ****************************************************************** #delimit; lab var country "Country of survey"; lab def country 1 "Argentina" 2 "Austria" 3 "Australia" 4 "Belgium" 5 "Brazil" 6 "Bulgaria" 7 "Canada" 8 "China" 9 "Denmark" 10 "Estonia" 11 "Finland" 12 "France" 13 "Germany" 14 "Hungary" 15 "India" 16 "Ireland" 17 "Israel" 18 "Italy" 19 "Japan" 20 "Latvia" 21 "Lithuania" 22 "Netherlands" 23 "New Zealand" 24 "Norway" 25 "Peru" 26 "Poland" 27 "Portugal" 28 "Republic of Korea" 29 "Romania" 30 "Russia" 31 "Slovak Republic/Czechoslovakia" 32 "Slovenia/Yugoslavia" 33 "South Africa" 34 "Spain" 35 "Sweden" 36 "Turkey" 37 "United Kingdom" 38 "USA" ; lab val country country ; lab var survey "Year survey began (survey id)"; lab var swave "longitudinal study wave marker"; lab def swave 0 "not longitudinal study/case" 1 "Wave 1" 2 "Wave 2" 3 "Wave 3" 4 "Wave 4" ; lab val swave swave ; lab var msamp "multiple samples in study"; lab def msamp 0 "1 sample" 1 "Szalai USA 65 sample" 2 "national USA 65 sample" 3 "original NHAPS" 4 "95 NHAPS supplement" 5 "USA 85 mail back sample" 6 "USA 85 phone interview" 7 "USA 85 personal interview" 8 "Szalai Slovenia" 9 "Szalai Serbia" ; lab val msamp msamp ; lab var hldid "Household identifier"; lab def hldid 0 "1 person sampled per household"; lab val hldid hldid ; lab var persid "Person/diarist identifier"; lab var id "Diary identifier"; lab var parntid1 "Person id 1st parent of diarist"; lab var parntid2 "Person id 2nd parent of diarist"; lab var partid "Person id of spouse or partner"; lab def parntid1 -9 "counld not be created" -8 "could not identify parent in hh" -7 "diarist does not live with parent"; lab val parntid1 parntid1; lab def parntid2 -9 "counld not be created" -8 "could not identify parent in hh" -7 "diarist does not live with parent"; lab val parntid2 parntid2; lab def partid -9 "counld not be created" -8 "could not identify partner in hh" -7 "diarist does not have partner"; lab val partid partid; lab var day "Day of week diary kept"; lab def day 1 "Sunday" 2 "Monday" 3 "Tuesday" 4 "Wednesday" 5 "Thursday" 6 "Friday" 7 "Saturday" 8 "Whole week average" 9 "Unspecified weekday" 10 "Unspecified weekend day" -8 "missing" -9 "could not be created"; lab val day day; lab var month "Month diary kept"; lab def month 1 "January" 2 "February" 3 "March" 4 "April" 5 "May" 6 "June" 7 "July" 8 "August" 9 "September" 10 "October" 11 "November" 12 "December" -8 "missing" -9 "could not be created"; lab val month month; lab var year "Year diary kept"; lab def year -8 "missing" -9 "could not be created"; lab val year year; #delimit; lab var diary "Diary order"; lab def diary 1 "1st diary day" 2 "2nd diary day" 3 "3rd diary day" 4 "4th diary day" 5 "5th diary day" 6 "6th diary day" 7 "7th diary day" 8 "Weekly average" -8 "missing" -9 "could not be created"; lab val diary diary; lab var badcase "marker of low quality cases"; lab def badcase 0 "good case" 1 "miss age or sex only" 2 "miss day of week only" 3 "miss 91+ minutes only" 4 "<7 episodes only" 5 "miss 2+ basic acts only" 6 "miss age/sex + day of week" 7 "miss age/sex + 91+ min" 8 "miss age/sex + <7 episodes" 9 "miss age/sex + 2+ basic acts" 10 "miss day of week + 91+ min" 11 "miss day of week + <7 episodes" 12 "miss day of week + 2+ basic acts" 13 "miss 91+ min + <7 episodes" 14 "miss 91+ min + 2+ basic acts" 15 "<7 ep & miss 2+ basic acts" 16 "miss age/sex + day or week + 91+ min" 17 "miss age/sex + day or week + <7 episodes" 18 "miss age/sex + day or week + 2+ basic acts" 19 "miss age/sex + 91+ min + <7 eps" 20 "miss age/sex + 91+ min + 2+ basic acts" 21 "miss age/sex + 2+ basic acts + <7 eps" 22 "miss day or week + 91+ min + <7 eps" 23 "miss day or week + 91+ min + 2+ basic acts" 24 "miss day or week + 2+ basic acts + <7 eps" 25 "miss 91+ min + 2+ basic acts + <7 eps" 26 "miss age/sex + day or week + 91+ min + <7 episodes" 27 "miss age/sex + day or week + 91+ min + 2+ basic acts" 28 "miss age/sex + day or week + <7 episodes + 2+ basic acts" 29 "miss age/sex + 91+ min + <7 episodes + 2+ basic acts" 30 "day or week + 91+ min + <7 episodes + 2+ basic acts" 31 "bad on all five points" ; lab val badcase badcase ; lab var hhtype "Household type"; lab def hhtype 1 "1 person household" 2 "Married/cohabiting couple alone" 3 "Married/cohabiting couple + others" 4 "Other household types" -7 "not applicable/not asked" -8 "missing" -9 "could not be created"; lab val hhtype hhtype; lab var hhldsize "# people in household"; lab def hhldsize -7 "not applicable/not asked" -8 "missing" -9 "could not be created"; lab val hhldsize hhldsize; lab var nchild "# child aged<18 in hhold"; lab def nchild -7 "not applicable/not asked" -8 "missing" -9 "could not be created"; lab val nchild nchild; lab var agekid "Age youngest child in hhold"; lab def agekid 1 "age 0-4" 2 "age 5-12" 3 "age 13-17" 4 "adult child" -7 "not applicable/not asked" -8 "missing" -9 "could not be created"; lab val agekid agekid; lab var agekid2 "Actual age youngest child in hhold"; lab def agekid2 80 "80 or older" -7 "not applicable/not asked" -8 "missing" -9 "could not be created"; lab val agekid2 agekid2; lab var incorig "Original household income"; lab var income "Total hhold income grouped"; lab def income 1 "lowest 25%" 2 "middle 50%" 3 "highest 25%" -7 "not applicable/not asked" -8 "missing" -9 "could not be created"; lab val incorig incorig; lab var ownhome "owns or rents home"; lab def ownhome 1 "own outright or mortgage" 2 "rents" 3 "other" -8 "missing" -9 "could not be created"; lab val ownhome ownhome; lab var urban "Urban or rural hhold"; lab def urban 1 "urban/suburban" 2 "rural/semi-rural" -7 "not applicable/not asked" -8 "missing" -9 "could not be created"; lab val urban urban; lab var computer "hhold has computer/internet access"; lab def computer 0 "no" 1 "yes" -7 "not applicable/not asked" -8 "missing" -9 "could not be created"; lab val computer computer; lab var vehicle "hhold access to a private vehicle"; lab def vehicle 0 "no" 1 "animal only" 2 "non-motorised vehicle" 3 "1 car/motorcycle" 4 "2+ cars/motocycles" -8 "missing" -9 "could not be created" ; lab val vehicle vehicle; lab var sex Sex; lab def sex 1 "Man" 2 "Woman" -8 "missing"; lab val sex sex; lab var age Age; lab def age 80 "80 or older" -7 "not asked" -8 "missing"; lab val age age; lab var famstat "Individual level family status"; lab def famstat 0 "Aged 18 to 39 with no coresident children <18" 1 "Aged 18+ living with 1+ coresident children aged <5" 2 "Aged 18+ living with 1+ coresident children 5-17, none <5" 3 "Aged 40+ with no coresident children <18" 4 "Aged <18 and living with parent(s)/guardian(s)" 5 "Aged <18, living arrangement other or unknown" -7 "not applicable/not asked" -8 "missing" -9 "could not be created"; lab val famstat famstat; lab var cphome "Unmarried child in parental home"; lab def cphome 0 "no" 1 "yes" -7 "not applicable/not asked" -8 "missing" -9 "could not be created"; lab val cphome cphome; lab var singpar "diarist a single parent"; lab def singpar 0 "no" 1 "yes" -7 "not applicable/not asked" -8 "missing" -9 "could not be created"; lab val singpar singpar; #delimit; lab var relrefp "Relation to hhold ref person"; lab def relrefp 1 "person 1" 2 "spouse/partner" 3 "child" 4 "parent" 5 "sibling" 6 "son/daughter-in-law" 7 "parent-in-law" 8 "brother/sister-in-law" 9 "other relative" 10 "not related" -7 "not applicable/not asked" -8 "missing" -9 "could not be created"; lab val relrefp relrefp; lab var civstat "Civic status"; lab def civstat 1 "couple (married/cohabiting/civ partnership)" 2 "not live with a spouse/partner" -7 "not applicable/not asked" -8 "missing" -9 "could not be created"; lab val civstat civstat; lab var cohab "diarist cohabiting"; lab def cohab 0 "no, married" 1 "yes, cohabitting" -7 "not in couple" -8 "missing" -9 "could not be created"; lab val cohab cohab; lab var citizen "Diarist is citizen/national of country"; lab def citizen 0 "no" 1 "yes" -7 "not applicable/not asked" -8 "missing" -9 "could not be created"; lab val citizen citizen; lab var empstat "employment status"; lab def empstat 1 "full-time" 2 "part-time" 3 "unknown job hours" 4 "not in paid work" -7 "not applicable/not asked" -8 "missing" -9 "could not be created"; lab val empstat empstat; lab var emp "in paid work"; lab def emp 0 "not in paid work" 1 "in paid work" -7 "not applicable/not asked" -8 "missing" -9 "could not be created"; lab val emp emp; lab var unemp "Unemployed"; lab def unemp 0 "no" 1 "yes" -7 "not applicable/not asked" -8 "missing" -9 "could not be created"; lab val unemp unemp; lab var student "Student status"; lab def student 0 "not student" 1 "student" -7 "not applicable/not asked" -8 "missing" -9 "could not be created"; lab val student student; lab var retired "Retirement status"; lab def retired 0 "not retired" 1 "retired" -7 "not applicable/not asked" -8 "missing" -9 "could not be created"; lab val retired retired; lab var empsp "Emp status spouse/partner"; lab def empsp 1 "full-time" 2 "part-time" 3 "unknown job hours" 4 "not in paid work" -7 "not applicable/not asked" -8 "missing" -9 "could not be created"; lab val empsp empsp; lab var workhrs "Hours paid work last week inc overtime"; lab def workhrs -7 "not applicable/not asked" -8 "missing" -9 "could not be created"; lab val workhrs workhrs; lab var empinclm "Orig monthly labour income"; lab def empinclm -7 "not applicable/not asked" -8 "missing" -9 "could not be created"; lab val empinclm empinclm; lab var occup "Occupation"; lab def occup 1 "management" 2 "finance/legal profsnl" 3 "science/engineering profsnl" 4 "civil and social services" 5 "education professional" 6 "medical professional" 7 "other professional" 8 "health/social care support" 9 "clerical or office support" 10 "security and armed forces" 11 "sales and services" 12 "farming or forestry" 13 "construction, assembly" 14 "self-employed non-professional" -7 "not applicable/not asked" -8 "missing" -9 "could not be created"; lab val occup occup; lab var sector "Sector of employment"; lab def sector 1 "public sector" 2 "private sector" -7 "not applicable/not asked" -8 "missing" -9 "could not be created"; lab val sector sector; lab var educa "Education-original study codes"; lab def educa -8 "Missing" 1 "Illiterate" 2 "Attended school less than 5 years" 3 "Attended school 5 or more years, no completed secondary education" 4 "Completed secondary education" 5 "High-school degree" 6 "Professional training, first degree" 7 "Professional training, second degree" 8 "General degree" 9 "Bachelor's degree" 10 "Doctoral degree"; lab val educa educa; lab var edtry "Harmonised education"; lab def edtry 1 "inc 2ndry or less" 2 "completed secondary" 3 "above 2ndry education" -7 "not applicable/not asked" -8 "missing" -9 "could not be created"; lab val edtry edtry; lab var rushed "Whether diarist ususally feels rushed"; lab def rushed 0 "almost never" 1 "sometimes" 2 "often" -7 "not applicable/not asked" -8 "missing" -9 "could not be created"; lab val rushed rushed; lab var health "Diarist's general health"; lab def health 0 "poor" 1 "fair" 2 "good" 3 "very good" -7 "not applicable/not asked" -8 "missing" -9 "could not be created"; lab val health health; lab var carer "diarist provides adult care"; lab def carer 0 "no" 1 "yes" -7 "not applicable/not asked" -8 "missing" -9 "could not be created"; lab val carer carer; lab var disab "has disability/l-term hlth cond"; lab def disab 0 "no" 1 "yes" -7 "not applicable/not asked" -8 "missing" -9 "could not be created"; lab val disab disab; lab var av1 "paid work"; lab var av2 "paid work at home"; lab var av3 "second job"; lab var av4 "school/classes"; lab var av5 "travel to/from work"; lab var av6 "cook, wash up"; lab var av7 "housework"; lab var av8 "odd jobs"; lab var av9 "gardening"; lab var av10 "shopping"; lab var av11 "childcare"; lab var av12 "domestic travel"; lab var av13 "dress/personal care"; lab var av14 "consume services"; lab var av15 "meals, snacks"; lab var av16 "sleep"; lab var av17 "free time travel"; lab var av18 "excursions"; lab var av19 "active sport"; lab var av20 "passive sport"; lab var av21 "walks"; lab var av22 "religious activity"; lab var av23 "civic activity"; lab var av24 "cinema, theatre"; lab var av25 "dances, parties"; lab var av26 "social club"; lab var av27 "pub"; lab var av28 "restaurant"; lab var av29 "visit friends"; lab var av30 "listen to radio"; lab var av31 "TV, video"; lab var av32 "listen to CDs records"; lab var av33 "study"; lab var av34 "read books"; lab var av35 "read paper/magazine"; lab var av36 "relax"; lab var av37 "conversation"; lab var av38 "entertain friends"; lab var av39 "knit, sew"; lab var av40 "other leisure"; lab var av41 "missing"; local i=1; while `i'<42{; lab def av`i' -9 "could not be created for study"; local i=`i'+1; }; lab var ocombwt "Original weight"; lab var propwt "Proposed weight"; lab var badcase "Marker of low-quality cases"; /*lab def badcase 0 "good case" 1 "miss age or sex only" 2 "miss day of week only" 3 "miss 91+ minutes only" 4 "<7 episodes only" 5 "miss 2+ basic acts only" 6 "miss age/sex + day of week" 7 "miss age/sex + 91+ min" 8 "miss age/sex + <7 episodes" 9 "miss age/sex + 2+ basic acts" 10 "miss day of week + 91+ min" 11 "miss day of week + <7 episodes" 12 "miss day of week + 2+ basic acts" 13 "miss 91+ min + <7 episodes" 14 "miss 91+ min + 2+ basic acts" 15 "<7 ep & miss 2+ basic acts" 16 "miss age/sex + day or week + 91+ min" 17 "miss age/sex + day or week + <7 episodes" 18 "miss age/sex + day or week + 2+ basic acts" 19 "miss age/sex + 91+ min + <7 eps" 20 "miss age/sex + 91+ min + 2+ basic acts" 21 "miss age/sex + 2+ basic acts + <7 eps" 22 "miss day or week + 91+ min + <7 eps" 23 "miss day or week + 91+ min + 2+ basic acts" 24 "miss day or week + 2+ basic acts + <7 eps" 25 "miss 91+ min + 2+ basic acts + <7 eps" 26 "miss age/sex + day or week + 91+ min + <7 episodes" 27 "miss age/sex + day or week + 91+ min + 2+ basic acts" 28 "miss age/sex + day or week + <7 episodes + 2+ basic acts" 29 "miss age/sex + 91+ min + <7 episodes + 2+ basic acts" 30 "day or week + 91+ min + <7 episodes + 2+ basic acts" 31 "bad on all five points" */; #delimit cr ***************************************************** * Stata syntax to order the W5.53 MTUS variables * ***************************************************** #delimit; order country survey swave msamp hldid persid id parntid1 parntid2 partid day month year diary badcase hhtype hhldsize nchild agekid agekid2 incorig income ownhome urban computer vehicle sex age famstat cphome singpar relrefp civstat cohab citizen empstat emp unemp student retired empsp workhrs empinclm occup sector educa edtry rushed health carer disab av* ocombwt propwt ; #delimit cr keep country survey swave msamp hldid persid id parntid1 parntid2 partid day month year diary badcase hhtype hhldsize nchild agekid agekid2 incorig income ownhome urban computer vehicle sex age famstat cphome singpar relrefp civstat cohab citizen empstat emp unemp student retired empsp workhrs empinclm occup sector educa edtry rushed health carer disab av* ocombwt propwt compress label data "Ger2001W553" sort hldid id persid saveold Ger2001W553.dta, replace *************************************************************************************************************************************************** *FINALLY WE DROP THE INTERMEDIATE FILES WE HAVE CREATED DURING THE PROCESS erase Germany_2001.dta