* This is a Stata do-file. * It will carry out the Oaxaca-Blinder decomposition *------------------------------------------------------------------------------------------ * drop missings, public sector and apprentices *----------------------------------------------- drop if nace_allg == 15 drop if b28==3 drop if a14 ==1 drop if b28==4 drop if a14==1 drop if a14==2 drop if a14==5 drop if b22_class=="@" drop if b22_class == "14-19" * generates dummies *-------------------- tab payagreement_allg, gen(payagreem_allg_) tab b22_class, gen(age_) tab country, gen(country_) tab isced_allg, gen(isced_allg_) tab tenure_allg, gen(tenure_) * define globals *---------------- global country = "" forvalues i = 1(1)4{ global country ="$country country_`i'" } forvalues i = 6(1)24{ global country ="$country country_`i'" } global isced = "isced_allg_1 isced_allg_3" global isco ="" forvalues i = 1(1)39{ global isco ="$isco ISCO_allg_`i'" } global isco = "$isco ISCO_allg_41 ISCO_allg_42 ISCO_allg_43" global nace = "" forvalues i = 1(1)15{ global nace = "$nace nace_allg_`i'" } global age = "age_1 age_2 age_3 age_5" global rest = "parttime_low parttime_high publicctrl temporary firmsize_allg" global tenure = "tenure_1 tenure_2 tenure_4" * decomposition for single countries *------------------------------------- local mylist1 BE BG CZ DE EE ES FI FR GR HR HU IT LT LV NL NO PL PT RO SE SK UK foreach x of local mylist1 { disp "`x'" * Belgium if "`x'" == "BE" { drop if a12_class_BE=="ALL" } * Bulgaria if "`x'" == "BG" { drop if a12_class_BG=="ALL" drop if a12_class_BG =="GT_50" } * Czech Republic if "`x'" == "CZ" { drop if b23==999 } * Germany if "`x'" == "DE" { drop if a15_DE==3 drop if b23==999 } * Spain if "`x'" == "ES" { drop if a12_class_ES=="ALL" } * Croatia if "`x'" == "HR" { drop if b26==99 & country == "HR" } * Hungary if "`x'" == "HU" { drop if b26==99 & country == "HU" } * Italy if "`x'" == "IT" { drop if b26==99 & country == "IT" } * Lithunia if "`x'" == "LT" { drop if b26==99 & country == "LT" } * Latvia if "`x'" == "LV" { drop if b26==99 & country == "LV" } * Netherlands if "`x'" == "NL" { drop if b26==99 & country == "NL" } * Norway if "`x'" == "NO" { drop if b23_NO==99 & country == "NO" drop if b26==99 & country == "NO" } * Poland if "`x'" == "PL" { drop if b26==99 & country == "PL" } * Portugal if "`x'" == "PT" { drop if b26==99 & country == "PT" } * Rumania if "`x'" == "RO" { drop if b26==99 & country == "RO" } * Sweden if "`x'" == "SE" { drop if b26==99 & country == "SE" } * Slovakia if "`x'" == "SK" { drop if b26==99 & country == "SK" } * United Kingdom if "`x'" == "UK" { drop if a12_class == "UNK" & country == "UK" drop if a14==5 & country == "IK" drop if b26==99 & country == "UK" drop if b26==99 & country == "UK" } * Oaxaca-Blinder decomposition quietly oaxaca b43_eur_ln $rest $age $tenure $isced $isco $nace [pweight= b52] if country == "`x'", by(sex) noisily weight(1) relax detail(hours: parttime_low parttime_high, tenure: tenure*, isced: isced*, beruf: ISCO*, wz: nace*, alter: age*) } * country-pooled sample *------------------------ drop if a12_class_BE == "ALL" drop if a12_class_BG=="ALL" drop if a12_class_BG =="GT_50" drop if b23==999 drop if a15_DE==3 drop if b23==999 drop if a12_class_ES=="ALL" drop if b26==99 & country == "HR" drop if b26==99 & country == "HU" drop if b26==99 & country == "IT" drop if b26==99 & country == "LT" drop if b26==99 & country == "LV" drop if b26==99 & country == "NL" drop if b23_NO==99 & country == "NO" drop if b26==99 & country == "NO" drop if b26==99 & country == "PL" drop if b26==99 & country == "PT" drop if b26==99 & country == "RO" drop if b26==99 & country == "SE" drop if b26==99 & country == "SK" drop if a12_class == "UNK" & country == "UK" drop if a14==5 & country == "IK" drop if b26==99 & country == "UK" drop if b26==99 & country == "UK" oaxaca b43_eur_ln $rest $age $tenure $isced $isco $nace $country [pweight= b52], by(sex) noisily weight(1) relax detail(hours: parttime_low parttime_high, tenure: tenure*, isced: isced*, beruf: ISCO*, wz: nace*, alter: age*, country: country_*) lab var parttime_low "parttime low" lab var parttime_high "parttime high" lab var publicctrl "Public control (>50 %)" lab var temporary "temporary contract" lab var firmsize_allg "firm size" lab var age_1 "age: 20-29 years" lab var age_2 "age: 30-39 years" lab var age_3 "age: 40-49 years" lab var age_4 "age: 50-59 years" lab var age_5 "age: 60 years and older" lab var tenure_1 "tenure: less than 2 years" lab var tenure_2 "tenure: from 2 up to 4 years" lab var tenure_3 "tenure: from 5 up to 14 years" lab var tenure_4 "tenure: 15 years and more" lab var isced_allg_1 "education: low-skilled" lab var isced_allg_2 "education: medium-skilled" lab var isced_allg_3 "education: high-skilled" lab var ISCO_allg_1 "occ: Commissioned armed forces officers" lab var ISCO_allg_2 "occ: Non-commissioned armed forces officers" lab var ISCO_allg_3 "occ: Armed forces occupations, other ranks" lab var ISCO_allg_4 "occ: Chief executives, senior officials and legislators" lab var ISCO_allg_5 "occ: Administrative and commercial managers" lab var ISCO_allg_6 "occ: Production and specialised services managers" lab var ISCO_allg_7 "occ: Hospitality, retail and other services managers" lab var ISCO_allg_8 "occ: Science and engineering professionals" lab var ISCO_allg_9 "occ: Health professionals" lab var ISCO_allg_10 "occ: Teaching professionals" lab var ISCO_allg_11 "occ: Business and administration professionals" lab var ISCO_allg_12 "occ: Information and communications technology professionals" lab var ISCO_allg_13 "occ: Legal, social and cultural professionals" lab var ISCO_allg_14 "occ: Science and engineering associate professionals" lab var ISCO_allg_15 "occ: Health associate professionals" lab var ISCO_allg_16 "occ: Business and administration associate professionals" lab var ISCO_allg_17 "occ: Legal, social, cultural and related associate professionals" lab var ISCO_allg_18 "occ: Information and communications technicians" lab var ISCO_allg_19 "occ: General and keyboard clerks" lab var ISCO_allg_20 "occ: Customer services clerks" lab var ISCO_allg_21 "occ: Numerical and material recording clerks" lab var ISCO_allg_22 "occ: Other clerical support workers" lab var ISCO_allg_23 "occ: Personal service workers" lab var ISCO_allg_24 "occ: Sales workers" lab var ISCO_allg_25 "occ: Personal care workers" lab var ISCO_allg_26 "occ: Protective services workers" lab var ISCO_allg_27 "occ: Market-oriented skilled agricultural workers" lab var ISCO_allg_28 "occ: Market-oriented skilled forestry, fishery and hunting workers" lab var ISCO_allg_29 "occ: Subsistence farmers, fishers, hunters and gatherers" lab var ISCO_allg_30 "occ: Building and related trades workers, excluding electricians" lab var ISCO_allg_31 "occ: Metal, machinery and related trades workers" lab var ISCO_allg_32 "occ: Handicraft and printing workers" lab var ISCO_allg_33 "occ: Electrical and electronic trades worker" lab var ISCO_allg_34 "occ: Food processing, wood working, garment and other craft and related trades workers" lab var ISCO_allg_35 "occ: Stationary plant and machine operators" lab var ISCO_allg_36 "occ: Assemblers" lab var ISCO_allg_37 "occ: Drivers and mobile plant operators" lab var ISCO_allg_38 "occ: Cleaners and helpers" lab var ISCO_allg_39 "occ: Agricultural, forestry and fishery labourers" lab var ISCO_allg_40 "occ: Labourers in mining, construction, manufacturing and transport" lab var ISCO_allg_41 "occ: Food preparation assistants" lab var ISCO_allg_42 "occ: Street and related sales and service workers" lab var ISCO_allg_43 "occ: Refuse workers and other elementary workers" lab var nace_allg_1 "industry: Food industry and textiles" lab var nace_allg_2 "industry: Paper, Printing and publishing" lab var nace_allg_3 "industry: Chemical products, electric and transport equipment" lab var nace_allg_4 "industry: Basic metals and metal products" lab var nace_allg_5 "industry: Wholesale trade" lab var nace_allg_6 "industry: Retail Trade" lab var nace_allg_7 "industry: Transportation and storage" lab var nace_allg_8 "industry: Business services" lab var nace_allg_9 "industry: Health and social work activities" lab var nace_allg_10 "industry: Professional, scientific and creative services" lab var nace_allg_11 "industry: Mining, energy and water supply" lab var nace_allg_12 "industry: Construction" lab var nace_allg_13 "industry: Accommodation and food services" lab var nace_allg_14 "industry: Education" lab var nace_allg_15 "industry: Activities of membership organisations" lab var country_1 "country dummy: BE" lab var country_2 "country dummy: BG" lab var country_3 "country dummy: CZ" lab var country_4 "country dummy: DE" lab var country_5 "country dummy: EE" lab var country_6 "country dummy: ES" lab var country_7 "country dummy: FI" lab var country_8 "country dummy: FR" lab var country_9 "country dummy: GR" lab var country_10 "country dummy: HR" lab var country_11 "country dummy: HU" lab var country_12 "country dummy: IT" lab var country_13 "country dummy: LT" lab var country_14 "country dummy: LV" lab var country_15 "country dummy: NL" lab var country_16 "country dummy: NO" lab var country_17 "country dummy: PL" lab var country_18 "country dummy: PT" lab var country_19 "country dummy: RO" lab var country_20 "country dummy: SE" lab var country_21 "country dummy: SK" lab var country_22 "country dummy: UK"