************************************ *****Aufbereitung Betriebsdaten***** *****1993 bis 2006****************** ************************************ log using log\1_Aufbereitung_Betriebdaten.log, replace ************************************** ********* Welle 2000 ***************** ************************************** use orig\LIAB_2007_estab_2000.dta,clear gen h47qual_g=h47qual+h47fach if (h47qual!=-9 & h47fach!=-9) replace h47qual_g=h47qual if (h47fach==-9 & h47qual!=-9) replace h47qual_g=h47fach if (h47qual==-9 & h47fach!=-9) gen h47einf_g=h47unge+h47einf if (h47einf!=-9 & h47unge!=-9) replace h47einf_g=h47unge if (h47einf==-9 & h47unge!=-9) replace h47einf_g=h47einf if (h47unge==-9 & h47einf!=-9) gen jahr=2000 gen share_invest=h19/h12 gen unge = h47unge+h47einf_g gen qual=h47fach+h47qual_g gen bran_n99=. replace h44=3 if h42==3 rename h09 tech rename h18b invest_ict rename h47aus azubi rename h30b nr_grad rename h42 union rename h44 h_wage rename h79 wc rename h01ges00 groesse rename h81b bran_n00 rename h30c azu_ueber keep idnum jahr tech invest_ict share_invest azubi unge qual nr_grad union h_wage wc groesse bran_n00 bran_n99 azu_ueber compress save data\estab_welle_2000.dta, replace clear ************************************** ********* Welle 2001 ***************** ************************************** use orig\LIAB_2007_estab_2001.dta gen i52qual_g=i52qual+i52fach if (i52qual!=-9 & i52fach!=-9) replace i52qual_g=i52qual if (i52fach==-9 & i52qual!=-9) replace i52qual_g=i52fach if (i52qual==-9 & i52fach!=-9) gen i52einf_g=i52unge+i52einf if (i52einf!=-9 & i52unge!=-9) replace i52einf_g=i52unge if (i52einf==-9 & i52unge!=-9) replace i52einf_g=i52einf if (i52unge==-9 & i52einf!=-9) gen jahr=2001 gen share_invest=i25/i07 gen unge = i52unge+i52einf_g gen qual=i52fach+i52qual_g gen bran_n99=. replace i69=3 if i67==3 rename i30 tech rename i24b invest_ict rename i52aus azubi rename i40b nr_grad rename i67 union rename i69 h_wage rename i82 wc rename i01ges01 groesse rename i92b bran_n00 rename i40c azu_ueber keep idnum jahr tech invest_ict share_invest azubi unge qual nr_grad union h_wage wc groesse bran_n00 bran_n99 azu_ueber compress save data\estab_welle_2001.dta, replace clear ************************************** ********* Welle 2002 ***************** ************************************** use orig\LIAB_2007_estab_2002.dta gen j41qual_g=j41qual+j41fach if (j41qual!=-9 & j41fach!=-9) replace j41qual_g=j41qual if (j41fach==-9 & j41qual!=-9) replace j41qual_g=j41fach if (j41qual==-9 & j41fach!=-9) gen j41einf_g=j41unge+j41einf if (j41einf!=-9 & j41unge!=-9) replace j41einf_g=j41unge if (j41einf==-9 & j41unge!=-9) replace j41einf_g=j41einf if (j41unge==-9 & j41einf!=-9) gen jahr=2002 gen share_invest=j14/j06 gen unge = j41unge+j41einf_g gen qual=j41fach+j41qual_g gen bran_n99=. replace j32=3 if j30==3 rename j19 tech rename j13b invest_ict rename j41aus azubi rename j65a nr_grad rename j30 union rename j32 h_wage rename j76 wc rename j01ges02 groesse rename j87b bran_n00 rename j66a azu_ueber keep idnum jahr tech invest_ict share_invest azubi unge qual nr_grad union h_wage wc groesse bran_n00 bran_n99 azu_ueber compress save data\estab_welle_2002.dta, replace clear log close