*Erstellt am 19.08.2016 *Zuletzt geändert: 19.08.2016 *Variablen aufbereiten vom Haushaltsdatensatz cd "I:\wealth\Migranten und Wohnungseigentum\Data\Datensaetze" use hmaster_mig.dta set more off ************* Variablen generieren/ändern/Missings setzen ************* *Homeownership gen downer=. replace downer=1 if owner==1 replace downer=0 if owner==2 | owner==3 | owner==4 | owner==5 *Age replace gebjahr=. if gebjahr<0 gen alter=jahr-gebjahr /*Check for missings*/ *Age categories, dummy variables (2) gen alter17_45=(alter<=45) gen alter45=(alter>45 & alter!=.) replace alter17_45=. if alter==. replace alter45=. if alter==. *One categorial variable (2) gen alterKat2=. replace alterKat2=1 if alter17_45==1 replace alterKat2=2 if alter45==1 label define alterKat2 1 "17-45" 2 "45" label values alterKat2 alterKat2 *Age categories, dummy variables (3) gen alter17_30=(alter<=30) gen alter31_60=(alter>30 & alter<=60) gen alter60=(alter>60 & alter!=.) replace alter17_30=. if alter==. replace alter31_60=. if alter==. replace alter60=. if alter==. *One categorial variable (3) gen alterKat3=. replace alterKat3=1 if alter17_30==1 replace alterKat3=2 if alter31_60==1 replace alterKat3=3 if alter60==1 label define alterKat3 1 "17-30" 2 "31-60" 3 "60" label values alterKat3 alterKat3 *Country/Region of origin gen oecd=0 // oecd gleich Null sind auch alle, die bei corigin ein Missing haben, sowie deutsche (analog andere variablen) replace oecd=1 if corigin==41 | corigin==10 | corigin==117 | corigin==55 | corigin==20 | corigin==13 | corigin==17 | corigin==11 | corigin==4 | corigin==71 | corigin==39 | corigin==5 | corigin==40 | corigin==23 | corigin==116 | corigin==34 | corigin==118 | corigin==16 | corigin==28 | corigin==122 | corigin==6 | corigin==15 | corigin==19 | corigin==14 | corigin==18 | corigin==12 replace oecd=. if corigin<0 gen cee=0 replace cee=1 if corigin==101 | corigin==103 | corigin==146 | corigin==26 | corigin==31 | corigin==123 | corigin==22 | corigin==3 | corigin==75 | corigin==29 | corigin==21 | corigin==222 | corigin==78 | corigin==73 | corigin==32 | corigin==74 replace cee=. if corigin<0 gen turkey=0 replace turkey=1 if corigin==2 replace turkey=. if corigin<0 gen otherorigin=0 replace otherorigin=1 if oecd==0 & cee==0 & turkey==0 & corigin!=-3 & corigin!=-2 & corigin!=-1 & corigin!=1 & corigin!=. replace otherorigin=. if corigin<0 gen germany=1 if corigin==1 replace germany=0 if oecd==1 | cee==1 | turkey==1 | otherorigin==1 gen corigin2=. replace corigin2=1 if oecd==1 replace corigin2=2 if cee==1 replace corigin2=3 if turkey==1 replace corigin2=4 if otherorigin==1 *Other categories gen oecd2=0 // oecd gleich Null sind auch alle, die bei corigin ein Missing haben, sowie deutsche (analog andere variablen) replace oecd2=1 if corigin==18 | corigin==19 | corigin==20 | corigin==23 | corigin==34 | corigin==39 | corigin==40 | corigin==41 | corigin==55 replace oecd2=. if corigin<0 gen eu2=0 replace eu2=1 if corigin==4 | corigin==5 | corigin==6 | corigin==10 | corigin==11 | corigin==12 | corigin==13 | corigin==14 | corigin==15 | corigin==17 | corigin==28 | corigin==71 | corigin==116 | corigin==117 | corigin==118 replace eu2=. if corigin<0 gen cee2=0 replace cee2=1 if corigin==21 | corigin==22 | corigin==26 | corigin==29 | corigin==31 | corigin==32 | corigin==73 | corigin==74 | corigin==75 | corigin==78 | corigin==101 | corigin==103 | corigin==119 | corigin==120 | corigin==121 | corigin==122 | corigin==123 | corigin==132 | corigin==165 | corigin==146 | corigin==140 | corigin==222 replace cee2=. if corigin<0 gen turkey2=0 replace turkey2=1 if corigin==2 replace turkey2=. if corigin<0 gen yugos2=0 replace yugos2=1 if corigin==3 replace yugos2=. if corigin<0 gen otherorigin2=0 replace otherorigin2=1 if oecd2==0 & cee2==0 & turkey2==0 & yugos2==0 & eu2==0 & corigin!=-3 & corigin!=-2 & corigin!=-1 & corigin!=1 & corigin!=. replace otherorigin2=. if corigin<0 gen corigin3=. replace corigin3=1 if oecd2==1 replace corigin3=2 if cee2==1 replace corigin3=3 if turkey2==1 replace corigin3=4 if otherorigin2==1 replace corigin3=5 if yugos2==1 replace corigin3=6 if eu2==1 *gender gen mann=1 if sex==1 replace mann=0 if sex==2 *region gen west=1 if region==1 replace west=0 if region==2 *employment status gen empld=. if employ==-1 replace empld=1 if employ==1 replace empld=0 if employ==0 *migration cohort replace immiyear=. if immiyear<0 gen migcohort48=(immiyear>=1948 & immiyear<1974) gen migcohort74=(immiyear>=1974 & immiyear<1984) gen migcohort84=(immiyear>=1984) replace migcohort48=. if immiyear==. replace migcohort74=. if immiyear==. replace migcohort84=. if immiyear==. gen migcohort=. replace migcohort=1 if migcohort48==1 replace migcohort=2 if migcohort74==1 replace migcohort=3 if migcohort84==1 *years since migration gen ysm=jahr-immiyear if immiyear>0 *migration variable gen mig=. replace mig=1 if migback==2 replace mig=0 if migback==1 | migback==3 /*Mig ist 1, wenn die Person einen direkten Migrationshintergrund hat*/ label define mig 0 "natives or sec-generation migrants" 1 "first-generation migrants" label values mig mig *Net income replace netinc=. if netinc<0 *Marital status replace marital=. if marital==-1 gen married=1 if marital==1 replace married=0 if marital>1 & marital!=. gen single=1 if marital==2 replace single=0 if marital!=2 & marital!=. gen widowed=1 if marital==3 replace widowed=0 if marital!=3 & marital!=. gen divorced=1 if marital==4 replace divorced=0 if marital!=4 & marital!=. gen separated=1 if marital==5 replace separated=0 if marital!=5 & marital!=. *education replace educ=. if educ==-1 *Language most used (1=mostly german, 2=mostly language of corigin, 3=both equally) replace language=. if language<0 label define language 1 "mostly german" 2 "mostly country of origin" 3 "both equally" label values language language *spouse in Germany rename birelhs2 spouse_ger replace spouse_ger=. if spouse_ger==-2 replace spouse_ger=1 if spouse_ger==1 | spouse_ger==2 replace spouse_ger=0 if spouse_ger==3 *wish to stay in Germany gen stay=. replace stay=. if bistay==-2 replace stay=1 if bistay==3 replace stay=0 if bistay==1 | bistay==2 *Zuzug in Wohnort der Bekannten rename bifamcl zuzug_bek replace zuzug_bek=. if zuzug_bek<0 replace zuzug_bek=1 if zuzug_bek==1 replace zuzug_bek=0 if zuzug_bek==2 *Newspaper language replace newspaper=. if newspaper<0 *Oral ability German (1=very well, 2=good, 3=fairly, 4=poorly, 5=not at all) replace oralgerman=. if oralgerman<0 label define german 1 "very well" 2 "good" 3 "fairly" 4 "poorly" 5 "not at all" label values oralgerman german *Finalen Datensatz speichern: save "I:\wealth\Migranten und Wohnungseigentum\Data\Datensaetze\hmaster_mig_aufbereitet", replace