* Encoding: windows-1252. * ==================================================================================================. * EU-SILC panel 2016 - 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 * 2016_panel_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: * L-2016 DIFFERENCES BETWEEN DATA COLLECTED.doc * * ==================================================================================================. * * EU-SILC - panel - 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 licensed under a * Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License * * * Wirth, Heike (2020): 2016_panel_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 ***************************************************************************************. set decimal=DOT. * When using SPSS earlier than V16 you might not use "set unicode" . set unicode=OFF. *----------------------------------------------------------------- Start definition macro ---------------------------------------------------------------. DEFINE !L2016_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\Longitudinal 2005-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 ---------------------------------------------------------. * There should be probably nothing to change below this line. * ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------. *------------------------------------------------------------- Definition of country stubs -----------------------------------------------------------------------. !LET !csvfiles= 'UDB_lAT UDB_lBE UDB_lBG UDB_lCH UDB_lCY UDB_lCZ UDB_lDK UDB_lEE' + ' UDB_lEL UDB_lES UDB_lFI UDB_lFR UDB_lHR UDB_lHU UDB_lIE UDB_lIT UDB_lIS UDB_lLT UDB_lLU UDB_lLV UDB_lMT ' + ' UDB_lNL UDB_lNO UDB_lPL UDB_lPT UDB_lRO UDB_lRS UDB_lSE UDB_lSI UDB_lSK UDB_lUK'. !LET !CC= 'AT BE BG CH CY CZ DK EE EL ES FI FR HR HU IE IS IT LT LU LV MT NL NO PL PT RO RS SE SI SK UK'. !DO !i !IN (!CC) GET DATA /TYPE=TXT /FILE=!QUOTE(!CONCAT(!csv_path,!i,'\2016\UDB_l',!i,'16P.csv')) /ENCODING='Locale' /DELCASE=LINE /DELIMITERS="," /ARRANGEMENT=DELIMITED /FIRSTCASE=2 /IMPORTCASE=ALL /VARIABLES= PB010 F4.0 PB020 A2 PB030 F9.0 PB050 COMMA8.0 PB050_F F1.0 PB080 COMMA1.0 PB080_F F2.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 F9.0 PB160_F F2.0 PB170 F9.0 PB170_F F2.0 PB180 F9.0 PB180_F F2.0 PB190 F1.0 PB190_F F1.0 PB200 F1.0 PB200_F F1.0 PE040 F1.0 PE040_F F1.0 PL020 F1.0 PL020_F F2.0 PL025 F1.0 PL025_F F2.0 PL031 F2.0 PL031_F F1.0 PL040 F1.0 PL040_F F2.0 PL051 F2.0 PL051_F F2.0 PL060 F2.0 PL060_F F2.0 PL140 F1.0 PL140_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 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 PY010N COMMA8.0 PY010N_F F2.0 PY010N_I COMMA9.0 PY020N COMMA7.0 PY020N_F F2.0 PY020N_I COMMA9.0 PY021N COMMA4.0 PY021N_F F2.0 PY021N_I COMMA1.0 PY035N COMMA7.0 PY035N_F F1.0 PY035N_I COMMA9.0 PY050N COMMA8.0 PY050N_F F2.0 PY050N_I COMMA9.0 PY080N COMMA8.0 PY080N_F F2.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 COMMA8.0 PY140N_F F2.0 PY140N_I COMMA9.0 PY010G COMMA8.0 PY010G_F F1.0 PY010G_I COMMA9.0 PY020G COMMA7.0 PY020G_F F1.0 PY020G_I COMMA9.0 PY021G COMMA4.0 PY021G_F F2.0 PY021G_I COMMA1.0 PY030G COMMA8.0 PY030G_F F1.0 PY030G_I F1.0 PY031G COMMA1.0 PY031G_F F1.0 PY031G_I F1.0 PY035G COMMA7.0 PY035G_F F1.0 PY035G_I COMMA9.0 PY050G COMMA8.0 PY050G_F F1.0 PY050G_I COMMA9.0 PY080G COMMA8.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 COMMA8.0 PY140G_F F1.0 PY140G_I COMMA9.0 PY091G COMMA5.0 PY091G_F F2.0 PY092G COMMA5.0 PY092G_F F2.0 PY093G COMMA5.0 PY093G_F F2.0 PY094G COMMA5.0 PY094G_F F2.0 PY101G COMMA5.0 PY101G_F F2.0 PY102G COMMA5.0 PY102G_F F2.0 PY103G COMMA5.0 PY103G_F F2.0 PY104G COMMA5.0 PY104G_F F2.0 PY111G COMMA5.0 PY111G_F F2.0 PY112G COMMA5.0 PY112G_F F2.0 PY113G COMMA5.0 PY113G_F F2.0 PY114G COMMA5.0 PY114G_F F2.0 PY121G COMMA5.0 PY121G_F F2.0 PY122G COMMA5.0 PY122G_F F2.0 PY123G COMMA5.0 PY123G_F F2.0 PY124G F5.0 PY124G_F F2.0 PY131G COMMA5.0 PY131G_F F2.0 PY132G COMMA5.0 PY132G_F F2.0 PY133G COMMA5.0 PY133G_F F2.0 PY134G COMMA5.0 PY134G_F F2.0 PY141G COMMA5.0 PY141G_F F2.0 PY142G COMMA5.0 PY142G_F F2.0 PY143G COMMA5.0 PY143G_F F2.0 PY144G COMMA5.0 PY144G_F F2.0 PX010 COMMA1.0 PX020 F2.0 PX030 F7.0 PX040 F1.0 . Variable labels PB010 'Year of the survey'/ PB020 'Country alphanumeric'/ PB030 'Personal ID'/ PB050 'Personal base weight'/ PB050_F 'Flag'/ PB080 'Personal base weight for selected respondent'/ PB080_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 (MT: lbl3,5=3)'/ PB190_F 'Flag'/ PB200 'Consensual union'/ PB200_F 'Flag'/ PE040 'Highest ISCED level attained'/ PE040_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'/ PL060 'Number of hours usually worked per week in main job'/ PL060_F 'Flag'/ PL140 'Type of contract'/ PL140_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' / 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' / 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'/ 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'/ PY030G_F 'Flag'/ PY030G_I 'Imputation factor'/ PY031G 'Optional employers social insurance contributions'/ PY031G_F 'Flag'/ PY031G_I 'Imputation factor'/ 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'/ 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'/ PY021N_I 'Imputation factor'/ PY021G_I 'Imputation factor'/ PX030 'Household ID'/ PX040 'Selected respondent status'/ PL031 'Self-defined current economic status'/ PL031_F 'Flag'/ PX020 'Age at the end of the income reference period'/ PX010 'Change rate' PL051 'Occupation (ISCO-08 (COM)(MT grouped))' PL051_F 'Flag' PY091G 'Unemployment benefits (contributory and means-tested) '/ PY101G 'Old-age benefits (contributory and means-tested) '/ PY111G 'Survivor’ benefits (contributory and means-tested) '/ PY121G 'Sickness benefits (contributory and means-tested) '/ PY131G 'Disability benefits (contributory and means-tested)'/ PY141G 'Education-related allowances (contributory and means-tested)'/ PY092G 'Unemployment benefits (contributory and non means-tested) '/ PY102G 'Old-age benefits (contributory and non means-tested) '/ PY112G 'Survivor’ benefits (contributory and non means-tested) '/ PY122G 'Sickness benefits (contributory and non means-tested) '/ PY132G 'Disability benefits (contributory and non means-tested) '/ PY142G 'Education-related allowances (contributory and non means-tested)'/ PY093G 'Unemployment benefits (non-contributory and means-tested) '/ PY103G 'Old-age benefits (non-contributory and means-tested) '/ PY113G 'Survivor’ benefits (non-contributory and means-tested) '/ PY123G 'Sickness benefits (non-contributory and means-tested) '/ PY133G 'Disability benefits (non-contributory and means-tested) '/ PY143G 'Education-related allowances (non-contributory and means-tested)'/ PY094G 'Unemployment benefits (non-contributory and non means-tested) '/ PY104G 'Old-age benefits (non-contributory and non means-tested) '/ PY114G 'Survivor’ benefits (non-contributory and non means-tested) '/ PY124G 'Sickness benefits (non-contributory and non means-tested) '/ PY134G 'Disability benefits (non-contributory and non means-tested) '/ PY144G 'Education-related allowances (non-contributory and non means-tested) Domain/Area'/ PY091G_F 'Flag'/ PY101G_F 'Flag'/ PY111G_F 'Flag'/ PY121G_F 'Flag'/ PY131G_F 'Flag'/ PY141G_F 'Flag'/ PY092G_F 'Flag'/ PY102G_F 'Flag'/ PY112G_F 'Flag'/ PY122G_F 'Flag'/ PY132G_F 'Flag'/ PY142G_F 'Flag'/ PY093G_F 'Flag'/ PY103G_F 'Flag'/ PY113G_F 'Flag'/ PY123G_F 'Flag'/ PY133G_F 'Flag'/ PY143G_F 'Flag'/ PY094G_F 'Flag'/ PY104G_F 'Flag'/ PY114G_F 'Flag'/ PY124G_F 'Flag'/ PY134G_F 'Flag'/ PY144G_F 'Flag'. value labels PB020 'BE' "Belgique" 'BG' "Bulgaria" 'CZ' "Czech Republic" 'CH' "Switzerland" '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' "Nederlands" 'AT' "Oesterreich" 'PL' "Poland" 'PT' "Portugal" 'RO' "Romania" 'RS' "Serbia" 'SI' "Slovenia" 'SK' "Slovak Republic" 'FI' "Suomi" 'SE' "Sverige" 'UK' "United Kingdom" 'Ch' "Switzerland" 'HR' "Croatia" 'IS' "Iceland" 'NO' "Norway" 'TR' "Turkey"/ PB050_F 1 'Filled'/ PB080_F 1 'filled' -2 'not applicable (country does not use the selected respondent model)' -3 'not selected respondent (if country uses the selected respondent model)'/ 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 1935 "1935 or before" 1936 "PT: 1936 and before" 1940 "MT: 1936-1940" 1942 "DE: 1942 and before" 1945 "MT: 1941-1945" 1950 "MT: 1946-1950" 1955 "MT: 1951-1955" 1960 "MT: 1956-1960" 1965 "MT: 1961-1965" 1970 "MT: 1966-1970" 1975 "MT: 1971-1975" 1980 "MT: 1976-1980" 1985 "MT: 1981-1985" 1990 "MT: 1986-1990" 1995 "MT: 1991-1995" 2000 "MT: 1996-2000" / 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'/ 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 " 6 "second stage of tertiary education (leading to an advanced research qualification)" 100 "Primary education " 200 "Lower secondary education (SI: Grouping 000,100,200 into 200) " 300 "Upper secondary education (not further specified)(IT: 300-354 grouped into 300)" 34 "General education" 340 "without distinction of direct access to tertiary education" 342 "partial level completion and without direct access to tertiary education" 343 "level completion, without direct access to tertiary education" 344 "level completion, with direct access to tertiary education" 35 "Vocational education" 350 "without distinction of direct access to tertiary education" 352 "partial level completion and without direct access to tertiary education" 353 "level completion, without direct access to tertiary education" 354 "level completion, with direct access to tertiary education" 400 "Post-secondary non-tertiary education (not further specified) (IT: 40,440,450 grouped into 400)" 440 "General education" 450 "Vocational education" 500 "Short cycle tertiary" 600 "Bachelor or equivalent " 700 "Master or equivalent" 800 "Doctorate or equivalent" / PE040_F 1 'filled' -1 'missing' -2 ' Not applicable ((PE040=000 AND PB010 > 2013) OR (PE040_F=-2 AND PB010 < 2014))'/ 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)'/ PL060_F 1 'filled' -1 'missing' -2 'n.a. (PL031 not = 1, 2, 3 or 4)' -6 'Hours varying (even an average over 4 weeks is not possible)'/ 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' / PL160 1 'yes' 2 'no'/ PL160_F 1 'filled' -1 'missing' -2 'not applicable (PL160 not equal to 1)' -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; MT:1-3=1" 2 "employed-retired; MT:4-6=2" 3 "employed-other inactive; MT:7-9=3" 4 "unemployed-employed; MT:10-12=4" 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 'Not applicable (person never worked i.e. (PL031 not equal to 1, 2, 3 or 4 AND PL015 not equal to 1))' -3 'not selected respondent'/ PL200_F 1 'filled' -1 'missing' -2 'na (person never worked (PL031 not = 1, 2, 3 or 4 AND PL015 not= 1))' -3 'not selected respondent'/ 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'/ PY010N_F 0 'no income' 11 'collec. & recorded net of tax on income at source & social contrib.' 13 'collec. & recorded net of tax net of tax on social contrib.' 22 'collec. & recorded net of tax on income at source' 23 'collected net of tax on income at source/ recorded net of tax on social contributions' 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' 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' 56 'collected unknown/recorded net of tax mix' 61 'collected mix (parts of the component collected according to different ways)-Deductive imputation' -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.' 13 'collec. & recorded net of tax net of tax on 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' 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' 56 'collected unknown/recorded net of tax mix' 61 'collected mix (parts of the component collected according to different ways)-Deductive imputation' -1 'missing' -2 'value not defined in data documentation' -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.' 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' 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' 61 'collected mix (parts of the component collected according to different ways)-Deductive imputation' -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." 21 "collec. net of tax and income at source & recorded net of tax at source and soc contrib." 22 "collec. & recorded net of tax on income at source" 23 "collec. net of tax on income at source .recorded net of tax on social contrib." 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" 56 "collected unknown/recorded net of tax mix" 61 "mix/deductive imputation" -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" 23 "collec. net of tax on income at source .recorded net of tax on social contrib." 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" 56 "collected unknown/recorded net of tax mix" 61 "mix/deductive imputation" -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.' 12 'collected net of tax on income at source & social contrib./ recorded net of tax on income at source' 13 'collected net of tax on income at source & social contrib./ recorded net of tax on 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' 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' 56 'collected unknown/recorded net of tax mix' 61 'collected mix (parts of the component collected according to different ways)-Deductive imputation' -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.' 12 'collected net of tax on income at source & social contrib./ recorded net of tax on income at source' 13 'collected net of tax on income at source & social contrib./ recorded net of tax on social contrib.' 21 'collec. net of tax and income at source & recorded net of tax at source and soc 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' 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' 56 'collected unknown/recorded net of tax mix' 61 'collected mix (parts of the component collected according to different ways)-Deductive imputation' -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.' 12 'collected net of tax on income at source & social contrib./ recorded net of tax on income at source' 13 'collected net of tax on income at source & social contrib./ recorded net of tax on social contrib.' 21 'collec. net of tax and income at source & recorded net of tax at source and soc 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' 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' 56 'collected unknown/recorded net of tax mix' 61 'collected mix (parts of the component collected according to different ways)-Deductive imputation' -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" 23 "collec. net of tax on income at source .recorded net of tax on social contrib." 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" 56 'collected unknown/recorded net of tax mix' 61 "mix/deductive imputation" -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.' 12 'collected net of tax on income at source & social contrib./ recorded net of tax on income at source' 13 'collected net of tax on income at source & social contrib./ recorded net of tax on social contrib.' 21 'collec. net of tax and income at source & recorded net of tax at source and soc 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' 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' 56 'collected unknown/recorded net of tax mix' 61 'collected mix (parts of the component collected according to different ways)-Deductive imputation' -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.' 12 'collected net of tax on income at source & social contrib./ recorded net of tax on income at source' 13 'collected net of tax on income at source & social contrib./ recorded net of tax on 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' 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' 56 'collected unknown/recorded net of tax mix' 61 'collected mix (parts of the component collected according to different ways)-Deductive imputation' -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' 6 'collected mix (parts of the component collected according to different ways)' -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' 6 'collected mix (parts of the component collected according to different ways)' -1 'missing' -2 'value not defined in data documentation' -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' 6 'collected mix (parts of the component collected according to different ways)'/ PY030G 0 'no contribution'/ PY030G_F 0 'no income' 1 'income (variable is filled)' -1 'missing' -5 'not filled: variable of net (…..G) / gross (…..N) series 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' 6 'collected mix (parts of the component collected according to different ways)' -1 'missing' -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' 6 'collected mix (parts of the component collected according to different ways)' -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' 6 'collected mix (parts of the component collected according to different ways)' -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' 6 'collected mix (parts of the component collected according to different ways)' -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' 6 'collected mix (parts of the component collected according to different ways)' -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' 6 'collected mix (parts of the component collected according to different ways)' -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' 6 'collected mix (parts of the component collected according to different ways)' -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' 6 'collected mix (parts of the component collected according to different ways)' -1 'missing' -5 'not filled:variable of net series is filled'/ 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'/ PL051 01 'Commissioned armed forces officers' 02 'Non-commissioned armed forces officers' 03 'Armed forces occupations, other ranks' 4 "MT: 41–44 Clerks" 5 "MT: 51–54 Service workers and shop and market sales workers" 6 "MT: 61–63 Skilled agricultural and fishery workers" 7 "MT: 71–75 Craft and related trades workers" 8 "MT: 81–83 Plant and machine operators and assemblers" 9 "MT: 91–96 Elementary occupations" 10 "MT:01 Armed forces" 11 'Chief executives, senior officials and legislators' 12 'Administrative and commercial managers' 13 'Production and specialized services managers' 14 'Hospitality, retail and other services managers' 21 'Science and engineering professionals' 22 'Health professionals' 23 'Teaching professionals' 24 'Business and administration professionals' 25 'Information and communications technology professionals' 26 'Legal, social and cultural professionals' 31 'Science and engineering associate professionals' 32 'Health associate professionals' 33 'Business and administration associate professionals' 34 'Legal, social, cultural and related associate professionals' 35 'Information and communications technicians' 41 'General and keyboard clerks' 42 'Customer services clerks' 43 'Numerical and material recording clerks' 44 'Other clerical support workers' 51 'Personal service workers' 52 'Sales workers' 53 'Personal care workers' 54 'Protective services workers' 61 'Market-oriented skilled agricultural workers' 62 'Market-oriented skilled forestry, fishery and hunting workers' 63 'Subsistence farmers, fishers, hunters and gatherers' 71 'Building and related trades workers, excluding electricians' 72 'Metal, machinery and related trades workers' 73 'Handicraft and printing workers' 74 'Electrical and electronics trades workers' 75 'Food processing, wood working, garment and other craft and related trades workers' 81 'Stationary plant and machine operators' 82 'Assemblers' 83 'Drivers and mobile plant operators' 91 'Cleaners and helpers' 92 'Agricultural, forestry and fishery labourers' 93 'Labourers in mining, construction, manufacturing and transport' 94 'Food preparation assistants' 95 'Street and related sales and service workers' 96 'Refuse workers and other elementary workers'/ PL051_F 1 'filled' -1 'missing' -2 'not applicable (PL031 not = 1, 2, 3 or 4 and PL015 not = 1)'/ PX020 80 '80 and over'/ PY091G 0 "No income"/ PY101G 0 "No income"/ PY111G 0 "No income"/ PY121G 0 "No income"/ PY131G 0 "No income"/ PY141G 0 "No income"/ PY092G 0 "No income"/ PY102G 0 "No income"/ PY112G 0 "No income"/ PY122G 0 "No income"/ PY132G 0 "No income"/ PY142G 0 "No income"/ PY093G 0 "No income"/ PY103G 0 "No income"/ PY113G 0 "No income"/ PY123G 0 "No income"/ PY133G 0 "No income"/ PY143G 0 "No income"/ PY094G 0 "No income"/ PY104G 0 "No income"/ PY114G 0 "No income"/ PY124G 0 "No income"/ PY134G 0 "No income"/ PY144G 0 "No income"/ PY091G_F 2 "filled with mixed components" 1 "filled with only contributory and means-tested components" 0 "No income" -1 "missing" -2 "N/A This scheme doesn't exist at national level" -7 "N/A PB010 < 2014"/ PY101G_F 2 "filled with mixed components" 1 "filled with only contributory and means-tested components" 0 "No income" -1 "missing" -2 "N/A This scheme doesn't exist at national level" -7 "N/A PB010 < 2014"/ PY111G_F 2 "filled with mixed components" 1 "filled with only contributory and means-tested components" 0 "No income" -1 "missing" -2 "N/A This scheme doesn't exist at national level" -7 "N/A PB010 < 2014"/ PY121G_F 2 "filled with mixed components" 1 "filled with only contributory and means-tested components" 0 "No income" -1 "missing" -2 "N/A This scheme doesn't exist at national level" -7 "N/A PB010 < 2014"/ PY131G_F 2 "filled with mixed components" 1 "filled with only contributory and means-tested components" 0 "No income" -1 "missing" -2 "N/A This scheme doesn't exist at national level" -7 "N/A PB010 < 2014"/ PY141G_F 2 "filled with mixed components" 1 "filled with only contributory and means-tested components" 0 "No income" -1 "missing" -2 "N/A This scheme doesn't exist at national level" -7 "N/A PB010 < 2014"/ PY092G_F 2 "filled with mixed components" 1 "filled with only contributory and means-tested components" 0 "No income" -1 "missing" -2 "N/A This scheme doesn't exist at national level" -7 "N/A PB010 < 2014"/ PY102G_F 2 "filled with mixed components" 1 "filled with only contributory and means-tested components" 0 "No income" -1 "missing" -2 "N/A This scheme doesn't exist at national level" -7 "N/A PB010 < 2014"/ PY112G_F 2 "filled with mixed components" 1 "filled with only contributory and means-tested components" 0 "No income" -1 "missing" -2 "N/A This scheme doesn't exist at national level" -7 "N/A PB010 < 2014"/ PY122G_F 2 "filled with mixed components" 1 "filled with only contributory and means-tested components" 0 "No income" -1 "missing" -2 "N/A This scheme doesn't exist at national level" -7 "N/A PB010 < 2014"/ PY132G_F 2 "filled with mixed components" 1 "filled with only contributory and means-tested components" 0 "No income" -1 "missing" -2 "N/A This scheme doesn't exist at national level" -7 "N/A PB010 < 2014"/ PY142G_F 2 "filled with mixed components" 1 "filled with only contributory and means-tested components" 0 "No income" -1 "missing" -2 "N/A This scheme doesn't exist at national level" -7 "N/A PB010 < 2014"/ PY093G_F 2 "filled with mixed components" 1 "filled with only contributory and means-tested components" 0 "No income" -1 "missing" -2 "N/A This scheme doesn't exist at national level" -7 "N/A PB010 < 2014"/ PY103G_F 2 "filled with mixed components" 1 "filled with only contributory and means-tested components" 0 "No income" -1 "missing" -2 "N/A This scheme doesn't exist at national level" -7 "N/A PB010 < 2014"/ PY113G_F 2 "filled with mixed components" 1 "filled with only contributory and means-tested components" 0 "No income" -1 "missing" -2 "N/A This scheme doesn't exist at national level" -7 "N/A PB010 < 2014"/ PY123G_F 2 "filled with mixed components" 1 "filled with only contributory and means-tested components" 0 "No income" -1 "missing" -2 "N/A This scheme doesn't exist at national level" -7 "N/A PB010 < 2014"/ PY133G_F 2 "filled with mixed components" 1 "filled with only contributory and means-tested components" 0 "No income" -1 "missing" -2 "N/A This scheme doesn't exist at national level" -7 "N/A PB010 < 2014"/ PY143G_F 2 "filled with mixed components" 1 "filled with only contributory and means-tested components" 0 "No income" -1 "missing" -2 "N/A This scheme doesn't exist at national level" -7 "N/A PB010 < 2014"/ PY094G_F 2 "filled with mixed components" 1 "filled with only contributory and means-tested components" 0 "No income" -1 "missing" -2 "N/A This scheme doesn't exist at national level" -7 "N/A PB010 < 2014"/ PY104G_F 2 "filled with mixed components" 1 "filled with only contributory and means-tested components" 0 "No income" -1 "missing" -2 "N/A This scheme doesn't exist at national level" -7 "N/A PB010 < 2014"/ PY114G_F 2 "filled with mixed components" 1 "filled with only contributory and means-tested components" 0 "No income" -1 "missing" -2 "N/A This scheme doesn't exist at national level" -7 "N/A PB010 < 2014"/ PY124G_F 2 "filled with mixed components" 1 "filled with only contributory and means-tested components" 0 "No income" -1 "missing" -2 "N/A This scheme doesn't exist at national level" -7 "N/A PB010 < 2014"/ PY134G_F 2 "filled with mixed components" 1 "filled with only contributory and means-tested components" 0 "No income" -1 "missing" -2 "N/A This scheme doesn't exist at national level" -7 "N/A PB010 < 2014"/ PY144G_F 2 "filled with mixed components" 1 "filled with only contributory and means-tested components" 0 "No income" -1 "missing" -2 "N/A This scheme doesn't exist at national level" -7 "N/A PB010 < 2014". SAVE OUTFILE= !QUOTE(!CONCAT(!spss_path,'UDB_l',!i,'16P.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,'16P.sav')). !LET !firstfile=0. !ELSE ADD FILES FILE=* /FILE=!QUOTE(!CONCAT(!spss_path,!filestub,'16P.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,'16P.sav')). !DOEND. !ENDDEFINE. *----------------------------------------------------------------- End definition macro ---------------------------------------------------------------. *----------------------------------------------------------------- Invoke macro ---------------------------------------------------------------------------. !L2016_P.