* This is a Stata do-file. * It will generate and modify all needed variables. *------------------------------------------------------------------------------------------ * generate variables gen nace_allg = . replace nace_allg = 1 if a13 == "10_to_12" replace nace_allg = 1 if a13 == "13" replace nace_allg = 1 if a13 == "14_15" replace nace_allg = 1 if a13 == "10_12" replace nace_allg = 2 if a13 == "16_17" replace nace_allg = 2 if a13 == "18_58_to_60" replace nace_allg = 3 if a13 == "26_27_33" replace nace_allg = 3 if a13 == "19_20_22" replace nace_allg = 3 if a13 == "23" replace nace_allg = 3 if a13 == "29_30" replace nace_allg = 3 if a13 == "31_32" replace nace_allg = 3 if a13 == "21" replace nace_allg = 4 if a13 == "24_25" replace nace_allg = 4 if a13 == "28" replace nace_allg = 5 if a13 == "45_46" replace nace_allg = 6 if a13 == "47" replace nace_allg = 6 if a13 == "49_to_52" replace nace_allg = 8 if a13 == "70_71_78_80_to_82" replace nace_allg = 8 if a13 == "64_to_66_69_80" replace nace_allg = 8 if a13 == "53_61_to_63_79" replace nace_allg = 8 if a13 == "64_to_66_69" replace nace_allg = 8 if a13 == "70_71_78_81_82" replace nace_allg = 9 if a13 == "75_86_to_88" replace nace_allg = 10 if a13 == "68_72_to_74_77" replace nace_allg = 10 if a13 == "90_to_93_96" replace nace_allg = 10 if a13 == "68_72_to_74_77_95" replace nace_allg = 10 if a13 == "90_to_93_95_96" replace nace_allg = 11 if a13 == "94" replace nace_allg = 12 if a13 == "B" replace nace_allg = 12 if a13 == "35_36" replace nace_allg = 12 if a13 == "37_to_39" replace nace_allg = 13 if a13 == "F" replace nace_allg = 14 if a13 == "I" replace nace_allg = 15 if a13 == "O" replace nace_allg = 16 if a13 == "P" replace nace_allg = 1 if a13_DE == "10_to_12" replace nace_allg = 1 if a13_DE == "13_to_15" replace nace_allg = 2 if a13_DE == "16_to_18" replace nace_allg = 2 if a13_DE == "58_to_60" replace nace_allg = 3 if a13_DE == "26_to_27_33" replace nace_allg = 3 if a13_DE == "19_to_21" replace nace_allg = 3 if a13_DE == "22_to_23" replace nace_allg = 3 if a13_DE == "29_to_30" replace nace_allg = 3 if a13_DE == "31_to_32" replace nace_allg = 4 if a13_DE == "24_to_25" replace nace_allg = 4 if a13_DE == "28" replace nace_allg = 5 if a13_DE == "45_to_46" replace nace_allg = 6 if a13_DE == "47" replace nace_allg = 7 if a13_DE == "49_to_52" replace nace_allg = 8 if a13_DE == "70" replace nace_allg = 8 if a13_DE == "71" replace nace_allg = 8 if a13_DE == "78" replace nace_allg = 8 if a13_DE == "79_to_80" replace nace_allg = 8 if a13_DE == "81" replace nace_allg = 8 if a13_DE == "82" replace nace_allg = 8 if a13_DE == "64_to_66_69" replace nace_allg = 8 if a13_DE == "79_to_80" replace nace_allg = 8 if a13_DE == "53" replace nace_allg = 8 if a13_DE == "61_to_63" replace nace_allg = 9 if a13_DE == "86_to_88_75" replace nace_allg = 10 if a13_DE == "68_72_to_74" replace nace_allg = 10 if a13_DE == "90_to_93_95" replace nace_allg = 11 if a13_DE == "94" replace nace_allg = 12 if a13_DE == "B" replace nace_allg = 12 if a13_DE == "35" replace nace_allg = 12 if a13_DE == "36_to_39" replace nace_allg = 13 if a13_DE == "F" replace nace_allg = 14 if a13_DE == "I" replace nace_allg = 15 if a13_DE == "O" replace nace_allg = 16 if a13_DE == "P" replace nace_allg = 1 if a13_EE == "10_to_12" replace nace_allg = 1 if a13_EE == "13" replace nace_allg = 1 if a13_EE == "14_15" replace nace_allg = 2 if a13_EE == "16_17" replace nace_allg = 2 if a13_EE == "18_58_to_60" replace nace_allg = 3 if a13_EE == "19_to_22" replace nace_allg = 3 if a13_EE == "23" replace nace_allg = 3 if a13_EE == "26_27_33" replace nace_allg = 3 if a13_EE == "29_30" replace nace_allg = 3 if a13_EE == "31_32" replace nace_allg = 4 if a13_EE == "24_25" replace nace_allg = 4 if a13_EE == "28" replace nace_allg = 5 if a13_EE == "45_46" replace nace_allg = 6 if a13_EE == "47" replace nace_allg = 7 if a13_EE == "49_to_52" replace nace_allg = 8 if a13_EE == "70_71_78_80_to_82" replace nace_allg = 8 if a13_EE == "64_to_66_69" replace nace_allg = 8 if a13_EE == "53_61_to_63_79" replace nace_allg = 9 if a13_EE == "75_86_to_88" replace nace_allg = 10 if a13_EE == "68_72_to_74_77" replace nace_allg = 10 if a13_EE == "90_to_93_95_96" replace nace_allg = 11 if a13_EE == "94" replace nace_allg = 12 if a13_EE == "B" replace nace_allg = 12 if a13_EE == "35_36" replace nace_allg = 12 if a13_EE == "37_to_39" replace nace_allg = 13 if a13_EE == "F" replace nace_allg = 14 if a13_EE == "I" replace nace_allg = 15 if a13_EE == "O" replace nace_allg = 16 if a13_EE == "P" replace nace_allg = 1 if a13_HR == "10_to_13" replace nace_allg = 1 if a13_HR == "14_15" replace nace_allg = 2 if a13_HR == "16_to_18_58_to_60" replace nace_allg = 3 if a13_HR == "21_26_27_33" replace nace_allg = 3 if a13_HR == "19_20_22" replace nace_allg = 3 if a13_HR == "23" replace nace_allg = 3 if a13_HR == "29_to_32" replace nace_allg = 4 if a13_HR == "24_25" replace nace_allg = 4 if a13_HR == "28" replace nace_allg = 5 if a13_HR == "45_46" replace nace_allg = 6 if a13_HR == "47" replace nace_allg = 7 if a13_HR == "49_to_52" replace nace_allg = 8 if a13_HR == "70_71_78_81_82" replace nace_allg = 8 if a13_HR == "64_to_66_69_80" replace nace_allg = 8 if a13_HR == "53_61_to_63_79" replace nace_allg = 9 if a13_HR == "75_86_to_88" replace nace_allg = 10 if a13_HR == "68_72_to_74_77_95" replace nace_allg = 10 if a13_HR == "90_to_93_96" replace nace_allg = 11 if a13_HR == "94" replace nace_allg = 12 if a13_HR == "B_35_36" replace nace_allg = 12 if a13_HR == "37_to_39" replace nace_allg = 13 if a13_HR == "F" replace nace_allg = 14 if a13_HR == "I" replace nace_allg = 15 if a13_HR == "O" replace nace_allg = 16 if a13_HR == "P" replace nace_allg = 1 if a13_LV == "10_to_12" replace nace_allg = 1 if a13_LV == "13_to_15" replace nace_allg = 2 if a13_LV == "16_17" replace nace_allg = 2 if a13_LV == "18_58_to_60" replace nace_allg = 3 if a13_LV == "19_20_22_23" replace nace_allg = 3 if a13_LV == "26_27_33" replace nace_allg = 3 if a13_LV == "21_29_30" replace nace_allg = 3 if a13_LV == "31_32" replace nace_allg = 4 if a13_LV == "24_25_28" replace nace_allg = 5 if a13_LV == "45_46" replace nace_allg = 6 if a13_LV == "47" replace nace_allg = 7 if a13_LV == "49_to_52" replace nace_allg = 8 if a13_LV == "70_71_78_80_to_82" replace nace_allg = 8 if a13_LV == "64_to_66_69" replace nace_allg = 8 if a13_LV == "53_61_to_63_79" replace nace_allg = 9 if a13_LV == "75_86_to_88" replace nace_allg = 10 if a13_LV == "68_72_to_74_77" replace nace_allg = 10 if a13_LV == "90_to_93_95_96" replace nace_allg = 11 if a13_LV == "94" replace nace_allg = 12 if a13_LV == "B" replace nace_allg = 12 if a13_LV == "35_36" replace nace_allg = 12 if a13_LV == "37_to_39" replace nace_allg = 13 if a13_LV == "F" replace nace_allg = 14 if a13_LV == "I" replace nace_allg = 15 if a13_LV == "O" replace nace_allg = 16 if a13_LV == "P" replace nace_allg = 1 if a13_NL== "10_to_12" replace nace_allg = 1 if a13_NL== "13" replace nace_allg = 1 if a13_NL== "14_15" replace nace_allg = 2 if a13_NL== "16_17" replace nace_allg = 2 if a13_NL== "18_58_to_60" replace nace_allg = 3 if a13_NL== "19_20_22" replace nace_allg = 3 if a13_NL== "21" replace nace_allg = 3 if a13_NL== "23" replace nace_allg = 3 if a13_NL== "26_27_33" replace nace_allg = 3 if a13_NL== "19_20_22" replace nace_allg = 3 if a13_NL== "31_32" replace nace_allg = 3 if a13_NL== "29_30" replace nace_allg = 4 if a13_NL== "24_25" replace nace_allg = 4 if a13_NL== "28" replace nace_allg = 5 if a13_NL== "45_46" replace nace_allg = 6 if a13_NL== "47" replace nace_allg = 7 if a13_NL== "49_to_52" replace nace_allg = 8 if a13_NL== "70_71_78_81_82" replace nace_allg = 8 if a13_NL== "64_to_66_69_80" replace nace_allg = 8 if a13_NL== "53_61_to_63_79" replace nace_allg = 9 if a13_NL== "75_86_to_88" replace nace_allg = 10 if a13_NL== "68_72_to_74_77_95" replace nace_allg = 10 if a13_NL== "90_to_93_96" replace nace_allg = 11 if a13_NL== "94" replace nace_allg = 12 if a13_NL== "B" replace nace_allg = 12 if a13_NL== "35_36" replace nace_allg = 12 if a13_NL== "37_to_39" replace nace_allg = 13 if a13_NL == "F" replace nace_allg = 14 if a13_NL== "I" replace nace_allg = 15 if a13_NL== "O" replace nace_allg = 16 if a13_NL== "P" replace nace_allg = 1 if a13_PT== "10_to_12" replace nace_allg = 1 if a13_PT== "13" replace nace_allg = 1 if a13_PT== "14_15" replace nace_allg = 2 if a13_PT== "16_17" replace nace_allg = 2 if a13_PT== "18_58_to_60" replace nace_allg = 3 if a13_PT== "26_27_33+21" replace nace_allg = 3 if a13_PT== "23" replace nace_allg = 3 if a13_PT== "19_20_22" replace nace_allg = 3 if a13_PT== "29_30" replace nace_allg = 3 if a13_PT== "31_32" replace nace_allg = 4 if a13_PT== "24_25" replace nace_allg = 4 if a13_PT== "28" replace nace_allg = 5 if a13_PT== "45_46" replace nace_allg = 6 if a13_PT== "47" replace nace_allg = 7 if a13_PT== "49_to_52" replace nace_allg = 8 if a13_PT== "70_71_78_81_82" replace nace_allg = 8 if a13_PT== "64_to_66_69_80" replace nace_allg = 8 if a13_PT== "53_61_to_63_79" replace nace_allg = 9 if a13_PT== "75_86_to_88" replace nace_allg = 10 if a13_PT== "68_72_to_74_77_95" replace nace_allg = 10 if a13_PT== "90_to_93_96" replace nace_allg = 11 if a13_PT== "94" replace nace_allg = 12 if a13_PT== "B+35_36" replace nace_allg = 12 if a13_PT== "37_to_39" replace nace_allg = 13 if a13_PT== "F" replace nace_allg = 14 if a13_PT== "I" replace nace_allg = 16 if a13_PT== "P" gen parttime_low = 0 replace parttime_low = 1 if b271<60 gen parttime_high = 0 replace parttime_high = 1 if b271>=60 & b271<100 gen sex = 1 if b21==2 replace sex=2 if b21==1 gen parttime = 0 replace parttime = 1 if b27==2 gen temporary = 0 replace temporary = 1 if b28==2 gen firmsize_allg = . label var firmsize_allg "Einheitliche Firmsize <50" replace firmsize_allg = 1 if a12_class =="1_49" replace firmsize_allg = 0 if a12_class =="50_249" | a12_class =="GT_250" replace firmsize_allg = 1 if a12_class_BE =="1_49" replace firmsize_allg = 0 if a12_class_BE =="50_249" | a12_class_BE =="GT_250" replace firmsize_allg = 1 if a12_class_BG =="1_49" replace firmsize_allg = 0 if a12_class_BG =="50_249" | a12_class_BG =="GT_250" | a12_class_BG =="GT_50" replace firmsize_allg = 1 if a12_class_EE =="1_49" replace firmsize_allg = 0 if a12_class_EE =="GT_50" replace firmsize_allg = 1 if a12_class_ES =="1_49" replace firmsize_allg = 0 if a12_class_ES =="50_249" | a12_class_ES =="GT_250" encode a12_IT , gen(a12_it_num) replace firmsize_allg = 1 if a12_it_num ==1 replace firmsize_allg = 0 if a12_it_num ==2 | a12_it_num ==3 | a12_it_num ==4 | a12_it_num ==6 | a12_it_num ==7 gen tenure_allg = . replace tenure_allg = 1 if b26 < 2 replace tenure_allg = 2 if b26 >1 & b26 <5 replace tenure_allg = 3 if b26 >4 & b26 <15 replace tenure_allg = 4 if b26 >14 & b26 <. replace tenure_allg = 1 if b26_NL ==0 replace tenure_allg = 2 if b26_NL ==2 | b26_NL ==4 replace tenure_allg = 3 if b26_NL ==8 | b26_NL ==10 | b26_NL ==11 replace tenure_allg = 4 if b26_NL ==19 replace tenure_allg = 1 if b26_BE < 2 replace tenure_allg = 2 if b26_BE >1 & b26_BE <5 replace tenure_allg = 3 if b26_BE >4 & b26_BE <15 replace tenure_allg = 4 if b26_BE >14 & b26_BE <. replace tenure_allg = 1 if b26_PT< 2 replace tenure_allg = 2 if b26_PT>1 & b26_PT <5 replace tenure_allg = 3 if b26_PT>4 & b26_PT<15 replace tenure_allg = 4 if b26_PT>14 & b26_PT <. gen isced_allg =. replace isced_allg = 1 if b25 <3 replace isced_allg = 2 if b25 >2 & b25 <5 replace isced_allg = 3 if b25 >4 & b25 <. replace isced_allg = 1 if b25_DE ==2 replace isced_allg = 2 if b25_DE ==3 replace isced_allg = 3 if b25_DE ==5 gen payagreement_allg =. replace payagreement_allg = 0 if a15== 7 replace payagreement_allg = 1 if a15==2 | a15==3 replace payagreement_allg = 2 if a15==4 | a15==5 replace payagreement_allg = 3 if a15==1 replace payagreement_allg = 4 if a15==6 replace payagreement_allg = 0 if a15_DE== 0 replace payagreement_allg = 1 if a15_DE==1 replace payagreement_allg = 2 if a15_DE==2 gen ISCO_allg =. replace ISCO_allg = floor(b23/10) replace ISCO_allg = . if b23==999 replace ISCO_allg = b23 if b23 == 23 | b23 == 33 replace ISCO_allg = b23_BE if country == "BE" replace ISCO_allg = b23_DE if country == "DE" replace ISCO_allg = b23_EL if country == "EL" replace ISCO_allg = b23_DE if country == "DE" replace ISCO_allg = . if country == "DE" & b23_DE==99 replace ISCO_allg = b23_ES if country == "ES" replace ISCO_allg = b23_FI if country == "FI" replace ISCO_allg = b23_HR if country == "HR" replace ISCO_allg = b23_HU if country == "HU" replace ISCO_allg = b23_IT if country == "IT" replace ISCO_allg = b23_NL if country == "NL" replace ISCO_allg = b23_NO if country == "NO" replace ISCO_allg = . if country == "NO" & b23_NO==99 replace ISCO_allg = b23_PT if country == "PT" replace ISCO_allg = b23_RO if country == "RO" replace ISCO_allg = b23_SE if country == "SE" replace ISCO_allg = b23_EL if country == "GR" gen publicctrl = 0 replace publicctrl = 1 if a14==3 *------------------------------------------------------------------------------------------ * modify variables encode a13, gen(a13_num) encode a14, gen (a14_help) rename a14 a14_org rename a14_help a14 encode a15, gen (a15_help) drop a15 rename a15_help a15 encode b21, gen (b21_help) drop b21 rename b21_help b21 encode b27, gen (b27_help) drop b27 rename b27_help b27 encode b28, gen (b28_help) drop b28 rename b28_help b28 *------------------------------------------------------------------------------------------ * generate dummies tab ISCO_allg, gen(ISCO_allg_) tab nace_allg, gen(nace_allg_) *------------------------------------------------------------------------------------------ * define labels label var ISCO_allg "Einheitliches ISCO" label values ISCO_allg b23_s label define payagreement_allg_l 0 "None" label define payagreement_allg_l 1 "industry agreement or agreement for individual industries in individual regions", add label define payagreement_allg_l 2 "enterprise or single employer agreement or agreement applying only to workers in the local unit", add label define payagreement_allg_l 3 "national level or interconfederal agree", add label define payagreement_allg_l 4 "Other", add label values payagreement_allg payagreement_allg_l label var payagreement_allg "Einheitliche payagreement" label var isced_allg "Einheitliches ISCED" label define isced_allg_l 1 "ISCED 0-2" label define isced_allg_l 2 "3-4", add label define isced_allg_l 3 "5+", add label values isced_allg isced_allg_l label define tenure_allg_l 1 "0-1" label define tenure_allg_l 2 "2-4", add label define tenure_allg_l 3 "5-14", add label define tenure_allg_l 4 "15+", add label values tenure_allg tenure_allg_l label var tenure_allg "Einheitliche tenure" label define firmsize_allg_l 0 "50+" label define firmsize_allg_l 1 "1-49", add label values firmsize_allg firmsize_allg_l label var nace_allg "verheinheitlichte nace-klassifizierung" label define nace_allg_l 1 "10_to_13 + 14_15" label define nace_allg_l 2 "16_to_18 + 58_to_60", add label define nace_allg_l 3 "26_to_27_33 + 19_to_22 + 23 + 29_30 + 31_32", add label define nace_allg_l 4 "24_25 + 28", add label define nace_allg_l 5 "45_46", add label define nace_allg_l 6 "47", add label define nace_allg_l 7 "49_to_52", add label define nace_allg_l 8 "70_71_78_81_82 + 64_to_66_69_80 +53_61_to_63_79", add label define nace_allg_l 9 "75_86_to_88", add label define nace_allg_l 10 "68_72_to_74_77_95 + 90_to_93_96", add label define nace_allg_l 11 "94", add label define nace_allg_l 12 "B + 35_36 + 37_to_39", add label define nace_allg_l 13 "F", add label define nace_allg_l 14 "I", add label define nace_allg_l 15 "O", add label define nace_allg_l 16 "P", add label values nace_allg nace_allg_l label var a11 "Geographical location of the statistical unit (local unit) - NUTS-1" label var a12 "Size of the enterprise to which the local unit belongs" label var a13 "Principal economic activity of the local unit (NACE Rev. 2)" label var a14 "Form of economic and financial control" label var a15 "Collective pay agreement" label var a16 "Total number of employees in the local unit in the reference month" label var a17 "Affiliation of the local unit to a group of enterprises" label var a12_class "Size class category of enterprise to which the local unit belongs" label var b21 "Sex" label var b22_class "Age group category" label var b23 "Occupation in the reference month (ISCO- 08)" label var b24 "Management position / supervisory position" label var b25 "Highest successfully completed level of education and training (ISCED-97)" label var b26 "Length of service in enterprise (in years)" label var b27 "Full-time or part-time employee" label var b271 "% share of a full-timer's normal hours (to 2 decimal places)" label var b28 "Type of employment contract" label var b31 "Number of weeks to which the gross annual earnings relate (to 2 decimal places)" label var b32 "Number of hours paid during the reference month" label var b321 "Number of overtime hours paid in the reference month" label var b33 "Annual days of holiday leave (in full days)" label var b34 "Other annual days of paid absence" label var b41 "Gross annual earnings in the reference year" label var b411 "Annual Bonuses and allowances not paid at each pay period" label var b412 "Annual payments in kind" label var b42 "Gross earnings in reference month" label var b421 "Earnings related to overtime" label var b422 "Special payments for shift work" label var b423 "Compulsory social contributions and taxes paid by the employer on behalf of the employee" label var b4231 "Compulsory social security contributions" label var b4232 "Taxes" label var b43 "Average gross hourly earnings in the reference month (to 2 decimal places)" label var b52 "Grossing-up factor for employees (to 2 decimal places)" label var key_e "Key identifying the employee" label var key_l "Key identifying the local unit" label var nace "Economic Sector in NACE Rev. 1.1 (2002 and 2006) and NACE Rev. 2 (2010)" label var a51 "Grossing-up factor for local units (Italy only?)" label define a12_l 0 "1_49" label define a12_l 1 "50_249", add label define a12_l 2 "GT_250", add label define a12_l 4 "All", add label define a14_l 3 "public control" label define a14_l 4 "private control", add label values a14 a14_l label define a15_l 1 "national level or interconfederal agreement" label define a15_l 2 "industry agreement", add label define a15_l 3 "agreement for individual industries in individual regions", add label define a15_l 4 "enterprise or single employer agreement", add label define a15_l 5 "agreement applying only to workers in the local unit", add label define a15_l 6 "any other type of agreement", add label define a15_l 7 "no collective agreement exists", add label values a15 a15_l label define b21_l 1 "female" label define b21_l 2 "male", add label values b21 b21_l label define b23_s 11 "Chief executives, senior officials and legislators" label define b23_s 12 "Administrative and commercial managers", add label define b23_s 13 "Production and specialised services managers", add label define b23_s 14 "Hospitality, retail and other services managers", add label define b23_s 21 "Science and engineering professionals", add label define b23_s 22 "Health professionals", add label define b23_s 23 "Teaching professionals", add label define b23_s 24 "Business and administration professionals", add label define b23_s 25 "Information and communications technology professionals", add label define b23_s 26 "Legal, social and cultural professionals", add label define b23_s 31 "Science and engineering associate professionals", add label define b23_s 32 "Health associate professionals", add label define b23_s 33 "Business and administration associate professionals", add label define b23_s 34 "Legal, social, cultural and related associate professionals", add label define b23_s 35 "Information and communications technicians", add label define b23_s 41 "General and keyboard clerks", add label define b23_s 42 "Customer services clerks", add label define b23_s 43 "Numerical and material recording clerks", add label define b23_s 44 "Other clerical support workers", add label define b23_s 51 "Personal service workers", add label define b23_s 52 "Sales workers", add label define b23_s 53 "Personal care workers", add label define b23_s 54 "Protective services workers", add label define b23_s 61 "Market-oriented skilled agricultural workers", add label define b23_s 62 "Market-oriented skilled forestry, fishery and hunting workers", add label define b23_s 63 "Subsistence farmers, fishers, hunters and gatherers", add label define b23_s 71 "Building and related trades workers, excluding electricians", add label define b23_s 72 "Metal, machinery and related trades workers", add label define b23_s 73 "Handicraft and printing workers", add label define b23_s 74 "Electrical and electronic trades workers", add label define b23_s 75 "Food processing, wood working, garment and other craft and related trades workers", add label define b23_s 81 "Stationary plant and machine operators", add label define b23_s 82 "Assemblers", add label define b23_s 83 "Drivers and mobile plant operators", add label define b23_s 91 "Cleaners and helpers", add label define b23_s 92 "Agricultural, forestry and fishery labourers", add label define b23_s 93 "Labourers in mining, construction, manufacturing and transport", add label define b23_s 94 "Food preparation assistants", add label define b23_s 95 "Street and related sales and service workers", add label define b23_s 96 "Refuse workers and other elementary workers", add label define b23_s 1 "Commissioned armed forces officers", add label define b23_s 3 "Armed forces occupations, other ranks", add label define b23_s 2 "Non-commissioned armed forces officers", add local countryname = "BE DE ES EL FI HR HU IT NL NO PT RO SE" foreach x of local countryname { label values b23_`x' b23_s } label define b23_l 111 "Legislators and senior officials" label define b23_l 112 "Managing directors and chief executives", add label define b23_l 121 "Business services and administration managers", add label define b23_l 122 "Sales, marketing and development managers", add label define b23_l 131 "Production managers in agriculture, forestry and fisheries", add label define b23_l 132 "Manufacturing, mining, construction, and distribution managers", add label define b23_l 133 "Information and communications technology service managers", add label define b23_l 134 "Professional services managers", add label define b23_l 141 "Hotel and restaurant managers", add label define b23_l 142 "Retail and wholesale trade managers", add label define b23_l 143 "Other services managers", add label define b23_l 211 "Physical and earth science professionals", add label define b23_l 212 "Mathematicians, actuaries and statisticians", add label define b23_l 213 "Life science professionals", add label define b23_l 214 "Engineering professionals (excluding electrotechnology)", add label define b23_l 215 "Electrotechnology engineers", add label define b23_l 216 "Architects, planners, surveyors and designers", add label define b23_l 221 "Medical doctors", add label define b23_l 222 "Nursing and midwifery professionals", add label define b23_l 223 "Traditional and complementary medicine professionals", add label define b23_l 224 "Paramedical practitioners", add label define b23_l 225 "Veterinarians", add label define b23_l 226 "Other health professionals", add label define b23_l 231 "University and higher education teachers", add label define b23_l 23 "Teaching professionals", add label define b23_l 33 "Business and administration associate professionals", add label define b23_l 232 "Vocational education teachers", add label define b23_l 233 "Secondary education teachers", add label define b23_l 234 "Primary school and early childhood teachers", add label define b23_l 235 "Other teaching professionals", add label define b23_l 241 "Finance professionals", add label define b23_l 242 "Administration professionals", add label define b23_l 243 "Sales, marketing and public relations professionals", add label define b23_l 251 "Software and applications developers and analysts", add label define b23_l 252 "Database and network professionals", add label define b23_l 261 "Legal professionals", add label define b23_l 262 "Librarians, archivists and curators", add label define b23_l 263 "Social and religious professionals", add label define b23_l 264 "Authors, journalists and linguists", add label define b23_l 265 "Creative and performing artists", add label define b23_l 311 "Physical and engineering science technicians", add label define b23_l 312 "Mining, manufacturing and construction supervisors", add label define b23_l 313 "Process control technicians", add label define b23_l 314 "Life science technicians and related associate professionals", add label define b23_l 315 "Ship and aircraft controllers and technicians", add label define b23_l 321 "Medical and pharmaceutical technicians", add label define b23_l 322 "Nursing and midwifery associate professionals", add label define b23_l 323 "Traditional and complementary medicine associate professionals", add label define b23_l 324 "Veterinary technicians and assistants", add label define b23_l 325 "Other health associate professionals", add label define b23_l 331 "Financial and mathematical associate professionals", add label define b23_l 332 "Sales and purchasing agents and brokers", add label define b23_l 333 "Business services agents", add label define b23_l 334 "Administrative and specialised secretaries", add label define b23_l 335 "Regulatory government associate professionals", add label define b23_l 341 "Legal, social and religious associate professionals", add label define b23_l 342 "Sports and fitness workers", add label define b23_l 343 "Artistic, cultural and culinary associate professionals", add label define b23_l 351 "Information and communications technology operations and user support technicians", add label define b23_l 352 "Telecommunications and broadcasting technicians", add label define b23_l 411 "General office clerks", add label define b23_l 412 "Secretaries (general)", add label define b23_l 413 "Keyboard operators", add label define b23_l 421 "Tellers, money collectors and related clerks", add label define b23_l 422 "Client information workers", add label define b23_l 431 "Numerical clerks", add label define b23_l 432 "Material-recording and transport clerks", add label define b23_l 441 "Other clerical support workers", add label define b23_l 511 "Travel attendants, conductors and guides", add label define b23_l 512 "Cooks", add label define b23_l 513 "Waiters and bartenders", add label define b23_l 514 "Hairdressers, beauticians and related workers", add label define b23_l 515 "Building and housekeeping supervisors", add label define b23_l 516 "Other personal services workers", add label define b23_l 521 "Street and market salespersons", add label define b23_l 522 "Shop salespersons", add label define b23_l 523 "Cashiers and ticket clerks", add label define b23_l 524 "Other sales workers", add label define b23_l 531 "Child care workers and teachersҠaides", add label define b23_l 532 "Personal care workers in health services", add label define b23_l 541 "Protective services workers", add label define b23_l 611 "Market gardeners and crop growers", add label define b23_l 612 "Animal producers", add label define b23_l 613 "Mixed crop and animal producers", add label define b23_l 621 "Forestry and related workers", add label define b23_l 622 "Fishery workers, hunters and trappers", add label define b23_l 631 "Subsistence crop farmers", add label define b23_l 632 "Subsistence livestock farmers", add label define b23_l 633 "Subsistence mixed crop and livestock farmers", add label define b23_l 634 "Subsistence fishers, hunters, trappers and gatherers", add label define b23_l 711 "Building frame and related trades workers", add label define b23_l 712 "Building finishers and related trades workers", add label define b23_l 713 "Painters, building structure cleaners and related trades workers", add label define b23_l 721 "Sheet and structural metal workers, moulders and welders, and related workers", add label define b23_l 722 "Blacksmiths, toolmakers and related trades workers", add label define b23_l 723 "Machinery mechanics and repairers", add label define b23_l 731 "Handicraft workers", add label define b23_l 732 "Printing trades workers", add label define b23_l 741 "Electrical equipment installers and repairers", add label define b23_l 742 "Electronics and telecommunications installers and repairers", add label define b23_l 751 "Food processing and related trades workers", add label define b23_l 752 "Wood treaters, cabinet-makers and related trades workers", add label define b23_l 753 "Garment and related trades workers", add label define b23_l 754 "Other craft and related workers", add label define b23_l 811 "Mining and mineral processing plant operators", add label define b23_l 812 "Metal processing and finishing plant operators", add label define b23_l 813 "Chemical and photographic products plant and machine operators", add label define b23_l 814 "Rubber, plastic and paper products machine operators", add label define b23_l 815 "Textile, fur and leather products machine operators", add label define b23_l 816 "Food and related products machine operators", add label define b23_l 817 "Wood processing and papermaking plant operators", add label define b23_l 818 "Other stationary plant and machine operators", add label define b23_l 821 "Assemblers", add label define b23_l 831 "Locomotive engine drivers and related workers", add label define b23_l 832 "Car, van and motorcycle drivers", add label define b23_l 833 "Heavy truck and bus drivers", add label define b23_l 834 "Mobile plant operators", add label define b23_l 835 "ShipsҠdeck crews and related workers", add label define b23_l 911 "Domestic, hotel and office cleaners and helpers", add label define b23_l 912 "Vehicle, window, laundry and other hand cleaning workers", add label define b23_l 921 "Agricultural, forestry and fishery labourers", add label define b23_l 931 "Mining and construction labourers", add label define b23_l 932 "Manufacturing labourers", add label define b23_l 933 "Transport and storage labourers", add label define b23_l 941 "Food preparation assistants", add label define b23_l 951 "Street and related service workers", add label define b23_l 952 "Street vendors (excluding food)", add label define b23_l 961 "Refuse workers", add label define b23_l 962 "Other elementary worker", add label define b23_l 11 "Commissioned armed forces officers", add label define b23_l 21 "Non-commissioned armed forces officers", add label define b23_l 31 "Armed forces occupations, other ranks", add label values b23 b23_l label define b25_l 1 "ISCED 0 and 1" label define b25_l 2 "ISCED 2", add label define b25_l 3 "ISCED 3 and 4", add label define b25_l 4 "ISCED 5B", add label define b25_l 5 "ISCED 5A", add label define b25_l 6 "ISCED 6", add label values b25 b25_l label define b27_l 1 "full-time" label define b27_l 2 "part-time", add label values b27 b27_l label define b28_l 1 "indefinite duration" label define b28_l 2 "temporary/fixed duration (except apprentice)", add label define b28_l 3 "apprentice", add label values b28 b28_l label var parttime_low "0 bis <60% einer Vollzeitstelle" label var parttime_high "60 bis <100% einer Vollzeitstelle" *------------------------------------------------------------------------------------------ * Euro conversion of the stated income. Conversion rates come from the included Excel file. gen b43_eur = b43 replace b43_eur = b43_eur*(1/1.9558) if country =="BG" replace b43_eur = b43_eur*(1/25.284) if country =="CZ" replace b43_eur = b43_eur*(1/15.6466) if country =="EE" replace b43_eur = b43_eur*(1/7.2891) if country =="HR" replace b43_eur = b43_eur*(1/275.48) if country =="HU" replace b43_eur = b43_eur*(1/3.4528) if country =="LT" replace b43_eur = b43_eur*(1/0.7087) if country =="LV" replace b43_eur = b43_eur*(1/8.0043) if country =="NO" replace b43_eur = b43_eur*(1/3.9947) if country =="PL" replace b43_eur = b43_eur*(1/4.2122) if country =="RO" replace b43_eur = b43_eur*(1/9.5373) if country =="SE" replace b43_eur = b43_eur*(1/0.85784) if country =="UK" gen b43_eur_ln = ln(b43_eur) label var b43_eur_ln "Avg. gross hourly earnings, in , in logs"