****************************************************************. * ESEC: European Socioeconomic Classification * kumulierter ALLBUS 1980-2006 * * Programm: esec_allbus_8006.sps (ESeC_ALLBUS_8006_hw_v1.sps) * Version: 09/05/2008 * * Heike Wirth, Andreas Fischer * GESIS-ZUMA * German Microdata Lab (GML) * www.gesis.org/Dauerbeobachtung/GML * heike.wirth@gesis.org * * Basis: * http://www.iser.essex.ac.uk/esec/guide/docs/Appendix6.sps * Die Ausgangssyntax bezieht sich auf den * European Social Survey (ESS) * Der Transfer fuer die ALLBUS-Merkmale entsprechend * der Vorgaben in der Originalsyntax ist dokumentiert in: * Heike Wirth/Andreas Fischer(2008) * ESeC - European Socioeconomic Classification * Die Operationalisierung von ESeC im * kumulierten ALLBUS 1980-2006. * GESIS-ZUMA, Mannheim. * * H I N W E I S E: * * ESeC kann mit den kumulierten ALLBUS Daten 1980-2006 nur * fuer die hauptberuflich erwerbstätige Bevoelkerung * (v513 = 1 oder 2) generiert werden, * fuer nicht hauptberuflich Erwerbstaetige sowie * Nichterwerbstaetige liegen die fuer ESeC benoetigten * Informationen nicht vor * * ESeC kann erst ab dem Erhebungsjahr 1992 generiert werden, * da ISCO88 fuer die frueheren Jahre nicht vorliegt * * Achtung, die ESeC-Originalsyntax bezieht sich auf ISCO-88(com), * diese ist nicht vollstaendig deckungsgleich zu ISCO-88 !!! * Vgl. hierzu: Geis, Alfons (2007): Handbuch fuer die * Berufsverkodung, GESIS-ZUMA, Mannheim, S.32ff; S.109-110 * (http://www.gesis.org/Methodenberatung/Textanalyse/ * Berufs-Branchenklassifikation/Beruf_Branche/hdb_0706.pdf) * Fuer die vorliegende Routine erfolgte eine entsprechende Anpassung *. * Bei Nutzung dieser Routine bitte wie folgt zitieren: * Wirth, H./Fischer, A.(2008): * Die Umsetzung von ESeC fuer den kumulierten * ALLBUS 1980-2006 (SPSS-Routine, V4/4/2008). * GESIS-ZUMA, Mannheim *. ****************************************************************. ****************************************************************. * Constructing version 4 of ESEC Classes from 3 digit ISCO * All variable names and values * refer to cumulated ALLBUS dataset (1980-2006) ****************************************************************. * Einlesen der Daten: Allbus 1980-2006 * Achtung! Anpassung des GET FILE-Kommandos an eigene Daten. * GET FILE='I:\Daten\ALLBUS\DATEN\ALLB80_2006.SAV'. * GET FILE='\ALLB80_2006.sav'. * Manche der fuer die Generierung von ESEC benoetigten * Informationen sind erst ab dem Erhebungsjahr 1992 verfuegbar, deshalb * Konzentration auf Erhebungsjahr 1992ff. *. compute auswahl = (v2 >= 1992). filter by auswahl. missing values V538 V518 v606 (). ****************************************************************. * Stage 1 - derive employment status categories * Family workers (8) here treated as employees. * Variable name in ALLBUS is V515 * "Self-employed" are splited into categorical variable as below ****************************************************************. ****************************************************************. * * * ESeC EMPLOYMENT STATUS ****************************************************************. if (V516=17 or V516=23 or V516=24) or (v515= 1 & (v606 ge 3 & v606 le 9)) @empstat=1. if (V516=16 or V516=22) or (V515=1 and (v606 le 2 or v606 gt 9))@empstat=2. if (V516=15 or V516=21) @empstat=3. if (V515=4 and V538=1) or (V515=5 and V538=1) or (V515=6 and V538=1) or (V515=8 and V538=1) or (V515=9 and V538=1) @empstat=4. if (V515=4 and V538>=2) or (V515=5 and V538>=2) or (V515=6 and V538>=2) or (V515=8 and V538>=2) or (V515=9 and V538>=2) @empstat=5. execute. var labs @empstat 'ESeC employment status variable'. val labs @empstat 1 'Self-employed: 10+ employees' 2 'Self-employed: <10 employees' 3 'Self-employed: one or no employees' 4 'Supervisors' 5 'Employees'. fre var=@empstat. ****************************************************************. * ISCO-88 MINOR GROUPS * Umsetzung ISCO 4-digit auf 3-digit * (1) Umstieg ISCO-88 auf ISCO-88(com) wo notwendig * (vgl. Geis 2007:109-110) * (2) Trunkieren 4-Steller auf 3-Steller ****************************************************************. compute isco_com = v518. recode isco_com (1120, 1130 = 1110) (2132 = 2131) (3241, 3242 = 3229) (3439 = 3431) (5151, 5152 = 5149) (5230 = 5220) (6112, 6114 = 6111) (6113 = 6112) (6123, 6124 = 6129) (6210, 6290 = 6100) (7142 = 7141) (7243 = 7242) (8171 = 8280) (9112 = 9111) (9321 = 8280) (9322 = 9320) (9331 thru 9333 = 9330). compute isco8803 = isco_com. if (V518 >= 1000 & V518 < 10000) isco8803 = trunc(isco_com/10). execute. recode isco8803 (2 = 010) (1,110 = 011) (0 = 66666) (10007 = 77777) (10004, 10008 = 88888) (10009 = 99999). ****************************************************************. freq isco8803. add value labels isco8803 111 "Legislators" 112 "Senior government officials" 113 "Traditional chiefs and heads of villages" 114 "Senior officials of special interest organizations" 120 "Corporate managers" 121 "Directors and chief executives" 122 "Production and operations department managers" 123 "Other departmental managers" 130 "General managers" 131 "General managers" 200 "Professionals" 210 "Physical, mathematical and engineering science professionals" 211 "Physicists, chemists and related professionals" 212 "Mathematicians, statisticians and related professionals" 213 "Computing professionals" 214 "Architects, engineers and related professionals" 220 "Life science and health professionals" 221 "Life science professionals" 222 "Health professionals (except nursing)" 223 "Nursing and midwifery professionals" 230 "Teaching professionals" 231 "College, university and higher education teaching professionals" 232 "Secondary education teaching professionals" 233 "Primary and pre-primary education teaching professionals" 234 "Special education teaching professionals" 235 "Other teaching professionals" 240 "Other professionals" 241 "Business professionals" 242 "Legal professionals" 243 "Archivists, librarians and related information professionals" 244 "Social sciences and related professionals" 245 "Writers and creative or performing artists" 246 "Religious professionals" 300 "Technicians and Associate Professionals" 310 "Physical and engineering science associate professionals" 311 "Physical and engineering science technicians" 312 "Computer associate professionals" 313 "Optical and electronic equipment operators" 314 "Ship and aircraft controllers and technicians" 315 "Safety and quality inspectors" 320 "Life science and health associate professionals" 321 "Life science technicians and related associate professionals" 322 "Modern health associate professionals (except nursing)" 323 "Nursing and midwifery associate professionals" 324 "Traditional medicine practitioners and faith-healers" 330 "Teaching associate professionals" 331 "Primary education teaching associate professionals" 332 "Pre-primary education teaching associate professionals" 333 "Special education teaching associate professionals" 334 "Other teaching associate professionals" 340 "Other associate professionals" 341 "Finance and sales associate professionals" 342 "Business services agents and trade brokers" 343 "Administrative associate professionals" 344 "Customs, tax and related government associate professionals" 345 "Police inspectors and detectives" 346 "Social work associate professionals" 347 "Artistic, entertainment and sports associate professionals" 348 "Religious associate professionals" 400 "Clerks" 410 "Office clerks" 411 "Secretaries and keyboard-operating clerks" 412 "Numerical clerks" 413 "Material-recording and transport clerks" 414 "Library, mail and related clerks" 419 "Other office clerks" 420 "Customer service clerks" 421 "Cashiers, tellers and related clerks" 422 "Client information clerks" 500 "Service Workers and Shop and Market Sales Workers" 510 "Personal and protective services workers" 511 "Travel attendants and related workers" 512 "Housekeeping and restaurant services workers" 513 "Personal care and related workers" 514 "Other personal service workers" 515 "Astrologers, fortune-tellers and related workers" 516 "Protective services workers" 520 "Models, salespersons and demonstrators" 521 "Fashion and other models" 522 "Shop salespersons and demonstrators" 523 "Stall and market salespersons" 610 "Market-oriented skilled agricultural and fishery workers" 611 "Market gardeners and crop growers" 612 "Market-oriented animal producers and related workers" 613 "Market-oriented crop and animal producers" 614 "Forestry and related workers" 615 "Fishery workers, hunters and trappers" 620 "Subsistence agricultural and fishery workers" 621 "Subsistence agricultural and fishery workers" 700 "Craft and related workers" 710 "Extraction and building trade workers" 711 "Miners, shot-firers, stonecutters and carvers" 712 "Building frame and related trades workers" 713 "Building finishers and related trades workers" 714 "Painters, building structure cleaners and related trade workers" 720 "Metal, machinery and related trades workers" 721 "Metal moulders, welders, sheet-metalworkers, structural-metal preparers and related trades workers" 722 "Blacksmiths, toolmakers and related trades workers" 723 "Machinery mechanics and fitters" 724 "Electrical and electronic equipment mechanics and fitters" 730 "Precision, handicraft, printing and related trades workers" 731 "Precision workers in metal and related materials" 732 "Potters, glass-makers and related trades workers" 733 "Handicraft workers in wood, textile, leather and related materials" 734 "Printing and related trades workers" 740 "Other craft and related trades workers" 741 "Food processing and related trades workers" 742 "Wood treaters, cabinet-makers and related trades workers" 743 "Textile, garment and related trades workers" 744 "Felt, leather and shoemaking trades workers" 800 "Plant and Machine Operators and Assemblers" 810 "Stationary plant and related operators" 811 "Mining and mineral-processing plant operators" 812 "Metal-processing plant operators" 813 "Glass, ceramics and related plant operators" 814 "Wood processing and papermaking plant operators" 815 "Chemical processing plant operators" 816 "Power production and related plant operators" 817 "Automated assembly-line and industrial robot operators" 820 "Machine operators and assemblers" 821 "Metal and mineral products machine operators" 822 "Chemical products machine operators" 823 "Rubber and plastic products machine operators" 824 "Wood products machine operators" 825 "Printing, binding and paper products machine operators" 826 "Textile, fur and leather products machine operators" 827 "Food and related products machine operators" 828 "Assemblers" 829 "Other machine operators and assemblers" 830 "Drivers and mobile plant operators" 831 "Locomotive engine-drivers and related workers" 832 "Motor vehicle drivers" 833 "Agricultural and other mobile plant operators" 834 "Ships' deck crews and related workers" 900 "Elementary Occupations" 910 "Sales and services elementary Occupations" 911 "Street vendors and related workers" 912 "Shoe cleaning and other street services' elementary Occupations" 913 "Domestic and related helpers, cleaners and launderers" 914 "Building caretakers, window and related cleaners" 915 "Messengers, porters, doorkeepers and related workers" 916 "Garbage collectors and related labourers" 920 "Agricultural, fishery and related labourers" 921 "Agricultural, fishery and related labourers" 930 "Labourers in mining, construction, manufacturing and transport" 931 "Mining and construction labourers" 932 "Manufacturing labourers" 933 "Transport labourers and freight handlers" 010 "Armed forces (Officers)" 011 "Armed forces (other Ranks)" 66666 "Not applicable" 77777 "Refusal" 88888 "don't know; not definable" 99999 " No answer". ****************************************************************. * Stage 2 - creation of 'euroesec' * (international comparative version of ESeC * based on ISCO minor groups "isco8803") * Missing ISCO data (66666 to 99999) copied across, * in preparation for household class ****************************************************************. ****************************************************************. * blocks of syntax for each employment status variable * Each ends with frequency check for errors ****************************************************************. ****************************************************************. * self-employed 10+ employees. Defaults to 1 unless otherwise in matrix ****************************************************************. do if (@empstat=1). recode isco8803 (344, 345 = 2) (011, 516 = 3) (621 = 5) (66666 = 66666) (77777 = 77777) (88888 = 88888) (99999 = 99999) (else=1) into euroesec. end if. execute. fre var=euroesec. ****************************************************************. * Small employers <10. Defaults to 4 unless otherwise in matrix** ****************************************************************. do if (@empstat=2). recode isco8803 (010, 100, 110, 111, 112, 114, 200, 210, 211, 212, 213, 214, 220, 221, 222, 231, 235, 240, 241, 242 = 1) (223, 230, 232, 233, 234, 243, 244, 245, 246, 247, 310, 311, 312, 314, 320, 321, 322, 323, 334, 342, 344, 345, 348 = 2) (011, 516 = 3) (600, 610, 611, 612, 613, 614, 615, 621, 920, 921 = 5) (66666 = 66666) (77777 = 77777) (88888 = 88888) (99999 = 99999) (else=4) into euroesec. end if. execute. fre var=euroesec. ****************************************************************. * Self-employed with one or no employees. * Defaults to 4 unless otherwise in matrix ****************************************************************. do if (@empstat=3). recode isco8803 (010, 100, 110, 111, 112, 114, 200, 210, 211, 212, 213, 214, 220, 221, 222, 231, 235, 240, 241, 242 = 1) (223, 230, 232, 233, 234, 243, 244, 245, 246, 247, 310, 311, 312, 314, 320, 321, 322, 323, 334, 342, 344, 345, 348 = 2) (011,516 = 3) (600, 610, 611, 612, 613, 614, 615, 621, 920, 921 = 5) (66666 = 66666) (77777 = 77777) (88888 = 88888) (99999 = 99999) (else=4) into euroesec. end if. execute. fre var=euroesec. ****************************************************************. * 'Supervisors' ****************************************************************. do if (@empstat=4). recode isco8803 (010, 100, 110, 111, 112, 114, 120, 121, 123, 200, 210, 211, 212, 213, 214, 220, 221, 222, 231, 235, 240, 241, 242 = 1) (011, 122, 130, 131, 223, 230, 232, 233, 234, 243, 244, 245, 246, 247, 250, 300, 310, 311, 312, 313, 314, 315, 320, 321, 322, 323, 330, 331, 332, 333, 334, 340, 341, 342, 343, 344, 345, 346, 347, 348, 400, 410, 411, 412, 419, 420, 430, 440, 450, 521, 790 = 2) (621=5) (66666 = 66666) (77777 = 77777) (88888 = 88888) (99999 = 99999) (else = 6) into euroesec. end if. execute. fre var=euroesec. ****************************************************************. *Employees ****************************************************************. do if (@empstat=5). recode isco8803 (010, 100, 110, 111, 112, 114, 120, 121, 123, 200, 210, 211, 212, 213, 214, 220, 221, 222, 231, 235, 240, 241, 242=1) (122, 130, 131, 223, 230, 232, 233, 234, 243, 244, 245, 246, 247, 310, 311, 312, 314, 320, 321, 322, 323, 334, 342, 344, 345, 348, 521=2) (011, 250, 300, 330, 331, 332, 333, 340, 341, 343, 346, 347, 400, 410, 411, 412, 419, 420, 430, 440, 450, 790=3) (621=5) (313, 315, 730,731=6) (413, 421, 422, 500, 510, 511, 513, 514, 516, 520, 522, 523, 911=7) (600, 610, 611, 612, 613, 614, 615, 700, 710, 711, 712, 713, 714, 720, 721, 722, 723, 724, 732, 733, 734, 740, 741, 742, 743, 744, 751, 752, 825, 831, 834=8) (414, 512, 800, 810, 811, 812, 813, 814, 815, 816, 817, 820, 821, 822, 823, 824, 826, 827, 828, 829, 830, 832, 833, 900, 910, 912, 913, 914, 915, 916, 920, 921, 930, 931, 932, 933=9) (66666 = 66666) (77777 = 77777) (88888 = 88888) (99999 = 99999) into euroesec. end if. execute. fre var=euroesec. ****************************************************************. * Final block to sweep up missing employment statuses * Allocations here on the basis * of modal ESS employment status (so-called 'simplified class') ****************************************************************. do if (sysmis(@empstat)). recode isco8803 (010, 100, 110, 111, 112, 114, 120, 121, 123, 200, 210, 211, 212, 213, 214, 220, 221, 222, 231, 235, 240, 241, 242=1) (122, 223, 230, 232, 233, 234, 243, 244, 245, 246, 247, 310, 311, 312, 314, 320, 321, 322, 323, 334, 342, 344, 345, 348, 521=2) (011, 250, 300, 330, 331, 332, 333, 340, 341, 343, 346, 347, 400, 410, 411, 412, 419, 420, 430, 440, 440, 450, 790=3) (130, 131, 911=4) (600, 610, 611, 612, 613, 621=5) (313, 315, 730,731=6) (413, 421, 422, 500, 510, 511, 513, 514, 516, 520, 522, 523=7) (614, 615, 700, 710, 711, 712, 713, 714, 720, 721, 722, 723, 724, 732, 733, 734, 740, 741, 742, 743, 744, 751, 752, 825, 831, 834=8) (414, 512, 800, 810, 811, 811, 812, 813, 814, 815, 816, 817, 820, 821, 822, 823, 824, 826, 827, 828, 829, 830, 832, 833, 900, 910, 912, 913, 914, 915, 916, 920, 921, 930, 931, 932, 933=9) (66666 = 66666) (77777 = 77777) (88888 = 88888) (99999 = 99999) into euroesec. end if. execute. fre var=euroesec. ****************************************************************. recode euroesec (sysmis = 0). var labs euroesec 'European ESeC'. val labs euroesec 1 'Large employers, higher mgrs/professionals' 2 'Lower mgrs/profess., higher supervisory/technicians' 3 'Intermediate occupations' 4 'Small employers and self-employed (non-agriculture)' 5 'Small employers and self-employed (agriculture)' 6 'Lower supervisors and technicians' 7 'Lower sales and service ' 8 'Lower technical' 9 'Routine' 66666 "not applicable" 77777 "refusal" 88888 "Don't know" 99999 "No answer". fre var= euroesec. missing value euroesec (66666 thru 99999). freq euroesec. filter off. ****************************************************************. * Sytax ends ****************************************************************. missing value isco8803 euroesec (). cross v515 by euroesec. cross v515 by v606.