* Encoding: windows-1252. * ==================================================================================================. * EU-SILC Cross 2007 - release 2020-03 / DOI: https://doi.org/10.2907/EUSILC2004-2018V.1 * * When publishing statistics derived from the EU-SILC UDB, please state as source: * "EU-SILC UDB - version of 2020-03" * * SPSS Command Syntax File * 2007_cross_eu_silc_p_ver_2020_03.sps * * (c) GESIS 2020-11-11 * * PLEASE NOTE * For Differences between data as described in the guidelines * and the anonymised user database as well as country specific anonymisation measures see: * C-2007 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_c*country_stub*.csv * * This SPSS-File is licensed under a * Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License * * * Wirth, Heike (2020): 2007_cross_eu_silc_p_ver_2020_03.sps. * SPSS-Syntax for transforming EU-SILC csv data into an SPSS-Systemfile. * * https://www.gesis.org/gml/european-microdata/eu-silc/ * * Contact: heike.wirth@gesis.org * ==================================================================================================. * The csv file for Greece is not appropriately named. The following command changes the name on the hardrive in order for the macro to work properly. * The renaming is permanent and needs only to be executed once for every file. * Change csv_data_path_EL to the path where the csv file for Greece is stored. HOST COMMAND =['RENAME "csv_data_path_EL\UDB_cGR07P.csv" UDB_cEL07P.csv']. *----------------------------------------------------------------- Start definition macro ---------------------------------------------------------------. DEFINE !C2007_nP (). * *-------------------------------------------------------- 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-2016\); * 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 ---------------------------------------------------------. !LET !csvfiles= 'UDB_cAT UDB_cBE UDB_cBG UDB_cCH UDB_cCY UDB_cCZ UDB_cDE UDB_cDK UDB_cEE UDB_cEL' + ' UDB_cES UDB_cFI UDB_cFR UDB_cHU UDB_cIE UDB_cIS UDB_cIT UDB_cLT UDB_cLU UDB_cLV UDB_cMT' + ' UDB_cNL UDB_cNO UDB_cPL UDB_cPT UDB_cRO UDB_cSE UDB_cSI UDB_cSK UDB_cUK'. !LET !CC1= 'BG CH CZ ES FR HU IS IT LT LU LV MT NO RO'. !DO !i !IN (!CC1) SET DECIMAL DOT. GET DATA /TYPE=TXT /FILE=!QUOTE(!CONCAT(!csv_path,!i,'\2007\UDB_c',!i,'07P.csv')) /ENCODING='Locale' /DELCASE=LINE /DELIMITERS="," /ARRANGEMENT=DELIMITED /FIRSTCASE=2 /IMPORTCASE=ALL /VARIABLES= PB010 F4 PB020 A2 PB030 F6 PB040 F10.5 PB040_F F1 PB060 F1 PB060_F F2 PB100 F1 PB100_F F2 PB110 F4 PB110_F F1 PB120 F2 PB120_F F2 PB130 F1 PB130_F F1 PB140 F4 PB140_F F1 PB150 F1 PB150_F F1 PB160 F6 PB160_F F2 PB170 F6 PB170_F F2 PB180 F6 PB180_F F2 PB190 F1 PB190_F F1 PB200 F1 PB200_F F1 PB210 A3 PB210_F F1 PB220A A3 PB220A_F F1 PE010 F1 PE010_F F2 PE020 F1 PE020_F F2 PE030 F4 PE030_F F2 PE040 F1 PE040_F F2 PL030 F1 PL030_F F2 PL035 F1 PL035_F F2 PL015 F1 PL015_F F2 PL020 F1 PL020_F F2 PL025 F1 PL025_F F2 PL040 F1 PL040_F F2 PL050 F2 PL050_F F2 PL060 F2 PL060_F F2 PL070 F2 PL070_F F1 PL072 F2 PL072_F F1 PL080 F2 PL080_F F1 PL085 F2 PL085_F F1 PL087 F2 PL087_F F1 PL090 F2 PL090_F F1 PL100 F2 PL100_F F2 PL110_F F2 PL120 F1 PL120_F F2 PL130 F2 PL130_F F2 PL140 F1 PL140_F F2 PL150 F1 PL150_F F2 PL160 F1 PL160_F F1 PL170 F1 PL170_F F1 PL180 F1 PL180_F F1 PL190 F1 PL190_F F1 PL200 F1 PL200_F F1 PL210A F1 PL210A_F F1 PL210B F1 PL210B_F F1 PL210C F1 PL210C_F F1 PL210D F1 PL210D_F F1 PL210E F1 PL210E_F F1 PL210F F1 PL210F_F F1 PL210G F1 PL210G_F F1 PL210H F1 PL210H_F F1 PL210I F1 PL210I_F F1 PL210J F1 PL210J_F F1 PL210K F1 PL210K_F F1 PL210L F1 PL210L_F F1 PH010 F1 PH010_F F2 PH020 F1 PH020_F F2 PH030 F1 PH030_F F2 PH040 F1 PH040_F F2 PH050 F1 PH050_F F2 PH060 F1 PH060_F F2 PH070 F1 PH070_F F2 PY010N F8.2 PY010N_F F2 PY010N_I F7.5 PY020N F7.2 PY020N_F F2 PY020N_I F7.5 PY021N F7.2 PY021N_F F2 PY035N F7.2 PY035N_F F1 PY035N_I F7.5 PY050N F8.2 PY050N_F F2 PY050N_I F8.5 PY070N F7.2 PY070N_F F2 PY070N_I F7.5 PY080N F6.2 PY080N_F F2 PY080N_I F7.5 PY090N F7.2 PY090N_F F2 PY090N_I F7.5 PY100N F7.2 PY100N_F F2 PY100N_I F7.5 PY110N F7.2 PY110N_F F2 PY110N_I F7.5 PY120N F7.2 PY120N_F F2 PY120N_I F7.5 PY130N F7.2 PY130N_F F2 PY130N_I F7.5 PY140N F7.2 PY140N_F F2 PY140N_I F7.5 PY010G F8.2 PY010G_F F1 PY010G_I F7.5 PY020G F7.2 PY020G_F F1 PY020G_I F7.5 PY021G F7.2 PY021G_F F1 PY030G F7.2 PY030G_F F1 PY035G F7.2 PY035G_F F1 PY035G_I F7.5 PY050G F8.2 PY050G_F F1 PY050G_I F8.5 PY070G F7.2 PY070G_F F1 PY070G_I F7.5 PY080G F6.2 PY080G_F F1 PY080G_I F7.5 PY090G F7.2 PY090G_F F1 PY090G_I F7.5 PY100G F7.2 PY100G_F F1 PY100G_I F7.5 PY110G F7.2 PY110G_F F1 PY110G_I F7.5 PY120G F7.2 PY120G_F F1 PY120G_I F7.5 PY130G F7.2 PY130G_F F1 PY130G_I F7.5 PY140G F7.2 PY140G_F F1 PY140G_I F7.5 PY200G F7.2 PY200G_F F2 PY200G_I F8.5 PX030 F4 PX040 F1 PY021N_I F7.5 PY021G_I F7.5 PY030G_I F7.5 lastup F1 lasttime F1 PX020 F2 PX050 F1 C_BIRTH F1 CIT_SHIP F1 res_wgt F14.9 PX010 F6.4 ppp F8.6 PY031G F1 PL110 A5. DELETE VARIABLES lastup lasttime C_BIRTH CIT_SHIP res_wgt ppp . SAVE OUTFILE= !QUOTE(!CONCAT(!spss_path,'UDB_c',!i,'07P.sav')). !DOEND. !LET !CC= 'AT BE CY DE DK EE EL FI IE NL PL PT SE SI SK UK'. !DO !i !IN (!CC) SET DECIMAL DOT. GET DATA /TYPE=TXT /FILE=!QUOTE(!CONCAT(!csv_path,!i,'\2007\UDB_c',!i,'07P.csv')) /ENCODING='Locale' /DELCASE=LINE /DELIMITERS="," /ARRANGEMENT=DELIMITED /FIRSTCASE=2 /IMPORTCASE=ALL /VARIABLES= PB010 F4 PB020 A2 PB030 F6 PB040 F10.5 PB040_F F1 PB060 F1 PB060_F F2 PB100 F1 PB100_F F2 PB110 F4 PB110_F F1 PB120 F2 PB120_F F2 PB130 F1 PB130_F F1 PB140 F4 PB140_F F1 PB150 F1 PB150_F F1 PB160 F6 PB160_F F2 PB170 F6 PB170_F F2 PB180 F6 PB180_F F2 PB190 F1 PB190_F F1 PB200 F1 PB200_F F1 PB210 A3 PB210_F F1 PB220A A3 PB220A_F F1 PE010 F1 PE010_F F2 PE020 F1 PE020_F F2 PE030 F4 PE030_F F2 PE040 F1 PE040_F F2 PL030 F1 PL030_F F2 PL035 F1 PL035_F F2 PL015 F1 PL015_F F2 PL020 F1 PL020_F F2 PL025 F1 PL025_F F2 PL040 F1 PL040_F F2 PL050 F2 PL050_F F2 PL060 F2 PL060_F F2 PL070 F2 PL070_F F1 PL072 F2 PL072_F F1 PL080 F2 PL080_F F1 PL085 F2 PL085_F F1 PL087 F2 PL087_F F1 PL090 F2 PL090_F F1 PL100 F2 PL100_F F2 PL110_F F2 PL120 F1 PL120_F F2 PL130 F2 PL130_F F2 PL140 F1 PL140_F F2 PL150 F1 PL150_F F2 PL160 F1 PL160_F F1 PL170 F1 PL170_F F1 PL180 F1 PL180_F F1 PL190 F1 PL190_F F1 PL200 F1 PL200_F F1 PL210A F1 PL210A_F F1 PL210B F1 PL210B_F F1 PL210C F1 PL210C_F F1 PL210D F1 PL210D_F F1 PL210E F1 PL210E_F F1 PL210F F1 PL210F_F F1 PL210G F1 PL210G_F F1 PL210H F1 PL210H_F F1 PL210I F1 PL210I_F F1 PL210J F1 PL210J_F F1 PL210K F1 PL210K_F F1 PL210L F1 PL210L_F F1 PH010 F1 PH010_F F2 PH020 F1 PH020_F F2 PH030 F1 PH030_F F2 PH040 F1 PH040_F F2 PH050 F1 PH050_F F2 PH060 F1 PH060_F F2 PH070 F1 PH070_F F2 PY010N F8.2 PY010N_F F2 PY010N_I F7.5 PY020N F7.2 PY020N_F F2 PY020N_I F7.5 PY021N F7.2 PY021N_F F2 PY035N F7.2 PY035N_F F1 PY035N_I F7.5 PY050N F8.2 PY050N_F F2 PY050N_I F8.5 PY070N F7.2 PY070N_F F2 PY070N_I F7.5 PY080N F6.2 PY080N_F F2 PY080N_I F7.5 PY090N F7.2 PY090N_F F2 PY090N_I F7.5 PY100N F7.2 PY100N_F F2 PY100N_I F7.5 PY110N F7.2 PY110N_F F2 PY110N_I F7.5 PY120N F7.2 PY120N_F F2 PY120N_I F7.5 PY130N F7.2 PY130N_F F2 PY130N_I F7.5 PY140N F7.2 PY140N_F F2 PY140N_I F7.5 PY010G F8.2 PY010G_F F1 PY010G_I F7.5 PY020G F7.2 PY020G_F F1 PY020G_I F7.5 PY021G F7.2 PY021G_F F1 PY030G F7.2 PY030G_F F1 PY035G F7.2 PY035G_F F1 PY035G_I F7.5 PY050G F8.2 PY050G_F F1 PY050G_I F8.5 PY070G F7.2 PY070G_F F1 PY070G_I F7.5 PY080G F6.2 PY080G_F F1 PY080G_I F7.5 PY090G F7.2 PY090G_F F1 PY090G_I F7.5 PY100G F7.2 PY100G_F F1 PY100G_I F7.5 PY110G F7.2 PY110G_F F1 PY110G_I F7.5 PY120G F7.2 PY120G_F F1 PY120G_I F7.5 PY130G F7.2 PY130G_F F1 PY130G_I F7.5 PY140G F7.2 PY140G_F F1 PY140G_I F7.5 PY200G F7.2 PY200G_F F2 PY200G_I F8.5 PX030 F4 PX040 F1 PY021N_I F7.5 PY021G_I F7.5 PY030G_I F7.5 PX020 F2 PX050 F1 PX010 F6.4 PY031G F1 PL110 A5. Variable labels PB010 'Year of the Survey'/ PB020 'Country'/ 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 interview'/ 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'/ PB210_F 'Flag'/ PB220A 'Citizenship 1'/ 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'/ PL070 'Number of months spent at full-time work'/ PL070_F 'Flag'/ PL072 'Number of months spent at part-time work'/ PL072_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 inactively'/ PL090_F 'Flag'/ PL100 'Total number of hours usually worked in second, third...jobs'/ PL100_F 'Flag'/ PL110_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' / 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 mopnthly earnings for employees(gross)'/ PY200G_F 'Flag'/ PY200G_I 'Imputation Factor'/ PX030 'Household ID'/ PX040 'Respondent status'/ PY021N_I 'Imputation Factor'/ PY021G_I 'Imputation Factor'/ PY030G_I 'Imputation Factor'/ PX020 'Age at the end of the income reference period'/ PX050 'Activity status - inconsistent values'/ PX010 'Exchange rate'/ PY031G 'Optional employer social insurance contributions (in euros)'/ PL110 'NACE (Rev.1.1)'. value labels PB020 'BE' "Belgique" 'DK' "Danmark" 'DE' "Deutschland" 'GR' "Ellada" 'ES' "Espana" 'FR' "France" 'IE' "Ireland" 'IT' "Italia" 'LU' "Luxembourg" 'NL' "Nederland" 'AT' "Oesterreich" 'PT' "Portugal" 'FI' "Suomi" 'SE' "Sverige" 'UK' "United Kingdom" 'BG' "Bulgaria" 'CY' "Cyprus" 'CZ' "Czech Republic" 'EE' "Estonia" 'HU' "Hungary" 'LV' "Latvia" 'LT' "Lithuania" 'MT' "Malta" 'PL' "Poland" 'RO' "Romania" 'SK' "Slovak Republic" 'SI' "Slovenia" 'IS' "Iceland" 'NO' "Norway" 'CH' "Switzerland"/ 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 1926 '1926 & before'/ 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'/ 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 (PL030=1 or 2)' -3 'not selected respondent'/ Pl020 1 'Yes' 2 'No'/ PL020_F 1 'filled' -1 'missing' -2 'na (PL030=1 or 2)'/ 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' /* PL030 not=1 or 2 and PL015 not=1 and PL035 not=1*// PL050 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' 01 'armed forces'/ PL050_F 1 'filled' -1 'missing' -2 'n.a.' /*PL030 not=1 or 2 and PL015 not=1 and PL035 not=1*// PL060_F 1 'filled' -1 'missing' -2 'n.a.' -6 'Hours varying'/ PL070_F 1 'filled' -1 'missing'/ PL072_F 1 'filled' -1 'missing'/ 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 PL030 not =1 or 2)'/ PL110_F 1 'filled' -1 'missing' -2 'na' /*PL030 not=1 and PL035 not =1*/ -3 'not selected respondent'/ 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 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 1 'filled' -1 'missing' -3 'not selected respondent'/ PL210B 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'/ PL210B_F 1 'filled' -1 'missing' -3 'not selected respondend'/ PL210C 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'/ PL210C_f 1 'filled' -1 'missing' -3 'not selected respondent'/ PL210D 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'/ PL210D_F 1 'filled' -1 'missing' -3 'not selected respondent'/ PL210E 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'/ PL210E_F 1 'filled' -1 'missing' -3 'not selected respondent'/ PL210F 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'/ PL210F_F 1 'filled' -1 'missing' -3 'not selected respondent'/ PL210G 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'/ PL210G_F 1 'filled' -1 'missing' -3 'not selected respondent'/ PL210H 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'/ PL210H_F 1 'filled' -1 'missing' -3 'not selected respondent'/ PL210I 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'/ PL210I_F 1 'filled' -1 'missing' -3 'not selected respondent'/ PL210J 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'/ PL210J_F 1 'filled' -1 'missing' -3 'not selected respondent'/ PL210K 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'/ PL210K_F 1 'filled' -1 'missing' -3 'not selected respondent'/ 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'/ PL210L_F 1 'filled' -1 'missing' -3 'not selected respondent'/ 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'/ PH020_F 1 'Filled' -1 'missing' -3 'not selected respondent'/ PH030 1 'yes, strongly limited' 2 'yes, limited' 3 'no, not limited'/ 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'/ 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'/ 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.' 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.' 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'/ 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 1 'EMP/TOT > 0.5' 2 'UNP/TOT > 0.5' 3 'RET/TOT > 0.5' 4 'OIN/TOT > 0.5'/ 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". SAVE OUTFILE= !QUOTE(!CONCAT(!spss_path,'UDB_c',!i,'07P.sav')). !DOEND. *-------------------------------------------------- Compile and save final file -----------------------------------------------------------------------------------. !LET !firstfile=1. !DO !filestub !IN (!csvfiles). !IF (!firstfile=1) !THEN GET FILE=!QUOTE(!CONCAT(!spss_path,!filestub,'07P.sav')). !LET !firstfile=0. !ELSE ADD FILES FILE=* /FILE=!QUOTE(!CONCAT(!spss_path,!filestub,'07P.sav')). !IFEND. !DOEND. SAVE OUTFILE=!QUOTE(!CONCAT(!spss_path,!finalfile,'.sav')). *--------------------------------------------------------Delete single country files -------------------------------------------------------------------------------. !DO !filestub !IN (!csvfiles). ERASE FILE=!QUOTE(!CONCAT(!spss_path,!filestub,'07P.sav')). !DOEND. !ENDDEFINE. *----------------------------------------------------------------- End definition macro ---------------------------------------------------------------. *----------------------------------------------------------------- Invoke macro ---------------------------------------------------------------------------. !C2007_nP.