* Encoding: windows-1252. * ==================================================================================================. * EU-SILC cross 2009 - release 2021-09 / DOI: TBD. * * When publishing statistics derived from the EU-SILC UDB, please state as source: * "EU-SILC UDB - version of 2021-09" * * SPSS Command Syntax File * 2009_cross_eu_silc_p_ver_2022_03.sps * * (c) 2022-06-02 GESIS * * PLEASE NOTE * For Differences between data as described in the guidelines * and the anonymised user database as well as country specific anonymisation measures see: * L-2009 DIFFERENCES BETWEEN DATA COLLECTED.doc * * ==================================================================================================. * * EU-SILC - cross - Personal data file: * * * Transforms the EU-SILC CSV-data (as released by Eurostat) into an SPSS-Systemfile * * This version of the EU-SILC has been delivered in form of seperate country files. * The following syntax transforms the raw data into one SPSS file using all available country files. * * Country files are delivered in the format UDB_l*country_stub*.csv * * This SPSS-File is free software: you can redistribute it and/or modify * it under the terms of the GNU Affero General Public License as * published by the Free Software Foundation, either version 3 of the * License, or (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Affero General Public License for more details. * * You should have received a copy of the GNU Affero General Public License * along with this program. If not, see . * * * Pforr, Klaus and Johanna Jung (2022): 2009_cross_eu_silc_p_ver_2022_03.sps. * SPSS-Syntax for transforming EU-SILC csv data into an SPSS-Systemfile. * * https://www.gesis.org/gml/european-microdata/eu-silc/ * * Contact: klaus.pforr@gesis.org ***************************************************************************************. set decimal=DOT. * When using SPSS earlier than V16 you might not use "set unicode" . set unicode=OFF. output close all. *----------------------------------------------------------------- Start definition macro ---------------------------------------------------------------. DEFINE !C2009_P (). *-------------------------------------------------------- CONFIGURATION SECTION - Start ------------------------------------------------------. * The following command should contain the complete path where the CSV data files are stored; * 1) Change CSV_PATH to your file path; (E.g. C:\EU-SILC\Crossectional 2004-2017\); * 2) But keep path structure as delivered by Eurostat CSV_PATH/COUNTRY/YEAR . !LET !csv_path ='CSV_PATH' * The following command should contain the complete path where the SPSS data files should be stored; * Change SPSS_PATH to your file path. !LET !spss_path ='SPSS_PATH' * The following command should contain the name of the SPSS data file (specify without .sav extension); * Change SPSS_FILENAME to your final filename. !LET !finalfile ='SPSS_FILENAME' *----------------------------------------------------------- CONFIGURATION SECTION - End ---------------------------------------------------------. * There should be probably nothing to change below this line. * ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------. *------------------------------------------------------------- Definition of country stubs -----------------------------------------------------------------------. !LET !CC1= 'MT PT SE'. !LET !CC2='AT BE BG CH CY CZ DE DK EE EL ES FI FR HU IE IS LT LU LV NL PL SI SK UK'. !LET !CC3= 'IT NO RO'. !LET !CC='AT BE BG CH CY CZ DE DK EE EL ES FI FR HU IE IS LT LU LV NL PL SI SK UK MT PT SE IT NO RO'. !DO !i !IN (!CC1) set decimal=DOT. GET DATA /TYPE=TXT /FILE=!QUOTE(!CONCAT(!csv_path,!i,'\2009\UDB_c',!i,'09P.csv')) /ENCODING='Locale' /DELCASE=LINE /DELIMITERS=',' /ARRANGEMENT=DELIMITED /FIRSTCASE=2 /IMPORTCASE=ALL /VARIABLES= PB010 F4.0 PB020 A2 PB030 F5.0 PB040 COMMA8.0 PB040_F F1.0 PB060 COMMA8.0 PB060_F F1.0 PB100 F1.0 PB100_F F1.0 PB110 F4.0 PB110_F F1.0 PB120 F2.0 PB120_F F1.0 PB130 F1.0 PB130_F F1.0 PB140 F4.0 PB140_F F1.0 PB150 F1.0 PB150_F F1.0 PB160 F5.0 PB160_F F2.0 PB170 F5.0 PB170_F F2.0 PB180 F5.0 PB180_F F2.0 PB190 F1.0 PB190_F F1.0 PB200 F1.0 PB200_F F1.0 PB210 A3 PB210_F F1.0 PB220A A3 PB220A_F F1.0 PE010 F1.0 PE010_F F1.0 PE020 F1.0 PE020_F F2.0 PE030 F4.0 PE030_F F1.0 PE040 F1.0 PE040_F F1.0 PL030 F1.0 PL030_F F1.0 PL035 F1.0 PL035_F F1.0 PL015 F1.0 PL015_F F2.0 PL020 F1.0 PL020_F F2.0 PL025 F1.0 PL025_F F2.0 PL040 F1.0 PL040_F F2.0 PL050 F2.0 PL050_F F2.0 PL060 F2.0 PL060_F F2.0 PL080 F2.0 PL080_F F1.0 PL085 F2.0 PL085_F F1.0 PL087 F2.0 PL087_F F1.0 PL090 F2.0 PL090_F F1.0 PL100 F2.0 PL100_F F2.0 PL110_F F2.0 PL111_F F2.0 PL120 F1.0 PL120_F F2.0 PL130 F2.0 PL130_F F2.0 PL140 F1.0 PL140_F F2.0 PL150 F1.0 PL150_F F2.0 PL160 F1.0 PL160_F F2.0 PL170 F1.0 PL170_F F2.0 PL180 F2.0 PL180_F F2.0 PL190 F2.0 PL190_F F2.0 PL200 F2.0 PL200_F F2.0 PL210A F1.0 PL210A_F F1.0 PL210B F1.0 PL210B_F F1.0 PL210C F1.0 PL210C_F F1.0 PL210D F1.0 PL210D_F F1.0 PL210E F1.0 PL210E_F F1.0 PL210F F1.0 PL210F_F F1.0 PL210G F1.0 PL210G_F F1.0 PL210H F1.0 PL210H_F F1.0 PL210I F1.0 PL210I_F F1.0 PL210J F1.0 PL210J_F F1.0 PL210K F1.0 PL210K_F F1.0 PL210L F1.0 PL210L_F F1.0 PL211A F2.0 PL211A_F F1.0 PL211B F2.0 PL211B_F F1.0 PL211C F2.0 PL211C_F F1.0 PL211D F2.0 PL211D_F F1.0 PL211E F2.0 PL211E_F F1.0 PL211F F2.0 PL211F_F F1.0 PL211G F2.0 PL211G_F F1.0 PL211H F2.0 PL211H_F F1.0 PL211I F2.0 PL211I_F F1.0 PL211J F2.0 PL211J_F F1.0 PL211K F2.0 PL211K_F F1.0 PL211L F2.0 PL211L_F F1.0 PH010 F1.0 PH010_F F1.0 PH020 F1.0 PH020_F F1.0 PH030 F1.0 PH030_F F1.0 PH040 F1.0 PH040_F F1.0 PH050 F1.0 PH050_F F2.0 PH060 F1.0 PH060_F F1.0 PH070 F1.0 PH070_F F2.0 PY010N COMMA8.0 PY010N_F F2.0 PY010N_I COMMA9.0 PY020N COMMA9.0 PY020N_F F2.0 PY020N_I COMMA9.0 PY021N COMMA7.0 PY021N_F F2.0 PY021N_I COMMA9.0 PY035N COMMA7.0 PY035N_F F1.0 PY035N_I COMMA9.0 PY050N COMMA8.0 PY050N_F F2.0 PY050N_I COMMA9.0 PY070N COMMA7.0 PY070N_F F2.0 PY070N_I COMMA9.0 PY080N COMMA4.0 PY080N_F F1.0 PY080N_I COMMA9.0 PY090N COMMA7.0 PY090N_F F2.0 PY090N_I COMMA9.0 PY100N COMMA8.0 PY100N_F F2.0 PY100N_I COMMA9.0 PY110N COMMA8.0 PY110N_F F2.0 PY110N_I COMMA9.0 PY120N COMMA7.0 PY120N_F F2.0 PY120N_I COMMA9.0 PY130N COMMA8.0 PY130N_F F2.0 PY130N_I COMMA9.0 PY140N COMMA7.0 PY140N_F F2.0 PY140N_I COMMA9.0 PY010G COMMA8.0 PY010G_F F1.0 PY010G_I COMMA9.0 PY020G COMMA4.2 PY020G_F F2.0 PY020G_I COMMA9.0 PY021G COMMA7.0 PY021G_F F2.0 PY021G_I COMMA9.0 PY030G COMMA8.0 PY030G_F F1.0 PY030G_I COMMA9.0 PY031G COMMA9.0 PY031G_F F2.0 PY031G_I COMMA9.0 PY035G COMMA7.0 PY035G_F F1.0 PY035G_I COMMA9.0 PY050G COMMA8.0 PY050G_F F1.0 PY050G_I COMMA9.0 PY070G COMMA7.0 PY070G_F F1.0 PY070G_I COMMA9.0 PY080G COMMA4.0 PY080G_F F1.0 PY080G_I COMMA9.0 PY090G COMMA7.0 PY090G_F F1.0 PY090G_I COMMA9.0 PY100G COMMA8.0 PY100G_F F1.0 PY100G_I COMMA9.0 PY110G COMMA8.0 PY110G_F F1.0 PY110G_I COMMA9.0 PY120G COMMA7.0 PY120G_F F1.0 PY120G_I COMMA9.0 PY130G COMMA8.0 PY130G_F F1.0 PY130G_I COMMA9.0 PY140G COMMA7.0 PY140G_F F1.0 PY140G_I COMMA9.0 PY200G COMMA7.0 PY200G_F F2.0 PY200G_I COMMA9.0 PD010 F1.0 PD010_F F1.0 PD020 F1.0 PD020_F F1.0 PD030 F1.0 PD030_F F1.0 PD040 F1.0 PD040_F F1.0 PD050 F1.0 PD050_F F1.0 PD060 F1.0 PD060_F F1.0 PD070 F1.0 PD070_F F1.0 PX030 F3.0 PX040 F1.0 PL031 F2.0 PL031_F F1.0 PL073 F2.0 PL073_F F1.0 PL074 F2.0 PL074_F F1.0 PL075 F2.0 PL075_F F1.0 PL076 F2.0 PL076_F F1.0 PL086 F2.0 PL086_F F1.0 PL088 F2.0 PL088_F F1.0 PL089 F2.0 PL089_F F1.0 PS005 A10 PS005_F A10 PX020 F2.0 PX050 F1.0 PX010 COMMA9.0 PL110 A5 PL111 A5. delete variables PS005 PS005_F. SAVE OUTFILE= !QUOTE(!CONCAT(!spss_path,'UDB_c',!i,'09P.sav')). !DOEND. !DO !i !IN (!CC2) set decimal=DOT. GET DATA /TYPE=TXT /FILE=!QUOTE(!CONCAT(!csv_path,!i,'\2009\UDB_c',!i,'09P.csv')) /ENCODING='Locale' /DELCASE=LINE /DELIMITERS=',' /ARRANGEMENT=DELIMITED /FIRSTCASE=2 /IMPORTCASE=ALL /VARIABLES= PB010 F4.0 PB020 A2 PB030 F5.0 PB040 COMMA8.0 PB040_F F1.0 PB060 COMMA8.0 PB060_F F1.0 PB100 F1.0 PB100_F F1.0 PB110 F4.0 PB110_F F1.0 PB120 F2.0 PB120_F F1.0 PB130 F1.0 PB130_F F1.0 PB140 F4.0 PB140_F F1.0 PB150 F1.0 PB150_F F1.0 PB160 F5.0 PB160_F F2.0 PB170 F5.0 PB170_F F2.0 PB180 F5.0 PB180_F F2.0 PB190 F1.0 PB190_F F1.0 PB200 F1.0 PB200_F F1.0 PB210 A3 PB210_F F1.0 PB220A A3 PB220A_F F1.0 PE010 F1.0 PE010_F F1.0 PE020 F1.0 PE020_F F2.0 PE030 F4.0 PE030_F F1.0 PE040 F1.0 PE040_F F1.0 PL030 F1.0 PL030_F F1.0 PL035 F1.0 PL035_F F1.0 PL015 F1.0 PL015_F F2.0 PL020 F1.0 PL020_F F2.0 PL025 F1.0 PL025_F F2.0 PL040 F1.0 PL040_F F2.0 PL050 F2.0 PL050_F F2.0 PL060 F2.0 PL060_F F2.0 PL080 F2.0 PL080_F F1.0 PL085 F2.0 PL085_F F1.0 PL087 F2.0 PL087_F F1.0 PL090 F2.0 PL090_F F1.0 PL100 F2.0 PL100_F F2.0 PL110_F F2.0 PL111_F F2.0 PL120 F1.0 PL120_F F2.0 PL130 F2.0 PL130_F F2.0 PL140 F1.0 PL140_F F2.0 PL150 F1.0 PL150_F F2.0 PL160 F1.0 PL160_F F2.0 PL170 F1.0 PL170_F F2.0 PL180 F2.0 PL180_F F2.0 PL190 F2.0 PL190_F F2.0 PL200 F2.0 PL200_F F2.0 PL210A F1.0 PL210A_F F1.0 PL210B F1.0 PL210B_F F1.0 PL210C F1.0 PL210C_F F1.0 PL210D F1.0 PL210D_F F1.0 PL210E F1.0 PL210E_F F1.0 PL210F F1.0 PL210F_F F1.0 PL210G F1.0 PL210G_F F1.0 PL210H F1.0 PL210H_F F1.0 PL210I F1.0 PL210I_F F1.0 PL210J F1.0 PL210J_F F1.0 PL210K F1.0 PL210K_F F1.0 PL210L F1.0 PL210L_F F1.0 PL211A F2.0 PL211A_F F1.0 PL211B F2.0 PL211B_F F1.0 PL211C F2.0 PL211C_F F1.0 PL211D F2.0 PL211D_F F1.0 PL211E F2.0 PL211E_F F1.0 PL211F F2.0 PL211F_F F1.0 PL211G F2.0 PL211G_F F1.0 PL211H F2.0 PL211H_F F1.0 PL211I F2.0 PL211I_F F1.0 PL211J F2.0 PL211J_F F1.0 PL211K F2.0 PL211K_F F1.0 PL211L F2.0 PL211L_F F1.0 PH010 F1.0 PH010_F F1.0 PH020 F1.0 PH020_F F1.0 PH030 F1.0 PH030_F F1.0 PH040 F1.0 PH040_F F1.0 PH050 F1.0 PH050_F F2.0 PH060 F1.0 PH060_F F1.0 PH070 F1.0 PH070_F F2.0 PY010N COMMA8.0 PY010N_F F2.0 PY010N_I COMMA9.0 PY020N COMMA9.0 PY020N_F F2.0 PY020N_I COMMA9.0 PY021N COMMA7.0 PY021N_F F2.0 PY021N_I COMMA9.0 PY035N COMMA7.0 PY035N_F F1.0 PY035N_I COMMA9.0 PY050N COMMA8.0 PY050N_F F2.0 PY050N_I COMMA9.0 PY070N COMMA7.0 PY070N_F F2.0 PY070N_I COMMA9.0 PY080N COMMA4.0 PY080N_F F1.0 PY080N_I COMMA9.0 PY090N COMMA7.0 PY090N_F F2.0 PY090N_I COMMA9.0 PY100N COMMA8.0 PY100N_F F2.0 PY100N_I COMMA9.0 PY110N COMMA8.0 PY110N_F F2.0 PY110N_I COMMA9.0 PY120N COMMA7.0 PY120N_F F2.0 PY120N_I COMMA9.0 PY130N COMMA8.0 PY130N_F F2.0 PY130N_I COMMA9.0 PY140N COMMA7.0 PY140N_F F2.0 PY140N_I COMMA9.0 PY010G COMMA8.0 PY010G_F F1.0 PY010G_I COMMA9.0 PY020G COMMA4.2 PY020G_F F2.0 PY020G_I COMMA9.0 PY021G COMMA7.0 PY021G_F F2.0 PY021G_I COMMA9.0 PY030G COMMA8.0 PY030G_F F1.0 PY030G_I COMMA9.0 PY031G COMMA9.0 PY031G_F F2.0 PY031G_I COMMA9.0 PY035G COMMA7.0 PY035G_F F1.0 PY035G_I COMMA9.0 PY050G COMMA8.0 PY050G_F F1.0 PY050G_I COMMA9.0 PY070G COMMA7.0 PY070G_F F1.0 PY070G_I COMMA9.0 PY080G COMMA4.0 PY080G_F F1.0 PY080G_I COMMA9.0 PY090G COMMA7.0 PY090G_F F1.0 PY090G_I COMMA9.0 PY100G COMMA8.0 PY100G_F F1.0 PY100G_I COMMA9.0 PY110G COMMA8.0 PY110G_F F1.0 PY110G_I COMMA9.0 PY120G COMMA7.0 PY120G_F F1.0 PY120G_I COMMA9.0 PY130G COMMA8.0 PY130G_F F1.0 PY130G_I COMMA9.0 PY140G COMMA7.0 PY140G_F F1.0 PY140G_I COMMA9.0 PY200G COMMA7.0 PY200G_F F2.0 PY200G_I COMMA9.0 PD010 F1.0 PD010_F F1.0 PD020 F1.0 PD020_F F1.0 PD030 F1.0 PD030_F F1.0 PD040 F1.0 PD040_F F1.0 PD050 F1.0 PD050_F F1.0 PD060 F1.0 PD060_F F1.0 PD070 F1.0 PD070_F F1.0 PX030 F3.0 PX040 F1.0 PL031 F2.0 PL031_F F1.0 PL073 F2.0 PL073_F F1.0 PL074 F2.0 PL074_F F1.0 PL075 F2.0 PL075_F F1.0 PL076 F2.0 PL076_F F1.0 PL086 F2.0 PL086_F F1.0 PL088 F2.0 PL088_F F1.0 PL089 F2.0 PL089_F F1.0 PL070 F2.0 PL070_F F1.0 PL072 F2.0 PL072_F F1.0 PX020 F2.0 PX050 F1.0 PX010 COMMA9.0 PL110 A5 PL111 A5. SAVE OUTFILE= !QUOTE(!CONCAT(!spss_path,'UDB_c',!i,'09P.sav')). !DOEND. !DO !i !IN (!CC3) GET DATA /TYPE=TXT /FILE=!QUOTE(!CONCAT(!csv_path,!i,'\2009\UDB_c',!i,'09P.csv')) /ENCODING='Locale' /DELCASE=LINE /DELIMITERS=',' /ARRANGEMENT=DELIMITED /FIRSTCASE=2 /IMPORTCASE=ALL /VARIABLES= PB010 F4.0 PB020 A2 PB030 F5.0 PB040 COMMA8.0 PB040_F F1.0 PB060 COMMA8.0 PB060_F F1.0 PB100 F1.0 PB100_F F1.0 PB110 F4.0 PB110_F F1.0 PB120 F2.0 PB120_F F1.0 PB130 F1.0 PB130_F F1.0 PB140 F4.0 PB140_F F1.0 PB150 F1.0 PB150_F F1.0 PB160 F5.0 PB160_F F2.0 PB170 F5.0 PB170_F F2.0 PB180 F5.0 PB180_F F2.0 PB190 F1.0 PB190_F F1.0 PB200 F1.0 PB200_F F1.0 PB210 A3 PB210_F F1.0 PB220A A3 PB220A_F F1.0 PE010 F1.0 PE010_F F1.0 PE020 F1.0 PE020_F F2.0 PE030 F4.0 PE030_F F1.0 PE040 F1.0 PE040_F F1.0 PL030 F1.0 PL030_F F1.0 PL035 F1.0 PL035_F F1.0 PL015 F1.0 PL015_F F2.0 PL020 F1.0 PL020_F F2.0 PL025 F1.0 PL025_F F2.0 PL040 F1.0 PL040_F F2.0 PL050 F2.0 PL050_F F2.0 PL060 F2.0 PL060_F F2.0 PL080 F2.0 PL080_F F1.0 PL085 F2.0 PL085_F F1.0 PL087 F2.0 PL087_F F1.0 PL090 F2.0 PL090_F F1.0 PL100 F2.0 PL100_F F2.0 PL110_F F2.0 PL111_F F2.0 PL120 F1.0 PL120_F F2.0 PL130 F2.0 PL130_F F2.0 PL140 F1.0 PL140_F F2.0 PL150 F1.0 PL150_F F2.0 PL160 F1.0 PL160_F F2.0 PL170 F1.0 PL170_F F2.0 PL180 F2.0 PL180_F F2.0 PL190 F2.0 PL190_F F2.0 PL200 F2.0 PL200_F F2.0 PL210A F1.0 PL210A_F F1.0 PL210B F1.0 PL210B_F F1.0 PL210C F1.0 PL210C_F F1.0 PL210D F1.0 PL210D_F F1.0 PL210E F1.0 PL210E_F F1.0 PL210F F1.0 PL210F_F F1.0 PL210G F1.0 PL210G_F F1.0 PL210H F1.0 PL210H_F F1.0 PL210I F1.0 PL210I_F F1.0 PL210J F1.0 PL210J_F F1.0 PL210K F1.0 PL210K_F F1.0 PL210L F1.0 PL210L_F F1.0 PL211A F2.0 PL211A_F F1.0 PL211B F2.0 PL211B_F F1.0 PL211C F2.0 PL211C_F F1.0 PL211D F2.0 PL211D_F F1.0 PL211E F2.0 PL211E_F F1.0 PL211F F2.0 PL211F_F F1.0 PL211G F2.0 PL211G_F F1.0 PL211H F2.0 PL211H_F F1.0 PL211I F2.0 PL211I_F F1.0 PL211J F2.0 PL211J_F F1.0 PL211K F2.0 PL211K_F F1.0 PL211L F2.0 PL211L_F F1.0 PH010 F1.0 PH010_F F1.0 PH020 F1.0 PH020_F F1.0 PH030 F1.0 PH030_F F1.0 PH040 F1.0 PH040_F F1.0 PH050 F1.0 PH050_F F2.0 PH060 F1.0 PH060_F F1.0 PH070 F1.0 PH070_F F2.0 PY010N COMMA8.0 PY010N_F F2.0 PY010N_I COMMA9.0 PY020N COMMA9.0 PY020N_F F2.0 PY020N_I COMMA9.0 PY021N COMMA7.0 PY021N_F F2.0 PY021N_I COMMA9.0 PY035N COMMA7.0 PY035N_F F1.0 PY035N_I COMMA9.0 PY050N COMMA8.0 PY050N_F F2.0 PY050N_I COMMA9.0 PY070N COMMA7.0 PY070N_F F2.0 PY070N_I COMMA9.0 PY080N COMMA4.0 PY080N_F F1.0 PY080N_I COMMA9.0 PY090N COMMA7.0 PY090N_F F2.0 PY090N_I COMMA9.0 PY100N COMMA8.0 PY100N_F F2.0 PY100N_I COMMA9.0 PY110N COMMA8.0 PY110N_F F2.0 PY110N_I COMMA9.0 PY120N COMMA7.0 PY120N_F F2.0 PY120N_I COMMA9.0 PY130N COMMA8.0 PY130N_F F2.0 PY130N_I COMMA9.0 PY140N COMMA7.0 PY140N_F F2.0 PY140N_I COMMA9.0 PY010G COMMA8.0 PY010G_F F1.0 PY010G_I COMMA9.0 PY020G COMMA4.2 PY020G_F F2.0 PY020G_I COMMA9.0 PY021G COMMA7.0 PY021G_F F2.0 PY021G_I COMMA9.0 PY030G COMMA8.0 PY030G_F F1.0 PY030G_I COMMA9.0 PY031G COMMA9.0 PY031G_F F2.0 PY031G_I COMMA9.0 PY035G COMMA7.0 PY035G_F F1.0 PY035G_I COMMA9.0 PY050G COMMA8.0 PY050G_F F1.0 PY050G_I COMMA9.0 PY070G COMMA7.0 PY070G_F F1.0 PY070G_I COMMA9.0 PY080G COMMA4.0 PY080G_F F1.0 PY080G_I COMMA9.0 PY090G COMMA7.0 PY090G_F F1.0 PY090G_I COMMA9.0 PY100G COMMA8.0 PY100G_F F1.0 PY100G_I COMMA9.0 PY110G COMMA8.0 PY110G_F F1.0 PY110G_I COMMA9.0 PY120G COMMA7.0 PY120G_F F1.0 PY120G_I COMMA9.0 PY130G COMMA8.0 PY130G_F F1.0 PY130G_I COMMA9.0 PY140G COMMA7.0 PY140G_F F1.0 PY140G_I COMMA9.0 PY200G COMMA7.0 PY200G_F F2.0 PY200G_I COMMA9.0 PD010 F1.0 PD010_F F1.0 PD020 F1.0 PD020_F F1.0 PD030 F1.0 PD030_F F1.0 PD040 F1.0 PD040_F F1.0 PD050 F1.0 PD050_F F1.0 PD060 F1.0 PD060_F F1.0 PD070 F1.0 PD070_F F1.0 PX030 F3.0 PX040 F1.0 PL031 F2.0 PL031_F F1.0 PL073 F2.0 PL073_F F1.0 PL074 F2.0 PL074_F F1.0 PL075 F2.0 PL075_F F1.0 PL076 F2.0 PL076_F F1.0 PL086 F2.0 PL086_F F1.0 PL088 F2.0 PL088_F F1.0 PL089 F2.0 PL089_F F1.0 PL070 F2.0 PL070_F F1.0 PL072 F2.0 PL072_F F1.0 PS005 A10 PS005_F A10 PX020 F2.0 PX050 F1.0 PX010 COMMA9.0 PL110 A5 PL111 A5. delete variables PS005 PS005_F. Variable labels PB010 'Year of the survey'/ PB020 'Country alphanumeric'/ PB030 'Personal ID'/ PB040 'Personal cross-sectional weight'/ PB040_F 'Flag'/ PB060 'Personal cross-sectional weight for selected respondent'/ PB060_F 'Flag'/ PB100 'Quarter of the personal interview'/ PB100_F 'Flag'/ PB110 'Year of the personal interview'/ PB110_F 'Flag'/ PB120 'Minutes to complete the personal questionnaire'/ PB120_F 'Flag'/ PB130 'Quarter of birth'/ PB130_F 'Flag'/ PB140 'Year of birth'/ PB140_F 'Flag'/ PB150 'Sex'/ PB150_F 'Flag'/ PB160 'Father ID'/ PB160_F 'Flag'/ PB170 'Mother ID'/ PB170_F 'Flag'/ PB180 'Spouse/partner ID'/ PB180_F 'Flag'/ PB190 'Marital status'/ PB190_F 'Flag'/ PB200 'Consensual union'/ PB200_F 'Flag'/ PB210 'Country of birth alphanumeric'/ PB210_F 'Flag'/ PB220A 'Citizenship 1 alphanumeric'/ PB220A_F 'Flag'/ PE010 'Current education activity'/ PE010_F 'Flag'/ PE020 'ISCED level currently attended'/ PE020_F 'Flag'/ PE030 'Year when highest level of education was attained'/ PE030_F 'Flag' / PE040 'Highest ISCED level attained'/ PE040_F 'Flag'/ PL030 'Self-defined current economic status'/ PL030_F 'Flag'/ PL035 'Worked at least one hour during the previous week'/ PL035_F 'Flag'/ PL015 'Person has ever worked'/ PL015_F 'Flag'/ PL020 'Actively looking for a job'/ PL020_F 'Flag'/ PL025 'Available for work'/ PL025_F 'Flag'/ PL040 'Status in employment'/ PL040_F 'Flag'/ PL050 'Occupation (ISCO-88 (Com))'/ PL050_F 'Flag'/ PL060 'Number of hours usually worked per week in main job'/ PL060_F 'Flag'/ PL080 'Number of months spent in unemployment'/ PL080_F 'Flag'/ PL085 'Number of months spent in retirement'/ PL085_F 'Flag'/ PL087 'Number of months spent studying'/ PL087_F 'Flag'/ PL090 'Number of months spent in other inactivity'/ PL090_F 'Flag'/ PL100 'Total number of hours usually worked in second, third...jobs'/ PL100_F 'Flag'/ PL110 'NACE (Rev 1.1)'/ PL110_F 'Flag'/ PL111 'NACE (Rev 2)'/ PL111_F 'Flag'/ PL120 'Reason for working less than 30 hours'/ PL120_F 'Flag' / PL130 'Number of persons working at the local unit'/ PL130_F 'Flag' / PL140 'Type of contract'/ PL140_F 'Flag' / Pl150 'Managerial Position'/ PL150_F 'Flag' / PL160 'Change of job since last year'/ PL160_F 'Flag' / PL170 'Reason for change'/ PL170_F 'Flag'/ PL180 'Most recent change in the individuals activity status'/ Pl180_F 'Flag' / PL190 'When began regular first job'/ PL190_F 'Flag' / PL200 'Number of years spent in paid work'/ PL200_F 'Flag' / PL210A 'Main activity on January'/ PL210A_F 'Flag'/ PL210B 'Main activity on February'/ PL210B_F 'Flag' / PL210C 'Main activity on March'/ PL210C_F 'Flag'/ PL210D 'Main activity on April'/ PL210D_F 'Flag'/ PL210E 'Main activity on May'/ Pl210E_F 'Flag' / PL210F 'Main activity on June'/ PL210F_F 'Flag' / PL210G 'Main activity on July'/ PL210G_F 'Flag' / PL210H 'Main activity on August'/ PL210H_F 'Flag'/ PL210I 'Main activity on September'/ PL210I_F 'Flag'/ PL210J 'Main activity on October'/ PL210J_F 'Flag'/ PL210K 'Main activity on November'/ PL210K_F 'Flag'/ PL210L 'Main activity on December'/ PL210L_F 'Flag' / PL211A 'Main activity on January'/ PL211A_F 'Flag' / PL211B 'Main activity on February'/ PL211B_F 'Flag' / PL211C 'Main activity on March'/ PL211C_F 'Flag' / PL211D 'Main activity on April'/ PL211D_F 'Flag' / PL211E 'Main activity on May'/ PL211E_F 'Flag' / PL211F 'Main activity on June'/ PL211F_F 'Flag' / PL211G 'Main activity on July'/ PL211G_F 'Flag' / PL211H 'Main activity on August'/ PL211H_F 'Flag' / PL211I 'Main activity on September'/ PL211I_F 'Flag' / PL211J 'Main activity on October'/ PL211J_F 'Flag' / PL211K 'Main activity on November'/ PL211K_F 'Flag' / PL211L 'Main activity on December'/ PL211L_F 'Flag' / PH010 'General health'/ PH010_F 'Flag'/ PH020 'Suffer from a chronic(long-standing) illness or condition'/ PH020_F 'Flag'/ PH030 'Limitation in activities because of health problems'/ PH030_F 'Flag' / PH040 'Unmet need for medical examination or treatment'/ PH040_F 'Flag'/ PH050 'Main reason for unmet need for medical examination or treatment'/ PH050_F 'Flag'/ PH060 'Unmet need for dental examination or treatment'/ PH060_F 'Flag'/ PH070 'Main reason for unmet need for dental examination or treatment'/ PH070_F 'Flag'/ PY010N 'Employee cash or near cash income(net)'/ PY010N_F 'Flag'/ PY010N_I 'Imputation factor'/ PY020N 'Non-Cash employee income(net)'/ PY020N_F 'Flag'/ PY020N_I 'Imputation Factor'/ PY021N 'Company car (in euros)'/ PY021N_F 'Flag'/ PY035N 'Contributions to individual private pension plans(net)'/ PY035N_F 'Flag' / PY035N_I 'Imputation Factor'/ PY050N ' Cash benefits or losses from self-employment(net)'/ PY050N_F 'Flag'/ PY050N_I 'Imputation Factor'/ PY070N 'Value of goods produced by own-consumption (net)'/ PY070n_F 'Flag'/ PY070n_I 'Imputation factor'/ PY080N 'Pension from individual private plans(net)'/ PY080N_F 'Flag'/ PY080N_I 'Imputation factor'/ PY090N 'Unemployment benefits(net)'/ PY090N_F 'Flag'/ PY090N_I 'Imputation Factor'/ PY100N 'Old-age benefits(net)'/ PY100N_F 'Flag'/ PY100N_I 'Imputation Factor'/ PY110N 'Survivors Benefits (net)'/ PY110N_F 'Flag'/ PY110N_I 'Imputation Factor'/ PY120N 'Sickness Benefits(net)'/ PY120N_F 'Flag'/ PY120N_I 'Imputation Factor'/ PY130N 'Disability Benefits(net)'/ PY130N_F 'Flag'/ PY130N_I 'Imputation Factor'/ PY140N 'Education-related allowances'/ PY140N_F 'Flag'/ PY140N_I 'Imputation factor'/ PY010G 'Employee Cash or near cash income(gross)'/ PY010G_F 'Flag'/ PY010G_I 'Imputation Factor'/ PY020G 'Non-Cash employee income(gross)'/ PY020G_F 'Flag'/ PY020G_I 'Imputation Factor'/ PY021G 'Company car (in euros)'/ PY021G_F 'Flag'/ PY030G 'Employers social insurance contribution (in euros)'/ PY030G_F 'Flag'/ PY035G 'Contributions to individual private pension plans(gross)'/ PY035G_F 'Flag'/ PY035G_I 'Imputation Factor'/ PY050G 'Cash benefits or losses from self-employment (gross)'/ PY050G_F 'Flag'/ PY050G_I 'Imputation Factor'/ PY070G 'Value of goods produced by own-consumption(gross)'/ PY070G_F 'Flag'/ PY070G_I 'Imputation Factor'/ PY080G 'Pension from individual private plans(gross)'/ PY080G_F 'Flag'/ PY080G_I 'Imputation Factor'/ PY090G 'Unemployment benefits (gross)'/ PY090G_F 'Flag'/ PY090G_I 'Imputation Factor'/ PY100G 'Old-age benefits(gross)'/ PY100G_F 'Flag'/ PY100G_I 'Imputation Factor'/ PY110G 'Survivor benefit'/ PY110G_F 'Flag'/ PY110G_I 'Imputation Factor'/ PY120G 'Sickness Benefits(gross)'/ PY120G_F 'Flag'/ PY120G_I 'Imputation Factor'/ PY130G 'Disability benefits(gross)'/ PY130G_F 'Flag'/ PY130G_I 'Imputation Factor'/ PY140G 'Education-related allowances(gross)'/ PY140G_F 'Flag'/ PY140G_I 'Imputation factor'/ PY200G 'Gross monthly earnings for employees(gross)'/ PY200G_F 'Flag'/ PY200G_I 'Imputation Factor'/ PY021N_I 'Imputation Factor'/ PY021G_I 'Imputation Factor'/ PY030G_I 'Imputation Factor'/ PY031G 'Optional employer social insurance contributions (in euros)'/ PY031G_F 'Flag'/ PY031G_I 'Imputation Factor'/ PD010 'Mobile Phone'/ PD010_F 'Flag'/ PD020 'Replace worn-out clothes by some new (not second-hand) ones'/ PD020_F 'Flag'/ PD030 'Two pairs of properly fitting shoes (including a pair of all-weather shoes)'/ PD030_F 'Flag'/ PD040 "No. vists to general practitioners (GP's) & spclsts, excl dntsts & ophthlmlgsts"/ PD040_F 'Flag'/ PD050 'Get-together with friends; family (relatvs) for a drink; meal at least once/mnth'/ PD050_F 'Flag'/ PD060 'Regularly participate in a leisure activity such as sport, cinema, concert'/ PD060_F 'Flag'/ PD070 'Spend a small amount of money each week on yourself'/ PD070_F 'Flag'/ PX030 'Household ID'/ PX040 'Selected respondent status'/ PL031 'Self-defined current economic status'/ PL031_F 'Flag'/ PL070 'Number of months spent at full-time work'/ PL070_F 'Flag'/ PL072 'Number of months spent at part-time work'/ PL072_F 'Flag'/ PL073 'Number of months spent at full-time work as employee'/ PL073_F 'Flag'/ PL074 'Number of months spent at part-time work as employee'/ PL074_F 'Flag'/ PL075 'Number of months spent at full-time work as selfemployed (incl family worker)'/ PL075_F 'Flag'/ PL076 'Number of months spent at part-time work as selfemployed (incl family worker)'/ PL076_F 'Flag'/ PL086 'Number of months spent as disabled or/and unfit to work'/ PL086_F 'Flag'/ PL088 'Number of months spent in compulsory military service'/ PL088_F 'Flag'/ PL089 'Number of months spent fulfilling domestic tasks and care responsibilities'/ PL089_F 'Flag'/ PX020 'Age at the end of the income reference period'/ PX050 'Activity status'/ PX010 'Exchange rate' . value labels PB020 'BE' "Belgique" 'BG' "Bulgaria" 'CZ' "Czech Republic" 'DK' "Danmark" 'DE' "Deutschland" 'EE' "Estonia" 'IE' "Ireland" 'EL' "Ellada" 'ES' "Espana" 'FR' "France" 'IT' "Italia" 'CY' "Cyprus" 'LV' "Latvia" 'LT' "Lithuania" 'LU' "Luxembourg" 'HU' "Hungary" 'MT' "Malta" 'NL' "Nederland" 'AT' "Oesterreich" 'PL' "Poland" 'PT' "Portugal" 'RO' "Romania" 'SI' "Slovenia" 'SK' "Slovak Republic" 'FI' "Suomi" 'SE' "Sverige" 'UK' "United Kingdom" 'CH' "Switzerland" 'HR' "Croatia" 'IS' "Iceland" 'NO' "Norway" 'TR' "Turkey"/ PB040_F 1 'Filled'/ PB060_F 1 'Filled' -2 'not defined in var. descript, unique to Luxembourg' -3 'not selected respondent'/ PB100 1 'January,February,March' 2 'April, May, June' 3 'July, August, September' 4 'October, November, December'/ PB100_F 1 'filled' -1 'missing'/ PB110_F 1 'filled' -1 'missing'/ PB120_F 1 'filled' -1 'missing' -2 'na (information only extracted from registers)'/ PB130 1 'January,February,March' 2 'April, May, June' 3 'July, August, September' 4 'October, November, December'/ PB130_F 1 'filled' -1 'missing'/ PB140 1928 "1928 or before" 1929 "PT: 1929 and before" 1933 "MT: 1929-1933" 1938 "MT: 1934-1938" 1943 "MT: 1939-1943" 1948 "MT: 1944-1948" 1953 "MT: 1949-1953" 1958 "MT: 1954-1958" 1963 "MT: 1959-1963" 1968 "MT: 1964-1968" 1973 "MT: 1969-1973" 1978 "MT: 1974-1978" 1983 "MT: 1979-1983" 1988 "MT: 1984-1988" 1993 "MT: 1989-1993"/ PB140_F 1 'filled' -1 'missing'/ PB150 1 'male' 2 'female'/ PB150_F 1 'filled' -1 'missing'/ PB160_F 1 'filled' -1 'missing' -2 'na (father is not a household member)'/ PB170_F 1 'filled' -1 'missing' -2 'na (mother is not a household member)'/ PB180_F 1 'filled' -1 'missing' -2 'not applicable (person has no spouse/partner or spouse/partner is not a household member)'/ PB190 1 'never married' 2 'married' 3 'separated' 4 'widowed' 5 'divorced'/ PB190_F 1 'filled' -1 'missing'/ PB200 1 'yes, on a legal basis' 2 'yes, without a legal basis' 3 'no'/ PB200_F 1 'filled' -1 'missing'/ PB210 'LOC' "same country as country of residence" 'EU' "any uropean country except country of residence" 'OTH' "Any other country" ' ' "missing"/ PB210_F 1 'filled' -1 'missing'/ PB220A 'LOC' "same country as country of residence" 'EU' "any uropean country except country of residence" 'OTH' "Any other country" ' ' "missing"/ PB220A_F 1 'filled' -1 'missing'/ PE010 1 'in education' 2 'not in education'/ PE010_f 1 'filled' -1 'missing'/ PE020 0 'pre-primary education' 1 'primary education' 2 'lower secondary education' 3 '(upper) secondary education' 4 'post-secondary non-tertiary education' 5 '1st stage & 2nd stage of tertiary education'/ PE020_F 1 'filled' -1 'missing' -2 'na (PE010 not=1)'/ PE030_F 1 'filled' -1 'missing' -2 'n.a. (the person has never been in education)'/ PE040 0 'pre-primary education' 1 'primary education' 2 'lower secondary education' 3 '(upper) secondary education' 4 'post-secondary non-tertiary education' 5 '1st & 2nd stage of tertiary education '/ PE040_F 1 'filled' -1 'missing' -2 'n.a. (the person has never been in education)'/ PL030 1 'working full-time' 2 'working part-time' 3 'Unemployed' 4 'Pupil, student, further training, unpaid work experience' 5 'In retirement or in early retirement or has given up business' 6 'Permanently disabled or/and unfit to work' 7 'In compulsory military community or service' 8 'Fulfilling domestic tasks or care responsibilities' 9 'Other inactive person'/ PL030_F 1 'filled' -1 'missing' -5 'missing'/ PL035 1 'yes' 2 'no'/ PL035_F 1 'filled' -1 'missing' -2 'na (person is not employee or MS has other source to calculate the gender pay gap)' -3 'not selected respondent'/ PL015 1 'yes' 2 'no'/ PL015_F 1 'filled' -1 'missing' -2 'na (PL031=1,2,3 or 4)'/ Pl020 1 'Yes' 2 'No'/ PL020_F 1 'filled' -1 'missing' -2 'na (PL031=1,2,3 or 4)'/ PL025 1 'Yes' 2 'No'/ PL025_F 1 'filled' -1 'missing' -2 'na (PL020=2)'/ PL040 1 'Self-employed with employees' 2 'Self-employed without employees' 3 'Employee' 4 'Family worker'/ PL040_F 1 'filled' -1 'missing' -2 'na' /* PL031 not=1,2,3 or 4 and PL015 not=1*// PL050 1 "Armed Forces; MT:11-13 Legislators,senior officials & managers" 2 "MT:21-24 Professionals" 3 "MT:31-34 Technicians and associate professionals" 4 "MT:41-42 Clerks" 5 "MT:51-52 Service workers and shop and market sales workers" 6 "MT:61 Skilled agricultural and fishery workers" 7 "MT:71-74 Craft and related trades workers" 8 "MT:81-83 Plant and machine operators and assemblers" 9 "MT:91-93 Elementary occupations" 10 "MT:10 Armed forces" 11 'Legislators, senior officials and managers' 12 'corporate managers: only for PT, codes 11 & 12 grouped into 13' 13 'managers of small enterprises: only for PT, codes 11 & 12 grouped into 13' 21 'physical, mathematical and engineering professionals' 22 'life science and health professionals' 23 'teaching professionals' 24 'other professionals' 31 'physical and engineering science associate professionals' 32 'life science and helath associate professionals' 33 'Teaching associate professionals' 34 'other associate professionals' 41 'office clerks' 42 'customer services clerks' 51 'personal and protective services workers' 52 'models, salespersons and demonstrators' 61 'skilled agricultural and fishery workers' 71 'extraction and building trades workers' 72 'metal, machinery and related trades workers' 73 'precision, handicraft, craft printing and related trades workers' 74 'other craft and related trades workers' 81 'stationary-plant and related operators' 82 'machine operators and assemblers' 83 'drivers and mobile plant operators' 91 'sales and services elementary occupations' 92 'agricultural, fishery and related labourers' 93 'labourers in ining, construction, manufacturing and transport'/ PL050_F 1 'filled' -1 'missing' -2 'n.a.' /*PL031 not=1,2,3 or 4 and PL015 not=1*// PL060_F 1 'filled' -1 'missing' -2 'n.a.' -6 'Hours varying (even an average over 4 weeks is not possible)'/ PL080_F 1 'filled' -1 'missing'/ PL085_F 1 'filled' -1 'missing'/ PL087_F 1 'filled' -1 'missing'/ PL090_F 1 'filled' -1 'missing'/ Pl100_F 1 'filled' -1 'missing' -2 'n.a. (person does not have a 2nd job or PL031 not =1,2, 3 or 4)'/ PL110_F 1 'filled' -1 'missing' -2 'not applicable (PL031 not=1,2,3 or 4)' -3 'not selected respondent' -5 'missing value of PL110 because PL111 is used'/ PL111_F 1 'filled' -1 'missing' -2 'not applicable (PL031 not=1,2,3 or 4)' -3 'not selected respondent' -5 'missing value of PL111 because PL110 is still used'/ PL120 1 'Undergoing education or training' 2 'Personal illness or disability' 3 'Want to work more hours but cannot find a job(s) or work(s) of more hours' 4 'Do not want to work more hours' 5 'Number of all hours in all job(s) are considered as full-time job' 6 'Housework, looking after children or other persons' 7 'Other reasons'/ PL120_F 1 'filled' -1 'missing' -2 'na' /* PL30 not=1 or 2 or PL060+PL100 not smaller than 30*/ -3 'not selected respondent'/ PL130 11 'between 11 and 19 persons' 12 'between 20 and 49 persons' 13 '50 persons or more' 14 'do not know but less than 11 persons' 15 'do not know but more than 10 persons'/ PL130_F 1 'filled' -1 'missing' -2 'na' -3 'not selected respondent'/ PL140 1 'Permanent job/ work contract of unlimited duration' 2 'temporary job/work contract of limited duration'/ PL140_F 1 'filled' -1 'missing' -2 'n.a. *PL040 not=3*' -3 'not selected respondent' -4 'n.a.:person is employee (PL040 not=3) but has not any contract' / PL150 1 'supervisory' 2 'non-supervisory'/ PL150_F 1 'filled' -1 'missing' -2 'n.a.' -3 'not selected respondent'/ PL160 1 'yes' 2 'no'/ PL160_F 1 'filled' -1 'missing' -2 'na' /* PL30 not=1 or 2 */ -3 'not selected respondent'/ PL170 1 'To take up or seek better job' 2 'End of temporary contract' 3 'Obliged to stop by employer (business closure, redundancy, early retirement, dismissal etc.' 4 'Sale or closure of own/family business' 5 'Child care and care for other dependant' 6 'Partners job required us to move to another area or marriage' 7 'Other reasons'/ Pl170_F 1 'filled' -1 'missing' -2 'na' /* PL60 not=1 */ -3 'not selected respondent'/ PL180 1 'employed-unemployed' 2 'employed-retired' 3 'employed-other inactive' 4 'unemployed-employed' 5 'unemployed - retired' 6 'unemployed - other inactive' 7 'retired - employed' 8 'retired - unemployed' 9 'retired - other inactive' 10 'other inactive - employed' 11 'other inactive - unemployed' 12 'other inactive - retired'/ PL180_F 1 'filled' -1 'missing' -2 'na (no change since last year)' -3 'not selected respondent'/ PL190_F 1 'filled' -1 'missing' -2 'n.a. (person never worked)' -3 'not selected respondent'/ PL200_F 1 'filled' -1 'missing' -2 'na (person never worked)' -3 'not selected respondent'/ PL210A PL210B PL210C PL210D PL210E PL210F PL210G PL210H PL210I PL210J PL210K PL210L 1 'Employee (full-time)' 2 'Employee (part-time)' 3 'Self-employed (full-time)' 4 'Self-employed (part-time)' 5 'Unemployed' 6 'Retired' 7 'Student' 8 'Other inactive' 9 'Compulsory military service'/ PL210A_F PL210B_F PL210C_F PL210D_F PL210E_F PL210F_F PL210G_F PL210H_F PL210I_F PL210J_F PL210K_F PL210L_F 1 'filled' -1 'missing' -3 'not selected respondent' -5 'missing value of PL210 because PL211 is used'/ PL211A PL211B PL211C PL211D PL211E PL211F PL211G PL211H PL211I PL211J PL211K PL211L 1 'Employee working full-time' 2 'Employee working part-time' 3 'Self-employed working full-time (including family worker)' 4 'Self-employed working part-time (including family worker)' 5 'Unemployed' 6 'Pupil, student, further training, unpaid work experience' 7 'In retirement or in early retirement or has given up business' 8 'Permanently disabled or/and unfit to work' 9 'In compulsory military community or service' 10 'Fulfilling domestic tasks and care responsibilities' 11 'Other inactive person'/ PL211A_F PL211B_F PL211C_F PL211D_F PL211E_F PL211F_F PL211G_F PL211H_F PL211I_F PL211J_F PL211K_F PL211L_F 1 'filled' -1 'missing' -3 'not selected respondent' -5 'missing value of PL211 because PL210 is still used'/ PH010 1 'very good' 2 'good' 3 'fair' 4 'bad' 5 'very bad'/ PH010_F 1 'Filled' -1 'missing' -3 'not selected respondent'/ PH020 1 'yes' 2 'no' 8 'do not know (Germany only)'/ PH020_F 1 'Filled' -1 'missing' -3 'not selected respondent'/ PH030 1 'yes, strongly limited' 2 'yes, limited' 3 'no, not limited' 8 'do not know (Germany only)'/ PH030_F 1 'Filled' -1 'missing' -3 'not selected respondent'/ PH040 1 'yes there was at least one occasion when the person really needed examination or treatment but did not' 2 'no, there was no occasion when the person really needed examination or treatment but did not' 8 'do not know (Germany only)'/ PH040_F 1 'Filled' -1 'missing' -3 'not selected respondent'/ PH050 1 'Could not afford to (too expensive)' 2 'Waiting list' 3 'Could not take time because of work, care for children or for others' 4 'Too far to travel/no means of transportation' 5 'Fear of doctor/hospital/examination/treatment' 6 'Wanted to wait and see if problrm got better on its own' 7 'did not know any good doctor or specialist' 8 'other reasons'/ PH050_F 1 'Filled' -1 'missing' -2 'na (Ph040 not=1)' -3 'not selected respondent'/ PH060 1 'yes there was at least one occasion when the person really needed dental examination or treatment but did not' 2 'no, there was no occasion when the person really needed dental examination or treatment but did not' 8 'do not know (Germany only)'/ PH060_F 1 'Filled' -1 'missing' -3 'not selected respondent'/ PH070 1 'Could not afford to (too expensive)' 2 'Waiting list' 3 'Could not take time because of work, care for children or for others' 4 'Too far to travel/no means of transportation' 5 'Fear of doctor(dentist)/hospital/examination/treatment' 6 'Wanted to wait and see if problrm got better on its own' 7 'did not know any dentist' 8 'other reasons'/ PH070_F 1 'Filled' -1 'missing' -2 'na (PH060 not =1)' -3 'not selected respondent'/ PY010N_F 0 'no income' 11 'collec. & recorded net of tax on income at source & social contrib.' 22 'collec. & recorded net of tax on income at source' 31 'collected net of tax on social contrib./recorded net of tax on income & social contrib.' 33 'collected & recorded net of tax on social contrib.' 41 'collected gross/recorded net of tax on income & social contrib.' 42 'collected gross/recorded net of tax on income at source' 43 'collected gross/recorded net of tax on social contrib.' 51 'collected unknown/recorded net of tax on income & social contrib.' 53 'collected unknown/recorded net of tax on social contrib.' 55 'Type of collection & recording: unknown' -1 'missing' -5 'not filled: variable of gross series is filled'/ PY020N_F 0 'no income' 11 'collec. & recorded net of tax on income at source & social contrib.' 22 'collec. & recorded net of tax on income at source' 31 'collected net of tax on social contrib./recorded net of tax on income & social contrib.' 33 'collected & recorded net of tax on social contrib.' 41 'collected gross/recorded net of tax on income & social contrib.' 42 'collected gross/recorded net of tax on income at source' 51 'collected unknown/recorded net of tax on income & social contrib.' 53 'collected unknown/recorded net of tax on social contrib.' 55 'Type of collection & recording: unknown' -1 'missing' -4 'amount included in another component' -5 'not filled: variable of gross series is filled'/ PY021N 0 'no income'/ PY021N_F 0 'no income' 11 'collec. & recorded net of tax on income at source & social contrib.' 22 'collec. & recorded net of tax on income at source' 31 'collected net of tax on social contrib./recorded net of tax on income & social contrib.' 33 'collected & recorded net of tax on social contrib.' 41 'collected gross/recorded net of tax on income & social contrib.' 42 'collected gross/recorded net of tax on income at source' 51 'collected unknown/recorded net of tax on income & social contrib.' 53 'collected unknown/recorded net of tax on social contrib.' 55 'Type of collection & recording: unknown' -1 'missing' -4 'amount included in another component' -5 'not filled: variable of gross series is filled'/ PY035N_F 0 'no contribution' 1 'variable is filled' -1 'missing' -5 'not filled: variable of the gross series is filled'/ PY050N 0 'no income'/ PY050N_F 0 'no income' 11 'collec. & recorded net of tax on income at source & social contrib.' 22 'collec. & recorded net of tax on income at source' 31 'collected net of tax on social contrib./recorded net of tax on income & social contrib.' 32 'collected net of tax on social contrib./recorded net of tax on income at source' 33 'collected & recorded net of tax on social contrib.' 41 'collected gross/recorded net of tax on income & social contrib.' 42 'collected gross/recorded net of tax on income at source' 51 'collected unknown/recorded net of tax on income & social contrib.' 52 'collected unknown/recorded net of tax on income' 53 'collected unknown/recorded net of tax on social contrib.' 55 'Type of collection & recording: unknown' -1 'missing' -4 'amount included in another component' -5 'not filled: variable of gross series is filled'/ PY070N_F 0 'no income' 11 'collec. & recorded net of tax on income at source & social contrib.' 12 'collec. net of tax on income at source & social contrib. /recorded net of tax on income at source' 22 'collec. & recorded net of tax on income at source' 31 'collected net of tax on social contrib./recorded net of tax on income & social contrib.' 33 'collected & recorded net of tax on social contrib.' 41 'collected gross/recorded net of tax on income & social contrib.' 42 'collected gross/recorded net of tax on income at source' 51 'collected unknown/recorded net of tax on income & social contrib.' 52 'collected unknown/recorded net of tax on income' 53 'collected unknown/recorded net of tax on social contrib.' 55 'Type of collection & recording: unknown' -1 'missing' -4 'amount included in another component' -5 'not filled: variable of gross series is filled'/ Py080N_F 0 'no income' 11 'collec. & recorded net of tax on income at source & social contrib.' 22 'collec. & recorded net of tax on income at source' 31 'collected net of tax on social contrib./recorded net of tax on income & social contrib.' 33 'collected & recorded net of tax on social contrib.' 41 'collected gross/recorded net of tax on income & social contrib.' 42 'collected gross/recorded net of tax on income at source' 51 'collected unknown/recorded net of tax on income & social contrib.' 52 'collected unknown/recorded net of tax on income' 53 'collected unknown/recorded net of tax on social contrib.' 55 'Type of collection & recording: unknown' -1 'missing' -4 'amount included in another component' -5 'not filled: variable of gross series is filled'/ PY090N_F 0 'no income' 11 'collec. & recorded net of tax on income at source & social contrib.' 22 'collec. & recorded net of tax on income at source' 31 'collected net of tax on social contrib./recorded net of tax on income & social contrib.' 33 'collected & recorded net of tax on social contrib.' 41 'collected gross/recorded net of tax on income & social contrib.' 42 'collected gross/recorded net of tax on income at source' 43 'collected gross/recorded net of tax on social contrib.' 51 'collected unknown/recorded net of tax on income & social contrib.' 52 'collected unknown/recorded net of tax on income' 53 'collected unknown/recorded net of tax on social contrib.' 55 'Type of collection & recording: unknown' -1 'missing' -4 'amount included in another component' -5 'not filled: variable of gross series is filled'/ PY100N_F 0 'no income' 11 'collec. & recorded net of tax on income at source & social contrib.' 22 'collec. & recorded net of tax on income at source' 31 'collected net of tax on social contrib./recorded net of tax on income & social contrib.' 33 'collected & recorded net of tax on social contrib.' 41 'collected gross/recorded net of tax on income & social contrib.' 42 'collected gross/recorded net of tax on income at source' 51 'collected unknown/recorded net of tax on income & social contrib.' 52 'collected unknown/recorded net of tax on income' 53 'collected unknown/recorded net of tax on social contrib.' 55 'Type of collection & recording: unknown' -1 'missing' -4 'amount included in another component' -5 'not filled: variable of gross series is filled'/ PY110N_F 0 'no income' 11 'collec. & recorded net of tax on income at source & social contrib.' 22 'collec. & recorded net of tax on income at source' 31 'collected net of tax on social contrib./recorded net of tax on income & social contrib.' 33 'collected & recorded net of tax on social contrib.' 41 'collected gross/recorded net of tax on income & social contrib.' 42 'collected gross/recorded net of tax on income at source' 51 'collected unknown/recorded net of tax on income & social contrib.' 52 'collected unknown/recorded net of tax on income' 53 'collected unknown/recorded net of tax on social contrib.' 55 'Type of collection & recording: unknown' -1 'missing' -4 'amount included in another component' -5 'not filled: variable of gross series is filled'/ PY120N_F 0 'no income' 11 'collec. & recorded net of tax on income at source & social contrib.' 22 'collec. & recorded net of tax on income at source' 31 'collected net of tax on social contrib./recorded net of tax on income & social contrib.' 33 'collected & recorded net of tax on social contrib.' 41 'collected gross/recorded net of tax on income & social contrib.' 42 'collected gross/recorded net of tax on income at source' 51 'collected unknown/recorded net of tax on income & social contrib.' 52 'collected unknown/recorded net of tax on income' 53 'collected unknown/recorded net of tax on social contrib.' 55 'Type of collection & recording: unknown' -1 'missing' -4 'amount included in another component' -5 'not filled: variable of gross series is filled'/ PY130N_F 0 'no income' 11 'collec. & recorded net of tax on income at source & social contrib.' 22 'collec. & recorded net of tax on income at source' 31 'collected net of tax on social contrib./recorded net of tax on income & social contrib.' 33 'collected & recorded net of tax on social contrib.' 41 'collected gross/recorded net of tax on income & social contrib.' 42 'collected gross/recorded net of tax on income at source' 51 'collected unknown/recorded net of tax on income & social contrib.' 52 'collected unknown/recorded net of tax on income' 53 'collected unknown/recorded net of tax on social contrib.' 55 'Type of collection & recording: unknown' -1 'missing' -4 'amount included in another component' -5 'not filled: variable of gross series is filled'/ PY140N_F 0 'no income' 11 'collec. & recorded net of tax on income at source & social contrib.' 22 'collec. & recorded net of tax on income at source' 31 'collected net of tax on social contrib./recorded net of tax on income & social contrib.' 33 'collected & recorded net of tax on social contrib.' 41 'collected gross/recorded net of tax on income & social contrib.' 42 'collected gross/recorded net of tax on income at source' 51 'collected unknown/recorded net of tax on income & social contrib.' 52 'collected unknown/recorded net of tax on income' 53 'collected unknown/recorded net of tax on social contrib.' 55 'Type of collection & recording: unknown' -1 'missing' -4 'amount included in another component' -5 'not filled: variable of gross series is filled'/ PY010G_F 0 'no income' 1 'net of tax on income at source and social contribution' 2 'net of tax on income at source and social contribution' 3 'net of tax on social contribution' 4 'gross' 5 'unknown' -1 'missing' -5 'not filled:variable of net series is filled'/ PY020G_F 0 'no income' 1 'net of tax on income at source and social contribution' 2 'net of tax on income at source and social contribution' 3 'net of tax on social contribution' 4 'gross' 5 'unknown' -1 'missing' -4 'amount included in another component' -5 'not filled:variable of net series is filled'/ PY021G 0 'no income'/ PY021G_F -5 'not filled: variable of net series is filled' -4 'amount included in another component' -1 'missing' 0 'no income' 1 'collected net of tax on income at source and social contribution+nc' 2 'collected net of tax on income at source+nc' 3 'collected net of tax on social contributions+nc' 4 'collected gross' 5 'unknown'/ PY030G 0 'no contribution'/ PY030G_F -5 'not filled: variable of net series is filled' -1 'missing' 0 'no income' 1 'income (variable is filled)'/ PY031G 0 'no contribution'/ PY031G_F 0 'no income' 1 'income (variable is filled)' -1 'missing' -5 'not filled: variable of net (..G);gross (..N) series is filled'/ PY035G_F 0 'no contribution' 1 'variable is filled' -1 'missing' -5 'not filled: variable of net series is filled'/ PY050G_F 0 'no income' 1 'collected net of tax on income at source and social contribution+nc' 2 'collected net of tax on income at source+nc' 3 'collected net of tax on social contributions+nc' 4 'collected gross' 5 'unknown' -1 'missing' -5 'not filled:variable of net series is filled'/ PY070G_F 0 'no income' 1 'collected net of tax on income at source and social contribution+nc' 2 'collected net of tax on income at source+nc' 3 'collected net of tax on social contributions+nc' 4 'collected gross' 5 'unknown' -1 'missing' -2 'not defined in variable description; unique to Norway' -5 'not filled:variable of net series is filled'/ PY080G_F 0 'no income' 1 'collected net of tax on income at source and social contribution+nc' 2 'collected net of tax on income at source+nc' 3 'collected net of tax on social contributions+nc' 4 'collected gross' 5 'unknown' -1 'missing' -5 'not filled:variable of net series is filled'/ PY090G_F 0 'no income' 1 'collected net of tax on income at source and social contribution+nc' 2 'collected net of tax on income at source+nc' 3 'collected net of tax on social contributions+nc' 4 'collected gross' 5 'unknown' -1 'missing' -5 'not filled:variable of net series is filled'/ PY100G_F 0 'no income' 1 'collected net of tax on income at source and social contribution+nc' 2 'collected net of tax on income at source+nc' 3 'collected net of tax on social contributions+nc' 4 'collected gross' 5 'unknown' -1 'missing' -4 'amount included in another component' -5 'not filled:variable of net series is filled'/ PY110G_F 0 'no income' 1 'collected net of tax on income at source and social contribution+nc' 2 'collected net of tax on income at source+nc' 3 'collected net of tax on social contributions+nc' 4 'collected gross' 5 'unknown' -1 'missing' -4 'amount included in another component' -5 'not filled:variable of net series is filled'/ PY120G_F 0 'no income' 1 'collected net of tax on income at source and social contribution+nc' 2 'collected net of tax on income at source+nc' 3 'collected net of tax on social contributions+nc' 4 'collected gross' 5 'unknown' -1 'missing' -4 'amount included in another component' -5 'not filled:variable of net series is filled'/ PY130G_F 0 'no income' 1 'collected net of tax on income at source and social contribution+nc' 2 'collected net of tax on income at source+nc' 3 'collected net of tax on social contributions+nc' 4 'collected gross' 5 'unknown' -1 'missing' -4 'amount included in another component' -5 'not filled:variable of net series is filled'/ PY140G_F 0 'no income' 1 'collected net of tax on income at source and social contribution+nc' 2 'collected net of tax on income at source+nc' 3 'collected net of tax on social contributions+nc' 4 'collected gross' 5 'unknown' -1 'missing' -5 'not filled:variable of net series is filled'/ PY200G_F 0 'no income' 1 'collected net of tax on income at source and social contribution+nc' 2 'collected net of tax on income at source+nc' 3 'collected net of tax on social contributions+nc' 4 'collected gross' 5 'unknown' -1 'missing' -2 'na' / PX020 80 '80 and over'/ PX040 1 'current household member aged >=16 (All hhld members aged >=16 are interviewed)' 2 'selected respondent(Only selected hhld member aged >= 16 is interviewed)' 3 'not selected respondent (Only selected hhld member aged >= 16 is interviewed)' 4 'not eligible person (Hhld members aged < 16 at the time of interview)'/ PX050 2 'Employees (SAL)' 3 'Employed persons except employees (NSAL)' 4 'Other employed (when time of SAL and NSAL is > .5 of total time calendar)' 5 'Unemployed' 6 'Retired' 7 'Inactive' 8 'Other inactive (when time of unemployed, retirement & inactivity is > .5 of total time calendar)'/ PL110 'a+b' "Agriculture, hunting/forestry & fishing" 'c+d+e' "Mining and quarrying/manufacturing/electricity, gas & water supply" 'f' "Construction" 'g' "Wholesale & retail trade/repair of motor vehicles, motorcycles & personal & 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 defense, compulsory social security" 'm' "Education" 'n' "Health & social network" 'o+p+q' "other community, soc. & per. service activities, pr. households with employed ps., extra-ter. organiz. & bodys" 'undef' "undefined" ' ' "Missing"/ PL111 'a' "Agriculture,forestry & fishing" 'b - e' "Mining & quarrying, Manufacturing, Electricity, gas, steam & air conditioning supply, Water supply" 'f' "Construction" 'g' "Wholesale retail" 'h' "Transportation & storage" 'i' "Accomodation & food service activities" 'j' "Information & communication " 'k' "Financial & insurance activities " 'l - n' "Real estate, Professionnal, scientific & technical, Administrative & support service activities " 'o' "Public administration & defence, compulsory social security " 'p' "Education " 'q' "Human health & social work activities" 'r - u' "Arts, entertainment & recreation, Other service activities, Activities as household as employer..." ' ' "Missing"/ PD010 1 'Yes' 2 'No, because cannot afford it' 3 'No, for some other reason'/ PD010_F 1 'filled' -1 'missing' -3 'not selected respondent'/ PD020 1 'Yes' 2 'No, because cannot afford it' 3 'No, for some other reason'/ PD020_F 1 'filled' -1 'missing' -3 'not selected respondent'/ PD030 1 'Yes' 2 'No, because cannot afford it' 3 'No, for some other reason'/ PD030_F 1 'filled' -1 'missing' -3 'not selected respondent'/ PD040 1 'Not at all' 2 '1-2 times' 3 '3-5 times' 4 '6-9 times' 5 '10 times or more'/ PD040_F 1 'filled' -1 'missing' -3 'not selected respondent'/ PD050 1 'Yes' 2 'No, because cannot afford it' 3 'No, for some other reason'/ PD050_F 1 'filled' -1 'missing' -3 'not selected respondent'/ PD060 1 'Yes' 2 'No, because cannot afford it' 3 'No, for some other reason'/ PD060_F 1 'filled' -1 'missing' -3 'not selected respondent'/ PD070 1 'Yes' 2 'No, because cannot afford it' 3 'No, for some other reason'/ PD070_F 1 'filled' -1 'missing' -3 'not selected respondent'/ PX040 1 'current household member aged >=16 (All hhld members aged >=16 are interviewed)' 2 'selected respondent(Only selected hhld member aged >= 16 is interviewed)' 3 'not selected respondent (Only selected hhld member aged >= 16 is interviewed)' 4 'not eligible person (Hhld members aged < 16 at the time of interview)'/ PL031 1 'Employee working full-time' 2 'Employee working part-time' 3 'Self-employed working full-time (including family worker)' 4 'Self-employed working part-time (including family worker)' 5 'Unemployed' 6 'Pupil, student, further training, unpaid work experience' 7 'In retirement or in early retirement or has given up business' 8 'Permanently disabled or/and unfit to work' 9 'In compulsory military community or service' 10 'Fulfilling domestic tasks and care responsibilities' 11 'Other inactive person'/ PL031_F 1 'filled' -1 'missing' -5 'missing value of PL031 because PL030 is still used'/ PL070_F 1 'filled' -1 'missing' -5 'missing value because the definition of this variable is not used'/ PL072_F 1 'filled' -1 'missing' -5 'missing value because the definition of this variable is not used'/ PL073_F 1 'filled' -1 'missing' -5 'missing value because the definition of this variable is not used'/ PL074_F 1 'filled' -1 'missing' -5 'missing value because the definition of this variable is not used'/ PL075_F 1 'filled' -1 'missing' -5 'missing value because the definition of this variable is not used'/ PL076_F 1 'filled' -1 'missing' -5 'missing value because the definition of this variable is not used'/ PL086_F 1 'filled' -1 'missing' -5 'missing value because the definition of this variable is not used'/ PL088_F 1 'filled' -1 'missing' -5 'missing value because the definition of this variable is not used'/ PL089_F 1 'filled' -1 'missing' -5 'missing value because the definition of this variable is not used'. SAVE OUTFILE= !QUOTE(!CONCAT(!spss_path,'UDB_c',!i,'09P.sav')). !DOEND. *-------------------------------------------------- Compile and save final file -----------------------------------------------------------------------------------. !LET !firstfile=1. !DO !i !IN (!CC). !IF (!firstfile=1) !THEN GET FILE=!QUOTE(!CONCAT(!spss_path,'UDB_c',!i,'09P.sav')). !LET !firstfile=0. !ELSE ADD FILES FILE=* /FILE=!QUOTE(!CONCAT(!spss_path,'UDB_c',!i,'09P.sav')). !IFEND. !DOEND. SAVE OUTFILE=!QUOTE(!CONCAT(!spss_path,!finalfile,'.sav')). *--------------------------------------------------------Delete single country files -------------------------------------------------------------------------------. !DO !i !IN (!CC). ERASE FILE=!QUOTE(!CONCAT(!spss_path,'UDB_c',!i,'09P.sav')). !DOEND. !ENDDEFINE. *----------------------------------------------------------------- End definition macro ---------------------------------------------------------------. *----------------------------------------------------------------- Invoke macro ---------------------------------------------------------------------------. !C2009_P.