***************************************************************************** * ESEC: * European Socioeconomic Classification kumulierter ALLBUS 1980-2006 * * Programm: esec_allbus_8006.do (ESeC_ALLBUS_8006_hw_v2.do) * Version: 09/05/2008 * * Heike Wirth, Andreas Fischer * GESIS-ZUMA * German Microdata Lab (GML) * www.gesis.org/Dauerbeobachtung/GML * heike.wirth@gesis.org * * Ausgangssyntax:http://www.iser.essex.ac.uk/esec/guide/docs/Appendix6.sps * Die Ausgangssyntax bezieht sich auf den European Social Survey * 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 fuer den kumulierten ALLBUS 1980-2006. * GESIS-ZUMA, Mannheim. * * H I N W E I S E: * * ESeC kann mit den kumulierten ALLBUS Daten 1980-2006 * 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 (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 (STATA-Routine, V4/4/2008). GESIS-ZUMA, Mannheim **************************************************************************** clear capture log close set more off set mem 1000m version 9.2 cd E:\ // Wechsel in das eigene Verzeichnis use allb80_2006.dta log using esec_allbus80_2006.log, replace /* jbspv: Supervisory Function v518: Occupation (ISCO 4digit) isco8803: 3-digit isco (generated below) emplrel: Employment Relation (2 + 3 = SE) emplno: Number of Employees respondent has */ * Constructing version 4 of ESEC Classes from 3 digit ISCO***** * All variable names and values refer to cumulated ALLBUS dataset (1980-2006) keep if (v2>=1992) ********************************************************************************* * 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 ********************************************************************************* generate empstat=. replace empstat=1 if (v516==17 | v516==23 | v516==24) | /// (v515==1 & (v606 >= 3 & v606 <= 9)) replace empstat=2 if (v516==16 | v516==22) | /// (v515==1 & (v606 <= 2 | v606 > 9)) replace empstat=3 if (v516==15 | v516==21) replace empstat=4 if (v515==4 & v538== 1) | (v515==5 & v538==1) | /// (v515==6 & v538== 1) | (v515==8 & v538==1) | /// (v515==9 & v538== 1) replace empstat=5 if (v515==4 & v538>= 2) | (v515==5 & v538>=2) | /// (v515==6 & v538> =2) | (v515==8 & v538>=2) | /// (v515==9 & v538>=2) #delimit ; label define empstatlbl 1 "Self-employed: 10+ employees" 2 "Self-employed: <10 employees" 3 "Self-employed: one or no employees" 4 "Supervisors" 5 "Employees"; #delimit cr label value empstat empstatlbl label variable empstat "ESeC employment status variable" tab 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 ********************************************************************************* generate isco_com = v518 tab isco_com 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/9333 = 9330) generate isco8803 = isco_com replace isco8803=int(isco_com/10) if (v518 > 1000 & v518 < 10000) recode isco8803 (2 = 010) (1 110 = 011) /// (. = 66666) (10007 = 77777) /// (10004 10008 = 88888) (10009 = 99999) tab isco8803, m codebook isco8803 v518 #delimit ; label define isco8803lbl 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"; #delimit cr label value isco8803 isco8803lbl tab isco8803, m ********************************************************************************* * Stage 2 - creation of 'euroesec' * (international comparative version of ESeC * based on ISCO minor groups "isco8803") * Missing ISCO data 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 ********************************************************************************* generate euroesec = . replace euroesec = 2 if (isco8803==344 | isco8803==345) & empstat == 1 replace euroesec = 3 if (isco8803==011 | isco8803==516) & empstat == 1 replace euroesec = 5 if (isco8803==621) & empstat == 1 replace euroesec = 1 if (euroesec != 2 & euroesec != 3 &euroesec != 5) & empstat ==1 replace euroesec = 66666 if isco8803==66666 & empstat ==1 replace euroesec = 77777 if isco8803==77777 & empstat ==1 replace euroesec = 88888 if isco8803==88888 & empstat ==1 replace euroesec = 99999 if isco8803==99999 & empstat ==1 tab euroesec, m ********************************************************************************* * Small employers <10. * Defaults to 4 unless otherwise in matrix ********************************************************************************* replace euroesec = 1 if (isco8803==010 | isco8803==100 | isco8803==110 | /// isco8803==111 | isco8803==112 | isco8803==114 | /// isco8803==200 | /// isco8803==210 | isco8803==211 | isco8803==212 | /// isco8803==213 | isco8803==214 | isco8803==220 | /// isco8803==221 | isco8803==222 | isco8803==231 | /// isco8803==235 | isco8803==240 | isco8803==241 | /// isco8803==242) & empstat == 2 replace euroesec = 2 if (isco8803==223 | isco8803==230 | isco8803==232 | /// isco8803==233 | isco8803==234 | isco8803==243 | /// isco8803==244 | isco8803==245 | isco8803==246 | /// isco8803==247 | isco8803==310 | isco8803==311 | /// isco8803==312 | isco8803==314 | isco8803==320 | /// isco8803==321 | isco8803==322 | isco8803==323 | /// isco8803==334 | isco8803==342 | isco8803==344 | /// isco8803==345 | isco8803==348) & empstat == 2 replace euroesec = 3 if (isco8803==011 | isco8803==516) & empstat == 2 replace euroesec = 5 if (isco8803==600 | isco8803==610 | isco8803==611 | /// isco8803==612 | isco8803==613 | isco8803==614 | /// isco8803==615 | isco8803==621 | isco8803==920 | /// isco8803==921) & empstat == 2 replace euroesec = 4 if (euroesec != 1 & euroesec != 2 & euroesec != 3 & /// euroesec != 5) & empstat == 2 replace euroesec = 66666 if isco8803==66666 & empstat ==2 replace euroesec = 77777 if isco8803==77777 & empstat ==2 replace euroesec = 88888 if isco8803==88888 & empstat ==2 replace euroesec = 99999 if isco8803==99999 & empstat ==2 tab euroesec, m ********************************************************************************* * Self-employed with one or no employees. * Defaults to 4 unless otherwise in matrix** ********************************************************************************* replace euroesec = 1 if (isco8803==010 | isco8803==100 | isco8803==110 | /// isco8803==111 | isco8803==112 | isco8803==114 | /// isco8803==200 | /// isco8803==210 | isco8803==211 | isco8803==212 | /// isco8803==213 | isco8803==214 | isco8803==220 | /// isco8803==221 | isco8803==222 | isco8803==231 | /// isco8803==235 | isco8803==240 | isco8803==241 | /// isco8803==242) & empstat == 3 replace euroesec = 2 if (isco8803==223 | isco8803==230 | isco8803==232 | /// isco8803==233 | isco8803==234 | isco8803==243 | /// isco8803==244 | isco8803==245 | isco8803==246 | /// isco8803==247 | isco8803==310 | isco8803==311 | /// isco8803==312 | isco8803==314 | isco8803==320 | /// isco8803==321 | isco8803==322 | isco8803==323 | /// isco8803==334 | isco8803==342 | isco8803==344 | /// isco8803==345 | isco8803==348) & empstat == 3 replace euroesec = 3 if (isco8803==011 | isco8803==516) & empstat == 3 replace euroesec = 5 if (isco8803==600 | isco8803==610 | isco8803==611 | /// isco8803==612 | isco8803==613 | isco8803==614 | /// isco8803==615 | isco8803==621 | isco8803==920 | /// isco8803==921) & empstat == 3 replace euroesec = 4 if (euroesec != 1 & euroesec != 2 & euroesec != 3 & /// euroesec != 5) & empstat == 3 replace euroesec = 66666 if isco8803==66666 & empstat ==3 replace euroesec = 77777 if isco8803==77777 & empstat ==3 replace euroesec = 88888 if isco8803==88888 & empstat ==3 replace euroesec = 99999 if isco8803==99999 & empstat ==3 tab euroesec, m ***'Supervisors'*** replace euroesec = 1 if (isco8803==010 | isco8803==100 | isco8803==110 | /// isco8803==111 | isco8803==112 | isco8803==114 | /// isco8803==120 | /// isco8803==121 | isco8803==123 | isco8803==200 | /// isco8803==210 | isco8803==211 | isco8803==212 | /// isco8803==213 | isco8803==214 | isco8803==220 | /// isco8803==221 | isco8803==222 | isco8803==231 | /// isco8803==235 | isco8803==240 | isco8803==241 | /// isco8803==242) & empstat == 4 replace euroesec = 2 if (isco8803==011 | isco8803==122 | isco8803==130 | /// isco8803==131 | isco8803==223 | isco8803==230 | /// isco8803==232 | isco8803==233 | isco8803==234 | /// isco8803==243 | isco8803==244 | isco8803==245 | /// isco8803==246 | isco8803==247 | isco8803==250 | /// isco8803==300 | isco8803==310 | isco8803==311 | /// isco8803==312 | isco8803==313 | isco8803==314 | /// isco8803==315 | isco8803==320 | isco8803==321 | /// isco8803==322 | isco8803==323 | isco8803==330 | /// isco8803==331 | isco8803==332 | isco8803==333 | /// isco8803==334 | isco8803==340 | isco8803==341 | /// isco8803==342 | isco8803==343 | isco8803==344 | /// isco8803==345 | isco8803==346 | isco8803==347 | /// isco8803==348 | isco8803==400 | isco8803==410 | /// isco8803==411 | isco8803==412 | isco8803==419 | /// isco8803==420 | isco8803==430 | isco8803==440 | /// isco8803==450 | isco8803==521 | isco8803==790) & empstat == 4 replace euroesec = 5 if isco8803==621 & empstat == 4 replace euroesec = 6 if (euroesec != 1 & euroesec != 2 &euroesec != 5) & empstat == 4 replace euroesec = 66666 if isco8803==66666 & empstat ==4 replace euroesec = 77777 if isco8803==77777 & empstat ==4 replace euroesec = 88888 if isco8803==88888 & empstat ==4 replace euroesec = 99999 if isco8803==99999 & empstat ==4 tab euroesec, m **Employees** replace euroesec = 1 if (isco8803==010 | isco8803==100 | isco8803==110 | /// isco8803==111 | isco8803==112 | isco8803==114 | /// isco8803==120 | /// isco8803==121 | isco8803==123 | isco8803==200 | /// isco8803==210 | isco8803==211 | isco8803==212 | /// isco8803==213 | isco8803==214 | isco8803==220 | /// isco8803==221 | isco8803==222 | isco8803==231 | /// isco8803==235 | isco8803==240 | isco8803==241 | /// isco8803==242) & empstat == 5 replace euroesec = 2 if (isco8803==122 | isco8803==130 | isco8803==131 | /// isco8803==223 | isco8803==230 | isco8803==232 | /// isco8803==233 | isco8803==234 | isco8803==243 | /// isco8803==244 | isco8803==245 | isco8803==246 | /// isco8803==247 | isco8803==310 | isco8803==311 | /// isco8803==312 | isco8803==314 | isco8803==320 | /// isco8803==321 | isco8803==322 | isco8803==323 | /// isco8803==334 | isco8803==342 | isco8803==344 | /// isco8803==345 | isco8803==348 | isco8803==521) & empstat == 5 replace euroesec = 3 if (isco8803==011 | isco8803==250 | isco8803==300 | /// isco8803==330 | isco8803==331 | isco8803==332 | /// isco8803==333 | isco8803==340 | isco8803==341 | /// isco8803==343 | isco8803==346 | isco8803==347 | /// isco8803==400 | isco8803==410 | isco8803==411 | /// isco8803==412 | isco8803==419 | isco8803==420 | /// isco8803==430 | isco8803==440 | isco8803==450 | /// isco8803==790) & empstat == 5 replace euroesec = 5 if (isco8803==621 & empstat == 5) replace euroesec = 6 if (isco8803==313 | isco8803==315 | isco8803==730 | /// isco8803==731) & empstat == 5 replace euroesec = 7 if (isco8803==413 | isco8803==421 | isco8803==422 | /// isco8803==500 | isco8803==510 | isco8803==511 | /// isco8803==513 | isco8803==514 | isco8803==516 | /// isco8803==520 | isco8803==522 | isco8803==523 | /// isco8803==911) & empstat == 5 replace euroesec = 8 if (isco8803==600 | isco8803==610 | isco8803==611 | /// isco8803==612 | isco8803==613 | isco8803==614 | /// isco8803==615 | isco8803==700 | isco8803==710 | /// isco8803==711 | isco8803==712 | isco8803==713 | /// isco8803==714 | isco8803==720 | isco8803==721 | /// isco8803==722 | isco8803==723 | isco8803==724 | /// isco8803==732 | isco8803==733 | isco8803==734 | /// isco8803==740 | isco8803==741 | isco8803==742 | /// isco8803==743 | isco8803==744 | isco8803==751 | /// isco8803==752 | isco8803==825 | isco8803==831 | /// isco8803==834) & empstat == 5 replace euroesec = 9 if (isco8803==414 | isco8803==512 | isco8803==800 | /// isco8803==810 | isco8803==811 | isco8803==812 | /// isco8803==813 | isco8803==814 | isco8803==815 | /// isco8803==816 | isco8803==817 | isco8803==820 | /// isco8803==821 | isco8803==822 | isco8803==823 | /// isco8803==824 | isco8803==826 | isco8803==827 | /// isco8803==828 | isco8803==829 | isco8803==830 | /// isco8803==832 | isco8803==833 | isco8803==900 | /// isco8803==910 | isco8803==912 | isco8803==913 | /// isco8803==914 | isco8803==915 | isco8803==916 | /// isco8803==920 | isco8803==921 | isco8803==930 | /// isco8803==931 | isco8803==932 | isco8803==933) & empstat == 5 replace euroesec = 66666 if isco8803==66666 & empstat ==5 replace euroesec = 77777 if isco8803==77777 & empstat ==5 replace euroesec = 88888 if isco8803==88888 & empstat ==5 replace euroesec = 99999 if isco8803==99999 & empstat ==5 tab euroesec,m **Final block to sweep up missing employment statuses. ** **Allocations here on the basis of modal ESS employment status (so-called 'simplified class')** replace euroesec = 1 if (isco8803==010 | isco8803==100 | isco8803==110 | /// isco8803==111 | isco8803==112 | isco8803==114 | /// isco8803==120 | /// isco8803==121 | isco8803==123 | isco8803==200 | /// isco8803==210 | isco8803==211 | isco8803==212 | /// isco8803==213 | isco8803==214 | isco8803==220 | /// isco8803==221 | isco8803==222 | isco8803==231 | /// isco8803==235 | isco8803==240 | isco8803==241 | /// isco8803==242) & empstat == . replace euroesec = 2 if (isco8803==122 | isco8803==223 | isco8803==230 | /// isco8803==232 | isco8803==233 | isco8803==234 | /// isco8803==243 | isco8803==244 | isco8803==245 | /// isco8803==246 | isco8803==247 | isco8803==310 | /// isco8803==311 | isco8803==312 | isco8803==314 | /// isco8803==320 | isco8803==321 | isco8803==322 | /// isco8803==323 | isco8803==334 | isco8803==342 | /// isco8803==344 | isco8803==345 | isco8803==348 | /// isco8803==521) & empstat == . replace euroesec = 3 if (isco8803==011 | isco8803==250 | isco8803==300 | /// isco8803==330 | isco8803==331 | isco8803==332 | /// isco8803==333 | isco8803==340 | isco8803==341 | /// isco8803==343 | isco8803==346 | isco8803==347 | /// isco8803==400 | isco8803==410 | isco8803==411 | /// isco8803==412 | isco8803==419 | isco8803==420 | /// isco8803==430 | isco8803==440 | isco8803==440 | /// isco8803==450 | isco8803==790) & empstat == . replace euroesec = 4 if (isco8803==130 | isco8803==131 | isco8803==911) & empstat == . replace euroesec = 5 if (isco8803==600 | isco8803==610 | isco8803==611 | /// isco8803==612 | isco8803==613 | isco8803==621) & empstat == . replace euroesec = 6 if (isco8803==313 | isco8803==315 | isco8803==730 | /// isco8803==731) & empstat == . replace euroesec = 7 if (isco8803==413 | isco8803==421 | isco8803==422 | /// isco8803==500 | isco8803==510 | isco8803==511 | /// isco8803==513 | isco8803==514 | isco8803==516 | /// isco8803==520 | isco8803==522 | isco8803==523) & empstat == . replace euroesec = 8 if (isco8803==614 | isco8803==615 | isco8803==700 | /// isco8803==710 | isco8803==711 | isco8803==712 | /// isco8803==713 | isco8803==714 | isco8803==720 | /// isco8803==721 | isco8803==722 | isco8803==723 | /// isco8803==724 | isco8803==732 | isco8803==733 | /// isco8803==734 | isco8803==740 | isco8803==741 | /// isco8803==742 | isco8803==743 | isco8803==744 | /// isco8803==751 | isco8803==752 | isco8803==825 | /// isco8803==831 | isco8803==834) & empstat == . replace euroesec = 9 if (isco8803==414 | isco8803==512 | isco8803==800 | /// isco8803==810 | isco8803==811 | isco8803==811 | /// isco8803==812 | isco8803==813 | isco8803==814 | /// isco8803==815 | isco8803==816 | isco8803==817 | /// isco8803==820 | isco8803==821 | isco8803==822 | /// isco8803==823 | isco8803==824 | isco8803==826 | /// isco8803==827 | isco8803==828 | isco8803==829 | /// isco8803==830 | isco8803==832 | isco8803==833 | /// isco8803==900 | isco8803==910 | isco8803==912 | /// isco8803==913 | isco8803==914 | isco8803==915 | /// isco8803==916 | isco8803==920 | isco8803==921 | /// isco8803==930 | isco8803==931 | isco8803==932 | /// isco8803==933) & empstat == . replace euroesec = 66666 if isco8803==66666 & empstat ==. replace euroesec = 77777 if isco8803==77777 & empstat ==. replace euroesec = 88888 if isco8803==88888 & empstat ==. replace euroesec = 99999 if isco8803==99999 & empstat ==. tab euroesec,m #delimit ; label define euroeseclbl 1 "Large employers, higher mgrs/professionals" 2 "Lower mgrs/professionals, 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 "DK" /// 99999 "No answer"; #delimit cr label value euroesec euroeseclbl label var euroesec "European ESeC" tab euroesec log close *****Syntax ends*****