* Script generated by Andreas Perret, FORS/COMPASS, for the project Data without Boundaries /WP5 -------------------- /* Imports EUROSTAT Structure of earnings survey (SES) wave 2002, anonymized files. /* Also performs basic correction and harmonization as well as definig missing values. /* DISCLAIMER: /* This script is provided without any guarantee, it is your responsability to check for the quality of the output. * Attention, this script requires a root folder name (here WP5) where national folders are stored. * Please adapt the path to your configuration. /* CHANGELOG: /* Variable KEY_E is now A8 /* NACE value labels are now consistant with Rev 1.1 FILE HANDLE WP5 NAME ="H:\_DwB-Eurostat\SES\". /* Import raw files ------------------------------------------------------------------------------------------------------------------------------------------------ /* Many coutry-files need custom handling, basic information is provided at the beginning (and end) /* of each national file SET DIGITGROUPING=No Small=0.0001 Unicode=Yes OLang=English. /* LOAD BE (BELGIUM) /* variable A16, value "." corrected to "99999999" (missing) /* variable A17, value "UNK" corrected to "OPT" /* variable A19, value "UNK" corrected to "OPT" /* variable B23, value "99" corrected to "999" /* variable B24, value "UNK" corrected to "OPT" /* variable B10, value "UNK" corrected to "OPT" /* variable B271 has values over 100% GET DATA /TYPE=TXT /FILE="WP5\BE\SES_BE_2002_ANONYM_CD.csv" /DELCASE=LINE /DELIMITERS=";" /ARRANGEMENT=DELIMITED /FIRSTCASE=3 /IMPORTCASE=ALL /VARIABLES= country A2 YEAR F8.0 nace A1 KEY_E A8 KEY_L A6 A11 A3 A12 F1.0 A12_CLASS A8 A13 A8 A14 A1 A15 A1 A16 A8 A17 A3 A18 A3 A19 A3 B21 A1 B210 A3 B211 F8.0 B22_CLASS A8 B23 A3 B24 A3 B25 A2 B26 A8 B27 A2 B271 F6.2 B28 A1 B30 F6.2 B31 F9.2 B311 F6.2 B312 F9.2 B32 F14.2 B321 F6.2 B322 F14.2 B3221 F4.0 B3222 F4.0 B3223 F4.0 B33 F8.0 B331 F8.0 B332 F8.0 B34 F6.2 B341 F6.2 B35 F8.0 B351 F6.2 B3511 A1 B352 F8.0 B3521 F8.0 B3522 F8.0 B353 F8.0 B36 F8.0 B42 F6.2. DATASET NAME DataSet1. IF (A17="UNK") A17="OPT". EXECUTE. IF (A16=".") A16="999999999". EXECUTE. IF (A19="UNK") A19="OPT". EXECUTE. IF (B23="99") B23="999". EXECUTE. IF (B24="UNK") B24="OPT". EXECUTE. IF (B210="UNK") B210="OPT". EXECUTE. ALTER TYPE A16 (A8) A16 (F8.0). EXECUTE. /* LOAD BG (BULGARIA) /* variable A12 does not seem to be consistent with variable A12_CLASS GET DATA /TYPE=TXT /FILE="WP5\BG\SES_BG_2002_ANONYM_CD.csv" /DELCASE=LINE /DELIMITERS=";" /ARRANGEMENT=DELIMITED /FIRSTCASE=3 /IMPORTCASE=ALL /VARIABLES= country A2 YEAR F8.0 nace A1 KEY_E A8 KEY_L A6 A11 A3 A12 F1.0 A12_CLASS A8 A13 A8 A14 A1 A15 A1 A16 F8.0 A17 A3 A18 A3 A19 A3 B21 A1 B210 A3 B211 F8.0 B22_CLASS A8 B23 A3 B24 A3 B25 A2 B26 A8 B27 A2 B271 F3.2 B28 A1 B30 F6.2 B31 F9.2 B311 F6.2 B312 F9.2 B32 F12.9 B321 F6.2 B322 F14.2 B3221 F4.0 B3222 F4.0 B3223 F4.0 B33 F8.0 B331 F8.0 B332 F8.0 B34 F6.2 B341 F6.2 B35 F8.0 B351 F6.2 B3511 A1 B352 F8.0 B3521 F8.0 B3522 F8.0 B353 F8.0 B36 F8.0 B42 F6.2. DATASET NAME DataSet2. DATASET ACTIVATE DataSet1. ADD FILES /FILE=* /FILE='DataSet2'. DATASET CLOSE DATASET2. /* LOAD CY (CYPRUS) GET DATA /TYPE=TXT /FILE="WP5\CY\SES_CY_2002_ANONYM_CD.csv" /DELCASE=LINE /DELIMITERS=";" /ARRANGEMENT=DELIMITED /FIRSTCASE=3 /IMPORTCASE=ALL /VARIABLES= country A2 YEAR F8.0 nace A1 KEY_E A8 KEY_L A6 A11 A3 A12 F1.0 A12_CLASS A8 A13 A8 A14 A1 A15 A1 A16 F8.0 A17 A3 A18 A3 A19 A3 B21 A1 B210 A3 B211 F8.0 B22_CLASS A8 B23 A3 B24 A3 B25 A2 B26 A8 B27 A2 B271 F3.2 B28 A1 B30 F6.2 B31 F9.2 B311 F6.2 B312 F9.2 B32 F12.9 B321 F6.2 B322 F14.2 B3221 F4.0 B3222 F4.0 B3223 F4.0 B33 F8.0 B331 F8.0 B332 F8.0 B34 F6.2 B341 F6.2 B35 F8.0 B351 F6.2 B3511 A1 B352 F8.0 B3521 F8.0 B3522 F8.0 B353 F8.0 B36 F8.0 B42 F6.2. DATASET NAME DataSet2. DATASET ACTIVATE DataSet1. ADD FILES /FILE=* /FILE='DataSet2'. DATASET CLOSE DATASET2. /* LOAD CZ (Czech Republic) GET DATA /TYPE=TXT /FILE="WP5\CZ\SES_CZ_2002_ANONYM_CD.csv" /DELCASE=LINE /DELIMITERS=";" /ARRANGEMENT=DELIMITED /FIRSTCASE=3 /IMPORTCASE=ALL /VARIABLES= country A2 YEAR F8.0 nace A1 KEY_E A8 KEY_L A6 A11 A3 A12 F1.0 A12_CLASS A8 A13 A8 A14 A1 A15 A1 A16 F8.0 A17 A3 A18 A3 A19 A3 B21 A1 B210 A3 B211 F8.0 B22_CLASS A8 B23 A3 B24 A3 B25 A2 B26 A8 B27 A2 B271 F3.2 B28 A1 B30 F6.2 B31 F9.2 B311 F6.2 B312 F9.2 B32 F12.9 B321 F6.2 B322 F14.2 B3221 F4.0 B3222 F4.0 B3223 F4.0 B33 F8.0 B331 F8.0 B332 F8.0 B34 F6.2 B341 F6.2 B35 F8.0 B351 F6.2 B3511 A1 B352 F8.0 B3521 F8.0 B3522 F8.0 B353 F8.0 B36 F8.0 B42 F6.2. DATASET NAME DataSet2. DATASET ACTIVATE DataSet1. ADD FILES /FILE=* /FILE='DataSet2'. DATASET CLOSE DATASET2. /*LOAD DE -unavailable for 2002 /* LOAD EE (Estonia) GET DATA /TYPE=TXT /FILE="WP5\EE\SES_EE_2002_ANONYM_CD.csv" /DELCASE=LINE /DELIMITERS=";" /ARRANGEMENT=DELIMITED /FIRSTCASE=3 /IMPORTCASE=ALL /VARIABLES= country A2 YEAR F8.0 nace A1 KEY_E A8 KEY_L A6 A11 A3 A12 F1.0 A12_CLASS A8 A13 A8 A14 A1 A15 A1 A16 F8.0 A17 A3 A18 A3 A19 A3 B21 A1 B210 A3 B211 F8.0 B22_CLASS A8 B23 A3 B24 A3 B25 A2 B26 A8 B27 A2 B271 F3.2 B28 A1 B30 F6.2 B31 F9.2 B311 F6.2 B312 F9.2 B32 F12.9 B321 F6.2 B322 F14.2 B3221 F4.0 B3222 F4.0 B3223 F4.0 B33 F8.0 B331 F8.0 B332 F8.0 B34 F6.2 B341 F6.2 B35 F8.0 B351 F6.2 B3511 A1 B352 F8.0 B3521 F8.0 B3522 F8.0 B353 F8.0 B36 F8.0 B42 F6.2. DATASET NAME DataSet2. DATASET ACTIVATE DataSet1. ADD FILES /FILE=* /FILE='DataSet2'. DATASET CLOSE DATASET2. /* LOAD EL (Greece) /* Attention: Initals in filename are not consistent with 2006 file /* Variable "country", value corrected from "GR" to "EL" GET DATA /TYPE=TXT /FILE="WP5\EL\SES_GR_2002_ANONYM_CD.csv" /DELCASE=LINE /DELIMITERS=";" /ARRANGEMENT=DELIMITED /FIRSTCASE=3 /IMPORTCASE=ALL /VARIABLES= country A2 YEAR F8.0 nace A1 KEY_E A8 KEY_L A6 A11 A3 A12 F1.0 A12_CLASS A8 A13 A8 A14 A1 A15 A1 A16 F8.0 A17 A3 A18 A3 A19 A3 B21 A1 B210 A3 B211 F8.0 B22_CLASS A8 B23 A3 B24 A3 B25 A2 B26 A8 B27 A2 B271 F3.2 B28 A1 B30 F6.2 B31 F9.2 B311 F6.2 B312 F9.2 B32 F12.9 B321 F6.2 B322 F14.2 B3221 F4.0 B3222 F4.0 B3223 F4.0 B33 F8.0 B331 F8.0 B332 F8.0 B34 F6.2 B341 F6.2 B35 F8.0 B351 F6.2 B3511 A1 B352 F8.0 B3521 F8.0 B3522 F8.0 B353 F8.0 B36 F8.0 B42 F6.2. IF (country="GR") country="EL". EXECUTE. DATASET NAME DataSet2. DATASET ACTIVATE DataSet1. ADD FILES /FILE=* /FILE='DataSet2'. DATASET CLOSE DATASET2. /* LOAD ES (Spain) GET DATA /TYPE=TXT /FILE="WP5\ES\SES_ES_2002_ANONYM_CD.csv" /DELCASE=LINE /DELIMITERS=";" /ARRANGEMENT=DELIMITED /FIRSTCASE=3 /IMPORTCASE=ALL /VARIABLES= country A2 YEAR F8.0 nace A1 KEY_E A8 KEY_L A6 A11 A3 A12 F1.0 A12_CLASS A8 A13 A8 A14 A1 A15 A1 A16 F8.0 A17 A3 A18 A3 A19 A3 B21 A1 B210 A3 B211 F8.0 B22_CLASS A8 B23 A3 B24 A3 B25 A2 B26 A8 B27 A2 B271 F3.2 B28 A1 B30 F6.2 B31 F9.2 B311 F6.2 B312 F9.2 B32 F12.9 B321 F6.2 B322 F14.2 B3221 F4.0 B3222 F4.0 B3223 F4.0 B33 F8.0 B331 F8.0 B332 F8.0 B34 F6.2 B341 F6.2 B35 F8.0 B351 F6.2 B3511 A1 B352 F8.0 B3521 F8.0 B3522 F8.0 B353 F8.0 B36 F8.0 B42 F6.2. DATASET NAME DataSet2. DATASET ACTIVATE DataSet1. ADD FILES /FILE=* /FILE='DataSet2'. DATASET CLOSE DATASET2. /* LOAD FI (Finland) /* variable A11 uses custom value (FIX) GET DATA /TYPE=TXT /FILE="WP5\FI\SES_FI_2002_ANONYM_CD.csv" /DELCASE=LINE /DELIMITERS=";" /ARRANGEMENT=DELIMITED /FIRSTCASE=3 /IMPORTCASE=ALL /VARIABLES= country A2 YEAR F8.0 nace A1 KEY_E A8 KEY_L A6 A11 A3 A12 F1.0 A12_CLASS A8 A13 A8 A14 A1 A15 A1 A16 F8.0 A17 A3 A18 A3 A19 A3 B21 A1 B210 A3 B211 F8.0 B22_CLASS A8 B23 A3 B24 A3 B25 A2 B26 A8 B27 A2 B271 F3.2 B28 A1 B30 F6.2 B31 F9.2 B311 F6.2 B312 F9.2 B32 F12.9 B321 F6.2 B322 F14.2 B3221 F4.0 B3222 F4.0 B3223 F4.0 B33 F8.0 B331 F8.0 B332 F8.0 B34 F6.2 B341 F6.2 B35 F8.0 B351 F6.2 B3511 A1 B352 F8.0 B3521 F8.0 B3522 F8.0 B353 F8.0 B36 F8.0 B42 F6.2. DATASET NAME DataSet2. DATASET ACTIVATE DataSet1. ADD FILES /FILE=* /FILE='DataSet2'. DATASET CLOSE DATASET2. /* LOAD FR (France) GET DATA /TYPE=TXT /FILE="WP5\FR\SES_FR_2002_ANONYM_CD.csv" /DELCASE=LINE /DELIMITERS=";" /ARRANGEMENT=DELIMITED /FIRSTCASE=3 /IMPORTCASE=ALL /VARIABLES= country A2 YEAR F8.0 nace A1 KEY_E A8 KEY_L A6 A11 A3 A12 F1.0 A12_CLASS A8 A13 A8 A14 A1 A15 A1 A16 F8.0 A17 A3 A18 A3 A19 A3 B21 A1 B210 A3 B211 F8.0 B22_CLASS A8 B23 A3 B24 A3 B25 A2 B26 A8 B27 A2 B271 F3.2 B28 A1 B30 F6.2 B31 F9.2 B311 F6.2 B312 F9.2 B32 F12.9 B321 F6.2 B322 F14.2 B3221 F4.0 B3222 F4.0 B3223 F4.0 B33 F8.0 B331 F8.0 B332 F8.0 B34 F6.2 B341 F6.2 B35 F8.0 B351 F6.2 B3511 A1 B352 F8.0 B3521 F8.0 B3522 F8.0 B353 F8.0 B36 F8.0 B42 F6.2. DATASET NAME DataSet2. DATASET ACTIVATE DataSet1. ADD FILES /FILE=* /FILE='DataSet2'. DATASET CLOSE DATASET2. /* LOAD HU (Hungaria) GET DATA /TYPE=TXT /FILE="WP5\HU\SES_HU_2002_ANONYM_CD.csv" /DELCASE=LINE /DELIMITERS=";" /ARRANGEMENT=DELIMITED /FIRSTCASE=3 /IMPORTCASE=ALL /VARIABLES= country A2 YEAR F8.0 nace A1 KEY_E A8 KEY_L A6 A11 A3 A12 F1.0 A12_CLASS A8 A13 A8 A14 A1 A15 A1 A16 F8.0 A17 A3 A18 A3 A19 A3 B21 A1 B210 A3 B211 F8.0 B22_CLASS A8 B23 A3 B24 A3 B25 A2 B26 A8 B27 A2 B271 F3.2 B28 A1 B30 F6.2 B31 F9.2 B311 F6.2 B312 F9.2 B32 F12.9 B321 F6.2 B322 F14.2 B3221 F4.0 B3222 F4.0 B3223 F4.0 B33 F8.0 B331 F8.0 B332 F8.0 B34 F6.2 B341 F6.2 B35 F8.0 B351 F6.2 B3511 A1 B352 F8.0 B3521 F8.0 B3522 F8.0 B353 F8.0 B36 F8.0 B42 F6.2. DATASET NAME DataSet2. DATASET ACTIVATE DataSet1. ADD FILES /FILE=* /FILE='DataSet2'. DATASET CLOSE DATASET2. /* LOAD IT (ITALIA) ATTENTION, FOLLOWS A DIFFERENT VARIABLE ORDER /* variables B23, B25 and B26 to left-trim /* variable A12 and A12_CLASS use additional custom values /* variable A13 contains a supplementary leading character the "R". Assuming it can can be ommited, variable corrected accordingly. /* variable "YEAR" corrected /* variable A18, replaced value "OPT" with "999" GET DATA /TYPE=TXT /FILE="WP5\IT\SES_IT_2002_ANONYM_CD.csv" /DELCASE=LINE /DELIMITERS=";" /ARRANGEMENT=DELIMITED /FIRSTCASE=2 /IMPORTCASE=ALL /VARIABLES= country A2 YEAR F8.0 nace A1 KEY_E F6.0 KEY_L A6 A11 A3 A12 F1.0 A13 A8 A14 A1 A15 A1 A16 F8.0 A17 A3 A18 A3 A19 A3 A41 F8.0 B21 A1 B210 A3 B211 F8.0 B23 A3 B24 A3 B25 A2 B26 A8 B27 A2 B271 F3.2 B28 A1 B321 F6.2 B3221 F4.0 B3222 F4.0 B3223 F4.0 B33 F8.0 B331 F8.0 B332 F8.0 B34 F6.2 B341 F6.2 B3511 A1 B352 F8.0 B3521 F8.0 B3522 F8.0 B353 F8.0 B36 F8.0 B42 F6.2 A12_CLASS A8 B22_CLASS A8 B30 F6.2 B31 F9.2 B311 F6.2 B312 F9.2 B32 F12.9 B322 F14.2 B35 F8.0 B351 F6.2. IF (A18="OPT") A18="999". EXECUTE. COMPUTE B26=LTRIM(B26). EXECUTE. COMPUTE B23=LTRIM(B23). EXECUTE. COMPUTE B25=LTRIM(B25). EXECUTE. COMPUTE B25=concat("0",B25). EXECUTE. COMPUTE A13=LTRIM(A13,"R"). EXECUTE. COMPUTE YEAR =2002. EXECUTE. DATASET NAME DataSet2. DATASET ACTIVATE DataSet1. ADD FILES /FILE=* /FILE='DataSet2'. DATASET CLOSE DATASET2. /* LOAD LT (Lithuania) GET DATA /TYPE=TXT /FILE="WP5\LT\SES_LT_2002_ANONYM_CD.csv" /DELCASE=LINE /DELIMITERS=";" /ARRANGEMENT=DELIMITED /FIRSTCASE=3 /IMPORTCASE=ALL /VARIABLES= country A2 YEAR F8.0 nace A1 KEY_E A8 KEY_L A6 A11 A3 A12 F1.0 A12_CLASS A8 A13 A8 A14 A1 A15 A1 A16 F8.0 A17 A3 A18 A3 A19 A3 B21 A1 B210 A3 B211 F8.0 B22_CLASS A8 B23 A3 B24 A3 B25 A2 B26 A8 B27 A2 B271 F3.2 B28 A1 B30 F6.2 B31 F9.2 B311 F6.2 B312 F9.2 B32 F12.9 B321 F6.2 B322 F14.2 B3221 F4.0 B3222 F4.0 B3223 F4.0 B33 F8.0 B331 F8.0 B332 F8.0 B34 F6.2 B341 F6.2 B35 F8.0 B351 F6.2 B3511 A1 B352 F8.0 B3521 F8.0 B3522 F8.0 B353 F8.0 B36 F8.0 B42 F6.2. DATASET NAME DataSet2. DATASET ACTIVATE DataSet1. ADD FILES /FILE=* /FILE='DataSet2'. DATASET CLOSE DATASET2. /* LOAD LU (Luxemourg) /* variable A19, replace value "" with "OPT" /* variable nace, replace value "." with "" /* variable A18, replace value "." with "999" EXECUTE. GET DATA /TYPE=TXT /FILE="WP5\LU\SES_LU_2002_ANONYM_CD.csv" /DELCASE=LINE /DELIMITERS=";" /ARRANGEMENT=DELIMITED /FIRSTCASE=3 /IMPORTCASE=ALL /VARIABLES= country A2 YEAR F8.0 nace A1 KEY_E A8 KEY_L A6 A11 A3 A12 F1.0 A12_CLASS A8 A13 A8 A14 A1 A15 A1 A16 F8.0 A17 A3 A18 A3 A19 A3 B21 A1 B210 A3 B211 F8.0 B22_CLASS A8 B23 A3 B24 A3 B25 A2 B26 A8 B27 A2 B271 F3.2 B28 A1 B30 F6.2 B31 F9.2 B311 F6.2 B312 F9.2 B32 F12.9 B321 F6.2 B322 F14.2 B3221 F4.0 B3222 F4.0 B3223 F4.0 B33 F8.0 B331 F8.0 B332 F8.0 B34 F6.2 B341 F6.2 B35 F8.0 B351 F6.2 B3511 A1 B352 F8.0 B3521 F8.0 B3522 F8.0 B353 F8.0 B36 F8.0 B42 F6.2. IF (nace=".") nace="". EXECUTE. IF (A19="") A19="OPT". EXECUTE. IF (A18=".") A18="999". EXECUTE. DATASET NAME DataSet2. DATASET ACTIVATE DataSet1. ADD FILES /FILE=* /FILE='DataSet2'. DATASET CLOSE DATASET2. /* LOAD LV (Latvia) GET DATA /TYPE=TXT /FILE="WP5\LV\SES_LV_2002_ANONYM_CD.csv" /DELCASE=LINE /DELIMITERS=";" /ARRANGEMENT=DELIMITED /FIRSTCASE=3 /IMPORTCASE=ALL /VARIABLES= country A2 YEAR F8.0 nace A1 KEY_E A8 KEY_L A6 A11 A3 A12 F1.0 A12_CLASS A8 A13 A8 A14 A1 A15 A1 A16 F8.0 A17 A3 A18 A3 A19 A3 B21 A1 B210 A3 B211 F8.0 B22_CLASS A8 B23 A3 B24 A3 B25 A2 B26 A8 B27 A2 B271 F3.2 B28 A1 B30 F6.2 B31 F9.2 B311 F6.2 B312 F9.2 B32 F12.9 B321 F6.2 B322 F14.2 B3221 F4.0 B3222 F4.0 B3223 F4.0 B33 F8.0 B331 F8.0 B332 F8.0 B34 F6.2 B341 F6.2 B35 F8.0 B351 F6.2 B3511 A1 B352 F8.0 B3521 F8.0 B3522 F8.0 B353 F8.0 B36 F8.0 B42 F6.2. DATASET NAME DataSet2. DATASET ACTIVATE DataSet1. ADD FILES /FILE=* /FILE='DataSet2'. DATASET CLOSE DATASET2. /* LOAD NL (Netherlands) ATTENTION, FILENAME NOT CONSISTENT WITH OTHER COUNTRIES /* variable A12_CLASS, value GT250 corrected to GT_250 /* variable A13 has a leading charachter "R", corrected /* variable A13 uses additional custom value "zzz" GET DATA /TYPE=TXT /FILE="WP5\NL\SES_NL_2002_ANONYM_CD_ORG.csv" /DELCASE=LINE /DELIMITERS=";" /ARRANGEMENT=DELIMITED /FIRSTCASE=3 /IMPORTCASE=ALL /VARIABLES= country A2 YEAR F8.0 nace A1 KEY_E A8 KEY_L A6 A11 A3 A12 F1.0 A12_CLASS A8 A13 A8 A14 A1 A15 A1 A16 F8.0 A17 A3 A18 A3 A19 A3 B21 A1 B210 A3 B211 F8.0 B22_CLASS A8 B23 A3 B24 A3 B25 A2 B26 A8 B27 A2 B271 F3.2 B28 A1 B30 F6.2 B31 F9.2 B311 F6.2 B312 F9.2 B32 F12.9 B321 F6.2 B322 F14.2 B3221 F4.0 B3222 F4.0 B3223 F4.0 B33 F8.0 B331 F8.0 B332 F8.0 B34 F6.2 B341 F6.2 B35 F8.0 B351 F6.2 B3511 A1 B352 F8.0 B3521 F8.0 B3522 F8.0 B353 F8.0 B36 F8.0 B42 F6.2. IF (A12_CLASS="GT250") A12_CLASS="GT_250". EXECUTE. COMPUTE A13=LTRIM(A13,"R"). EXECUTE. DATASET NAME DataSet2. DATASET ACTIVATE DataSet1. ADD FILES /FILE=* /FILE='DataSet2'. DATASET CLOSE DATASET2. /* LOAD NO (Norway) /* variable A15, only 1 value ("O") corrected to "". /* variable B23 has undocumented value "99"; assuming "999" and corrected accordingly GET DATA /TYPE=TXT /FILE="WP5\NO\SES_NO_2002_ANONYM_CD.csv" /DELCASE=LINE /DELIMITERS=";" /ARRANGEMENT=DELIMITED /FIRSTCASE=3 /IMPORTCASE=ALL /VARIABLES= country A2 YEAR F8.0 nace A1 KEY_E A8 KEY_L A6 A11 A3 A12 F1.0 A12_CLASS A8 A13 A8 A14 A1 A15 A1 A16 F8.0 A17 A3 A18 A3 A19 A3 B21 A1 B210 A3 B211 F8.0 B22_CLASS A8 B23 A3 B24 A3 B25 A2 B26 A8 B27 A2 B271 F3.2 B28 A1 B30 F6.2 B31 F9.2 B311 F6.2 B312 F9.2 B32 F12.9 B321 F6.2 B322 F14.2 B3221 F4.0 B3222 F4.0 B3223 F4.0 B33 F8.0 B331 F8.0 B332 F8.0 B34 F6.2 B341 F6.2 B35 F8.0 B351 F6.2 B3511 A1 B352 F8.0 B3521 F8.0 B3522 F8.0 B353 F8.0 B36 F8.0 B42 F6.2. IF (A15="O") A15="". EXECUTE. IF (B23="99") B23="999". EXECUTE. DATASET NAME DataSet2. DATASET ACTIVATE DataSet1. ADD FILES /FILE=* /FILE='DataSet2'. DATASET CLOSE DATASET2. /* LOAD PL (Poland) /* variable A15, only 1 value ("X") corrected to "". /* variable B23 has values 112 and 113, undocumented. /* variable B28, only 1 value ("X"), corrected to "". GET DATA /TYPE=TXT /FILE="WP5\PL\SES_PL_2002_ANONYM_CD.csv" /DELCASE=LINE /DELIMITERS=";" /ARRANGEMENT=DELIMITED /FIRSTCASE=3 /IMPORTCASE=ALL /VARIABLES= country A2 YEAR F8.0 nace A1 KEY_E A8 KEY_L A6 A11 A3 A12 F1.0 A12_CLASS A8 A13 A8 A14 A1 A15 A1 A16 F8.0 A17 A3 A18 A3 A19 A3 B21 A1 B210 A3 B211 F8.0 B22_CLASS A8 B23 A3 B24 A3 B25 A2 B26 A8 B27 A2 B271 F3.2 B28 A1 B30 F6.2 B31 F9.2 B311 F6.2 B312 F9.2 B32 F12.9 B321 F6.2 B322 F14.2 B3221 F4.0 B3222 F4.0 B3223 F4.0 B33 F8.0 B331 F8.0 B332 F8.0 B34 F6.2 B341 F6.2 B35 F8.0 B351 F6.2 B3511 A1 B352 F8.0 B3521 F8.0 B3522 F8.0 B353 F8.0 B36 F8.0 B42 F6.2. IF (nace=".") nace="". EXECUTE. IF (A15="X") A15="". EXECUTE. IF (B28="X") B28="". EXECUTE. DATASET NAME DataSet2. DATASET ACTIVATE DataSet1. ADD FILES /FILE=* /FILE='DataSet2'. DATASET CLOSE DATASET2. */ LOAD PT (Portugal) /* variable nace, replace value "." with "" GET DATA /TYPE=TXT /FILE="WP5\PT\SES_PT_2002_ANONYM_CD.csv" /DELCASE=LINE /DELIMITERS=";" /ARRANGEMENT=DELIMITED /FIRSTCASE=3 /IMPORTCASE=ALL /VARIABLES= country A2 YEAR F8.0 nace A1 KEY_E A8 KEY_L A6 A11 A3 A12 F1.0 A12_CLASS A8 A13 A8 A14 A1 A15 A1 A16 F8.0 A17 A3 A18 A3 A19 A3 B21 A1 B210 A3 B211 F8.0 B22_CLASS A8 B23 A3 B24 A3 B25 A2 B26 A8 B27 A2 B271 F3.2 B28 A1 B30 F6.2 B31 F9.2 B311 F6.2 B312 F9.2 B32 F12.9 B321 F6.2 B322 F14.2 B3221 F4.0 B3222 F4.0 B3223 F4.0 B33 F8.0 B331 F8.0 B332 F8.0 B34 F6.2 B341 F6.2 B35 F8.0 B351 F6.2 B3511 A1 B352 F8.0 B3521 F8.0 B3522 F8.0 B353 F8.0 B36 F8.0 B42 F6.2. IF (nace=".") nace="". EXECUTE. DATASET NAME DataSet2. DATASET ACTIVATE DataSet1. ADD FILES /FILE=* /FILE='DataSet2'. DATASET CLOSE DATASET2. */ LOAD RO (Romania) GET DATA /TYPE=TXT /FILE="WP5\RO\SES_RO_2002_ANONYM_CD.csv" /DELCASE=LINE /DELIMITERS=";" /ARRANGEMENT=DELIMITED /FIRSTCASE=3 /IMPORTCASE=ALL /VARIABLES= country A2 YEAR F8.0 nace A1 KEY_E A8 KEY_L A6 A11 A3 A12 F1.0 A12_CLASS A8 A13 A8 A14 A1 A15 A1 A16 F8.0 A17 A3 A18 A3 A19 A3 B21 A1 B210 A3 B211 F8.0 B22_CLASS A8 B23 A3 B24 A3 B25 A2 B26 A8 B27 A2 B271 F3.2 B28 A1 B30 F6.2 B31 F9.2 B311 F6.2 B312 F9.2 B32 F12.9 B321 F6.2 B322 F14.2 B3221 F4.0 B3222 F4.0 B3223 F4.0 B33 F8.0 B331 F8.0 B332 F8.0 B34 F6.2 B341 F6.2 B35 F8.0 B351 F6.2 B3511 A1 B352 F8.0 B3521 F8.0 B3522 F8.0 B353 F8.0 B36 F8.0 B42 F6.2. DATASET NAME DataSet2. DATASET ACTIVATE DataSet1. ADD FILES /FILE=* /FILE='DataSet2'. DATASET CLOSE DATASET2. /* LOAD SE (Sweden) /* variable B25 contains missing values, corrected in "99" /* variable B26 contains value ":", corrected to"OPT" GET DATA /TYPE=TXT /FILE="WP5\SE\SES_SE_2002_ANONYM_CD.csv" /DELCASE=LINE /DELIMITERS=";" /ARRANGEMENT=DELIMITED /FIRSTCASE=3 /IMPORTCASE=ALL /VARIABLES= country A2 YEAR F8.0 nace A1 KEY_E A8 KEY_L A6 A11 A3 A12 F1.0 A12_CLASS A8 A13 A8 A14 A1 A15 A1 A16 F8.0 A17 A3 A18 A3 A19 A3 B21 A1 B210 A3 B211 F8.0 B22_CLASS A8 B23 A3 B24 A3 B25 A2 B26 A8 B27 A2 B271 F3.2 B28 A1 B30 F6.2 B31 F9.2 B311 F6.2 B312 F9.2 B32 F12.9 B321 F6.2 B322 F14.2 B3221 F4.0 B3222 F4.0 B3223 F4.0 B33 F8.0 B331 F8.0 B332 F8.0 B34 F6.2 B341 F6.2 B35 F8.0 B351 F6.2 B3511 A1 B352 F8.0 B3521 F8.0 B3522 F8.0 B353 F8.0 B36 F8.0 B42 F6.2. IF (B25="") B25="99". EXECUTE. IF (B26=".") B26="OPT". EXECUTE. DATASET NAME DataSet2. DATASET ACTIVATE DataSet1. ADD FILES /FILE=* /FILE='DataSet2'. DATASET CLOSE DATASET2. /*LOAD SK (Slovakia) GET DATA /TYPE=TXT /FILE="WP5\SK\SES_SK_2002_ANONYM_CD.csv" /DELCASE=LINE /DELIMITERS=";" /ARRANGEMENT=DELIMITED /FIRSTCASE=3 /IMPORTCASE=ALL /VARIABLES= country A2 YEAR F8.0 nace A1 KEY_E A8 KEY_L A6 A11 A3 A12 F1.0 A12_CLASS A8 A13 A8 A14 A1 A15 A1 A16 F8.0 A17 A3 A18 A3 A19 A3 B21 A1 B210 A3 B211 F8.0 B22_CLASS A8 B23 A3 B24 A3 B25 A2 B26 A8 B27 A2 B271 F3.2 B28 A1 B30 F6.2 B31 F9.2 B311 F6.2 B312 F9.2 B32 F12.9 B321 F6.2 B322 F14.2 B3221 F4.0 B3222 F4.0 B3223 F4.0 B33 F8.0 B331 F8.0 B332 F8.0 B34 F6.2 B341 F6.2 B35 F8.0 B351 F6.2 B3511 A1 B352 F8.0 B3521 F8.0 B3522 F8.0 B353 F8.0 B36 F8.0 B42 F6.2. DATASET NAME DataSet2. DATASET ACTIVATE DataSet1. ADD FILES /FILE=* /FILE='DataSet2'. DATASET CLOSE DATASET2. /* LOAD UK (United Kingdom) GET DATA /TYPE=TXT /FILE="WP5\UK\SES_UK_2002_ANONYM_CD.csv" /DELCASE=LINE /DELIMITERS=";" /ARRANGEMENT=DELIMITED /FIRSTCASE=3 /IMPORTCASE=ALL /VARIABLES= country A2 YEAR F8.0 nace A1 KEY_E A8 KEY_L A6 A11 A3 A12 F1.0 A12_CLASS A8 A13 A8 A14 A1 A15 A1 A16 F8.0 A17 A3 A18 A3 A19 A3 B21 A1 B210 A3 B211 F8.0 B22_CLASS A8 B23 A3 B24 A3 B25 A2 B26 A8 B27 A2 B271 F3.2 B28 A1 B30 F6.2 B31 F9.2 B311 F6.2 B312 F9.2 B32 F12.9 B321 F6.2 B322 F14.2 B3221 F4.0 B3222 F4.0 B3223 F4.0 B33 F8.0 B331 F8.0 B332 F8.0 B34 F6.2 B341 F6.2 B35 F8.0 B351 F6.2 B3511 A1 B352 F8.0 B3521 F8.0 B3522 F8.0 B353 F8.0 B36 F8.0 B42 F6.2. DATASET NAME DataSet2. DATASET ACTIVATE DataSet1. ADD FILES /FILE=* /FILE='DataSet2'. DATASET CLOSE DATASET2. /* Define variable labels-------------------------------------------------------------------------------------------------------------------------------- VARIABLE LABELS A11 "Region" A12 "Size of the enterprise class number (0,1,2,3,4) see A12_class see below" A12_CLASS "Size of the enterprise to which the local unit belongs see below" A13 "Economic activity" A14 "Economic and Financial control" A15 "Collective Pay Agreement" A16 "Total number of employees in the local unit" A17 "Principal market for the enterprise's products (optional)" A18 "Size of the group of enterprises (optional) " A19 "Country of residence controlling the group of enterprises (optional)" B21 "Sex" B210 "Coverage by a government scheme designed to promote employment (optional)" B211 "Years of career break (optional)" B22_CLASS "Age (Year of Birth/Age) Re- Classification see below" B23 "Occupation" B24 "Management position / supervisory position" B25 "Highest completed level of education and training" B26 "Length of service in enterprise (in years)" B27 "Full-time or part-time employee " B271 "% share of a full-timer's normal hours (to 2 decimal places)" B28 "Type of employment contract" B30 "Average gross hourly earnings in the reference month ( to 2 decimal places)" B31 "Total gross earnings in reference month" B311 "Earnings related to overtime" B312 "Special payments for shift work" B32 "Total gross annual earnings in the reference year" B321 "Number of weeks to which the gross annual earnings relate (to 2 decimal places)" B322 "Total Annual Bonuses" B3221 "Regular bonuses paid not at every pay period" B3222 "Annual bonuses based on productivity" B3223 "Annual premiums related to profit sharing" B33 "Compulsory social contributions and taxes paid by the employer" B331 "Compulsory social security contributions" B332 "Taxes" B34 "Number of hours paid during the reference month" B341 "Number of overtime hours paid in the reference month" B35 "Other annual days of paid absence" B351 "Annual days of holiday leave (in full days)" B3511 "Normal annual holiday entitlement (E) or Days of leave actually taken (T)" B352 "Annual days of sick leave" B3521 "Annual days of sick leave paid by the employer" B3522 "Annual days of sick leave not paid by the employer" B353 "Annual days of vocational training" B36 "Annual for payment in kind" B42 "Grossing-up factor for employees (to 2 decimal places)" country "country identification (A)" KEY_E "Key identifying the employee" KEY_L "Key identifying the local unit" nace "1 digit NACE rev 1.1 section identification" YEAR "Identification of the reference period (eg 2006)" A41 "(IT only) Grossing-up factor for local units (to 2 decimal places)". /* Define value labels-------------------------------------------------------------------------------------------------------------------------------- VALUE LABELS country "BE " "Belgium" "BG " "Bulgaria" "CY " "Cyprus" "CZ " "Czech Republic" "EE " "Estonia" "EL" "Greece" "ES" "Spain" "FI " "Finland" "FR " "France" "HU " "Hungary" "IT " "Italy" "LT " "Lithuania" "LU " "Luxembourg" "LV " "Latvia" "NL " "Netherlands" "NO " "Norway" "PL " "Poland" "PT " "Portugal" "RO " "Romania" "SE " "Sweden" "SK " "Slovakia" "UK" "United Kingdom". VALUE LABELS nace "A" "Agriculture, hunting and forestry" "B" "Fishing " "C" "Mining and quarrying" "D" "Manufacturing" "E" "Electricity, gas and water supply" "F" "Construction" "G" "Wholesale and retail trade; repair of motor vehicles, motorcycles and personal and household goods" "H" "Hotels and restaurants" "I" " Transport, storage and communication" "J" " Financial intermediation" "K" "Real estate, renting and business activities" "L" "Public administration and defence; compulsory social security" "M" "Education" "N" "Health and social work" "O" " Other community, social and personal service activities" "P" "Activities of households " "Q" "Extra-territorial organizations and bodies". VALUE LABELS A11 'BE' "BELGIQUE-BELGIË" 'BE1' "RÉGION DE BRUXELLES- CAPITALE / BRUSSELS HOOFDSTEDELIJK GEWEST" 'BE2' "VLAAMS GEWEST" 'BE3' "RÉGION WALLONNE" 'BG' "BULGARIJA" 'BG3' "SEVERNA I IZTOCHNA BULGARIA" 'BG4' "YUGOZAPADNA I YUZHNA TSENTRALNA BULGARIA" 'CZ' "ČESKÁ REPUBLIKA" 'DK' "DANMARK" 'DE' "DEUTSCHLAND" 'DE1' "BADEN-WÜRTTEMBERG" 'DE2' "BAYERN" 'DE3' "BERLIN" 'DE4' "BRANDENBURG" 'DE5' "BREMEN" 'DE6' "HAMBURG" 'DE7' "HESSEN" 'DE8' "MECKLENBURG-VORPOMMERN" 'DE9' "NIEDERSACHSEN" 'DEA' "NORDRHEIN-WESTFALEN" 'DEB' "RHEINLAND-PFALZ" 'DEC' "SAARLAND" 'DED' "SACHSEN" 'DEE' "SACHSEN-ANHALT" 'DEF' "SCHLESWIG-HOLSTEIN" 'DEG' "THÜRINGEN" 'EE' "EESTI" 'IE' "ÉIRE/IRELAND" 'EL' "ELLÁDA" 'EL1' "VOREIA ELLADA" 'EL2' "KENTRIKI ELLADA" 'EL3' "ATTIKI" 'EL4' "NISIA AIGAIOU, KRITI" 'ELX' "EL only, undocumented" 'ES' "ESPAÑA" 'ES1' "NOROESTE" 'ES2' "NORESTE" 'ES3' "COMUNIDAD DE MADRID" 'ES4' "CENTRO (E)" 'ES5' "ESTE" 'ES6' "SUR" 'ES7' "CANARIAS" 'FIX' "FI only, undocumented" 'FR' "FRANCE" 'FR1' "ÎLE DE FRANCE" 'FR2' "BASSIN PARISIEN" 'FR3' "NORD - PAS-DE-CALAIS" 'FR4' "EST" 'FR5' "OUEST" 'FR6' "SUD-OUEST" 'FR7' "CENTRE-EST" 'FR8' "MÉDITERRANÉE" 'FR9' "DÉPARTEMENTS D'OUTRE-MER" 'IT' "ITALIA" 'ITC' "NORD-OVEST" 'ITD' "NORD-EST" 'ITE' "CENTRO (I)" 'ITF' "SUD" 'ITG' "ISOLE" 'CY' "KYPROS / KIBRIS" 'LV' "LATVIJA" 'LT' "LIETUVA" 'LU' "LUXEMBOURG (GRAND-DUCHÉ)" 'HU' "MAGYARORSZÁG" 'HU1' "KOZEP-MAGYARORSZAG" 'HU2' "DUNANTUL" 'HU3' "ALFOLD ES ESZAK" 'MT' "MALTA" 'NL' "NEDERLAND" 'NL1' "NOORD-NEDERLAND" 'NL2' "OOST-NEDERLAND" 'NL3' "WEST-NEDERLAND" 'NL4' "ZUID-NEDERLAND" 'NO' "NO only" 'AT' "ÖSTERREICH" 'AT1' "OSTÖSTERREICH" 'AT2' "SÜDÖSTERREICH" 'AT3' "WESTÖSTERREICH" 'PL' "POLSKA" 'PL1' "CENTRALNY" 'PL2' "POLUDNIOWY" 'PL3' "WSCHODNI" 'PL4' "POLNOCNO-ZACHODNI" 'PL5' "POLUDNIOWO-ZACHODNI" 'PL6' "POLNOCNY" 'PT' "PORTUGAL" 'PT1' "CONTINENTE" 'PT2' "REGIÃO AUTÓNOMA DOS AÇORES" 'PT3' "REGIÃO AUTÓNOMA DA MADEIRA" 'RO' "ROMÂNIA" 'RO1' "MACROREGIUNEA UNU" 'RO2' "MACROREGIUNEA DOI" 'RO3' "MACROREGIUNEA TREI" 'RO4' "MACROREGIUNEA PATRU" 'SI' "SLOVENIJA" 'SK' "SLOVENSKA REPUBLIKA" 'FI' "SUOMI / FINLAND" 'FI1' "MANNER-SUOMI" 'FI2' "ÅLAND" 'SE' "SVERIGE" 'SE1' "ÖSTRA SVERIGE" 'SE2' "SÖDRA SVERIGE" 'SE3' "NORRA SVERIGE" 'UK' "UNITED KINGDOM" 'UKC' "NORTH EAST (ENGLAND)" 'UKD' "NORTH WEST (ENGLAND)" 'UKE' "YORKSHIRE AND THE HUMBER" 'UKF' "EAST MIDLANDS" 'UKG' "WEST MIDLANDS" 'UKH' "EAST OF ENGLAND" 'UKI' "LONDON" 'UKJ' "SOUTH EAST (ENGLAND)" 'UKK' "SOUTH WEST (ENGLAND)" 'UKL' "WALES" 'UKM' "SCOTLAND" 'UKN' "NORTHERN IRELAND" 'ZZZ' "NL only, anonymized". VALUE LABELS A12 "0" "1_49" "1" "50_249" "2" "GT_250" "3" "GT_50" "4" "ALL" "5" "IT only 250-999" "6" "IT only 50-1000" "7" "IT only LT_250" "8" "IT only GT_1000". VALUE LABELS A14 "A" "public control" "B" "private control" "C" "shared control". VALUE LABELS A15 "A" "national level or interconfederal agreement" "B" "industry agreement" "C" "agreement for individual industries in individual regions" "D" "enterprise or single employer agreement" "E" "agreement applying only to workers in the local unit" "F" "any other type of agreement" "N" "no collective agreement exists". VALUE LABELS A17 "A" "local or regional market" "B" "national market" "C" "European Union market" "D" "world market" "OPT" "Optional". Value Labels A18 999 "Optional". VALUE LABELS B21 "F" "Female" "M" "Male" "Z" "NL only, Anonymized". VALUE LABELS B23 "11" "Legislators and senior officials" "111" "Legislators and senior government officials" "112" "PL only, undocumented" "113" "PL only, undocumented" "114" "Senior officials of special-interest organisations" "12" "Corporate managers" "121" "Directors and chief executives" "122" "Production and operations managers" "123" "Other specialist managers" "13" "Managers of small enterprises" "131" "Managers of small enterprises" "21" "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" "22" "Life science and health professionals" "221" "Life science professionals" "222" "Health professionals (except nursing)" "223" "Nursing and midwifery professionals" "23" "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" "24" "Other professionals" "241" "Business professionals" "242" "Legal professionals" "243" "Archivists, librarians and related information professionals" "244" "Social science and related professionals" "245" "Writers and creative or performing artists" "246" "Religious professionals" "247" "Public service administrative professionals" "31" "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" "32" "Life science and health associate professionals" "321" "Life science technicians and related associate professional" "322" "Health associate professionals (except nursing)" "323" "Nursing and midwifery associate professionals" "33" "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" "34" "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" "41" "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" "42" "Customer services clerks" "421" "Cashiers, tellers and related clerks" "422" "Client information clerks" "51" "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 services workers" "516" "Protective services workers" "52" "Models, salespersons and demonstrators" "521" "Fashion and other models" "522" "Shop, stall and market salespersons and demonstrators" "61" "Skilled agricultural and fishery workers" "611" "Market gardeners and crop growers" "612" "Animal producers and related workers not elsewhere classified" "613" "Crop and animal producers" "614" "Forestry and related workers" "615" "Fishery workers, hunters and trappers" "71" "Extraction and building trades workers" "711" "Miners, shotfirers, stone cutters and carvers" "712" "Building frame and related trades workers" "713" "Building finishers and related trades workers" "714" "Painters, building structure cleaners and related trades workers" "72" "Metal, machinery and related trades workers" "721" "Metal moulders, welders, sheet-metal workers, structural-metal preparers, and related trades workers" "722" "Blacksmiths, tool-makers and related trades workers" "723" "Machinery mechanics and fitters" "724" "Electrical and electronic equipment mechanics and fitters" "73" "Precision, handicraft, craft 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" "Craft printing and related trades workers" "74" "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" "Pelt, leather and shoemaking trades workers" "81" "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" "Industrial robot operators" "82" "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 not elsewhere classified" "83" "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" "91" "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 related workers" "916" "Garbage collectors and related labourers" "92" "Agricultural, fishery and related labourers" "921" "Agricultural, fishery and related labourers" "93" "Labourers in mining, construction, manufacturing and transport" "931" "Mining and construction labourers" "932" "Manufacturing labourers" "933" "Transport labourers and freight handlers" "01" "Armed forces" "010" "Armed forces". VALUE LABELS B24 "Y" "Yes, the employee has some form of management function" "N" "No" "OPT" "information is not available". VALUE LABELS B25 "01" "ISCED 0 and 1" "02" "ISCED 2" "03" "ISCED 3" "04" "ISCED 3A" "05" "ISCED 3B" "06" "ISCED 3C (< 3 years)" "07" "ISCED 3C (>= 3 years)" "08" "ISCED 4" "09" "ISCED 5B" "10" "ISCED 5A" "11" "ISCED 6" "99" "Value missing (SE and LU only)". VALUE LABELS B27 "FT" "full-time employee" "PT" "part-time employee". VALUE LABELS B28 "A" "indefinite duration" "B" "temporary/fixed duration (except apprentice)" "C" "apprentice" "D" "other". /* Define missing values-------------------------------------------------------------------------------------------------------------------------------- MISSING VALUES B25 ("99"). MISSING VALUES A13 ("ZZZ"). MISSING VALUES A16 A41 B211 B312 B331 B332 B33 B34 B35 B3521 B3522 B353 B36 B42 (99999999). MISSING VALUES A17 ("OPT"). MISSING VALUES A18 ("999"). MISSING VALUES B23 B352 ("999"). MISSING VALUES B24 ("OPT"). MISSING VALUES B26 ("OPT"). MISSING VALUES B28 (""). MISSING VALUES nace (""). SAVE OUTFILE='WP5\SES-2002.sav' /COMPRESSED.