* Encoding: windows-1252. * ==================================================================================================. * EU-SILC Cross 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_cross_eu_silc_h_ver_2020_03.sps * * (c) GESIS 2020-12-15 * * 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-2016 DIFFERENCES BETWEEN DATA COLLECTED.doc * * ==================================================================================================. * * EU-SILC - Cross - Household 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): 2016_cross_eu_silc_h_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 !C2016_H (). *-------------------------------------------------------- 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 ---------------------------------------------------------. * There should be probably nothing to change below this line. * ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------. *------------------------------------------------------------- Definition of country stubs -----------------------------------------------------------------------. !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_cHR 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_cRS UDB_cSE UDB_cSI UDB_cSK UDB_cUK'. !LET !CC= 'AT BE BG CH CY CZ DE 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_c',!i,'16H.csv')) /ENCODING='Locale' /DELCASE=LINE /DELIMITERS="," /ARRANGEMENT=DELIMITED /FIRSTCASE=2 /IMPORTCASE=ALL /VARIABLES= HB010 F4.0 HB020 A2 HB030 F7.0 HB050 F1.0 HB050_F F1.0 HB060 F4.0 HB060_F F1.0 HB070 F9.0 HB070_F F1.0 HB080 F9.0 HB080_F F1.0 HB090 F9.0 HB090_F F2.0 HB100 F2.0 HB100_F F1.0 HY010 COMMA9.0 HY010_F F1.0 HY010_I COMMA9.0 HY020 COMMA9.0 HY020_F F1.0 HY020_I COMMA9.0 HY022 COMMA9.0 HY022_F F1.0 HY022_I COMMA9.0 HY023 COMMA9.0 HY023_F F1.0 HY023_I COMMA9.0 HY030N COMMA7.0 HY030N_F F1.0 HY040N COMMA8.0 HY040N_F F2.0 HY040N_I COMMA9.0 HY050N COMMA8.0 HY050N_F F2.0 HY050N_I COMMA9.0 HY060N COMMA7.0 HY060N_F F2.0 HY060N_I COMMA9.0 HY070N COMMA7.0 HY070N_F F2.0 HY070N_I COMMA9.0 HY080N COMMA8.0 HY080N_F F2.0 HY080N_I COMMA9.0 HY081N COMMA8.0 HY081N_F F2.0 HY081N_I F9.0 HY090N COMMA7.0 HY090N_F F2.0 HY090N_I COMMA9.0 HY100N COMMA7.0 HY100N_F F1.0 HY100N_I COMMA8.0 HY110N COMMA7.0 HY110N_F F2.0 HY110N_I COMMA9.0 HY120N COMMA4.0 HY120N_F F1.0 HY120N_I COMMA1.0 HY130N COMMA8.0 HY130N_F F2.0 HY130N_I COMMA9.0 HY131N COMMA8.0 HY131N_F F2.0 HY131N_I COMMA9.0 HY140N COMMA9.0 HY140N_F F2.0 HY140N_I COMMA8.0 HY145N COMMA8.0 HY145N_F F1.0 HY145N_I COMMA9.0 HY170N COMMA9.0 HY170N_F F1.0 HY170N_I F1.0 HY030G COMMA7.0 HY030G_F F1.0 HY040G COMMA8.0 HY040G_F F1.0 HY040G_I COMMA9.0 HY050G COMMA8.0 HY050G_F F1.0 HY050G_I COMMA9.0 HY060G COMMA7.0 HY060G_F F1.0 HY060G_I COMMA9.0 HY070G COMMA7.0 HY070G_F F1.0 HY070G_I COMMA9.0 HY080G COMMA8.0 HY080G_F F1.0 HY080G_I COMMA9.0 HY081G COMMA8.0 HY081G_F F1.0 HY081G_I F9.0 HY090G COMMA7.0 HY090G_F F1.0 HY090G_I COMMA9.0 HY100G COMMA7.0 HY100G_F F1.0 HY100G_I COMMA8.0 HY110G COMMA7.0 HY110G_F F1.0 HY110G_I COMMA9.0 HY120G COMMA4.0 HY120G_F F1.0 HY120G_I COMMA9.0 HY130G COMMA8.0 HY130G_F F1.0 HY130G_I COMMA9.0 HY131G COMMA8.0 HY131G_F F1.0 HY131G_I COMMA9.0 HY140G COMMA9.0 HY140G_F F1.0 HY140G_I COMMA9.0 HY170G COMMA8.0 HY170G_F F1.0 HY170G_I F1.0 HY051G COMMA4.0 HY051G_F F1.0 HY052G COMMA4.0 HY052G_F F1.0 HY053G COMMA6.0 HY053G_F F1.0 HY054G COMMA8.0 HY054G_F F1.0 HY061G COMMA4.0 HY061G_F F1.0 HY062G COMMA4.0 HY062G_F F1.0 HY063G COMMA7.0 HY063G_F F1.0 HY064G COMMA4.0 HY064G_F F1.0 HY071G COMMA4.0 HY071G_F F1.0 HY072G COMMA4.0 HY072G_F F1.0 HY073G COMMA7.0 HY073G_F F1.0 HY074G F4.0 HY074G_F F1.0 HS011 F1.0 HS011_F F2.0 HS021 F1.0 HS021_F F1.0 HS031 F1.0 HS031_F F2.0 HS040 F1.0 HS040_F F1.0 HS050 F1.0 HS050_F F1.0 HS060 F1.0 HS060_F F1.0 HS070 F1.0 HS070_F F1.0 HS080 F1.0 HS080_F F1.0 HS090 F1.0 HS090_F F1.0 HS100 F1.0 HS100_F F1.0 HS110 F1.0 HS110_F F1.0 HS120 F1.0 HS120_F F1.0 HS130 COMMA7.0 HS130_F F1.0 HS140 F1.0 HS140_F F1.0 HS150 F1.0 HS150_F F2.0 HS160 F1.0 HS160_F F1.0 HS170 F1.0 HS170_F F1.0 HS180 F1.0 HS180_F F1.0 HS190 F1.0 HS190_F F1.0 HH010 F1.0 HH010_F F2.0 HH021 F1.0 HH021_F F1.0 HH030 COMMA3.2 HH030_F F1.0 HH031 F4.0 HH031_F F1.0 HH040 F1.0 HH040_F F1.0 HH050 F1.0 HH050_F F1.0 HH060 COMMA7.0 HH060_F F2.0 HH061 COMMA7.0 HH061_F F2.0 HH070 COMMA7.0 HH070_F F1.0 HH071 COMMA6.0 HH071_F F2.0 HH081 F1.0 HH081_F F1.0 HH091 F1.0 HH091_F F1.0 HD080 F1.0 HD080_F F1.0 HC040 F1.0 HC040_F F2.0 HC050 F1.0 HC050_F F2.0 HC060 F1.0 HC060_F F2.0 HC100 F1.0 HC100_F F2.0 HC160 F1.0 HC160_F F1.0 HC170 F1.0 HC170_F F2.0 HC180 F1.0 HC180_F F2.0 HC190 F1.0 HC190_F F1.0 HC200 F1.0 HC200_F F2.0 HC210 F1.0 HC210_F F2.0 HC220 F1.0 HC220_F F2.0 HC230 F1.0 HC230_F F2.0 HC240 F1.0 HC240_F F2.0 HC250 F1.0 HC250_F F2.0 HX010 COMMA8.0 HX040 F1.0 HX050 COMMA3.0 HX060 F2.0 HX070 F1.0 HX080 F1.0 HX090 COMMA12.0 HX120 F1.0 . * Please note: Variables HC040, HC050, HC060, HC100, HC160 have been changed and assigned new content * To differentiate between content of 2012 and 2016, the variables are marked with a year 2016 suffix * In 2012 HC040 was "Adequate plumbing/water installations" * In 2012 HC050 was "Dwelling equipped with heating facilities" * In 2012 HC060 was "Dwelling comfortably warm during winter time" * In 2012 HC100 was "Accessibility of banking services" * In 2012 HC160 was "Main reason for the expectation to be forced to leave the dwelling". RENAME VARIABLES (HC040 HC050 HC060 HC100 HC160=HC040_2016 HC050_2016 HC060_2016 HC100_2016 HC160_2016). RENAME VARIABLES (HC040_F HC050_F HC060_F HC100_F HC160_F=HC040_F_2016 HC050_F_2016 HC060_F_2016 HC100_F_2016 HC160_F_2016). VARIABLE LABELS HB010 'Year of the survey' / HB020 'Country alphanumeric' / HB030 'Household ID' / HB050 'Quarter of household interview' / HB050_F 'Flag' / HB060 'Year of household interview' / HB060_F 'Flag' / HB070 'Person responding to household questionnaire' / HB070_F 'Flag' / HB080 'Person 1 responsible for the accommodation' / HB080_F 'Flag' / HB090 'Person 2 responsible for the accommodation' / HB090_F 'Flag' / HB100 'Number of minutes to complete the household questionnaire' / HB100_F 'Flag' / HD080 'Replacing worn-out furniture' / HD080_F 'Flag' / HH010 'Dwelling type' / HH010_F 'Flag' / HH021 'Tenure status' / HH021_F 'Flag' / HH030 'Number of rooms available to the household (DE: missing)' / HH030_F 'Flag' / HH031 'Year of contract or purchasing or installation' / HH031_F 'Flag' / HH040 'Leaking roof, damp walls/ floors/ foundation, or rot in window frame or floor' / HH040_F 'Flag' / HH050 'Ability to keep home adequately warm' / HH050_F 'Flag' / HH060 'Current rent related to occupied dwelling' / HH060_F 'Flag' / HH061 'Subjective rent' / HH061_F 'Flag' / HH070 'Total housing cost' / HH070_F 'Flag' / HH071 'Mortgage principal repayment' / HH071_F 'Flag' / HH081 'Bath or shower in dwelling (DE: missing)' / HH081_F 'Flag' / HH091 'Indoor flushing toilet for sole use of household (DE: missing)' / HH091_F 'Flag' / HS011 'Arrears on mortgage or rent payments' / HS011_F 'Flag' / HS021 'Arrears on utility bills' / HS021_F 'Flag' / HS031 'Arrears on hire purchase instalments or other loan payments' / HS031_F 'Flag' / HS040 'Capacity to afford paying for one week annual holiday away from home' / HS040_F 'Flag' / HS050 'Capacity to afford a meal with meat, chicken, fish (or vegetarian equivalent) every second day' / HS050_F 'Flag' / HS060 'Capacity to face unexpected financial expenses' / HS060_F 'Flag' / HS070 'Do you have a telephone (including mobile phone, DE: missing)?' / HS070_F 'Flag' / HS080 'Do you have a colour TV?' / HS080_F 'Flag' / HS090 'Do you have a computer?' / HS090_F 'Flag' / HS100 'Do you have a washing maschine?' / HS100_F 'Flag' / HS110 'Do you have a car?' / HS110_F 'Flag' / HS120 'Ability to make ends meet' / HS120_F 'Flag' / HS130 'Lowest monthly income to make end meet' / HS130_F 'Flag' / HS140 'Financial burden of the total housing cost' / HS140_F 'Flag' / HS150 'Financial burden of the repayment of debts from hire purchases or loans' / HS150_F 'Flag' / HS160 'Problems with the dwelling: too dark, not enough light' / HS160_F 'Flag' / HS170 'Noise from neighbours or from the street' / HS170_F 'Flag' / HS180 'Pollution, grime or other environmental problems' / HS180_F 'Flag' / HS190 'Crime violence or vandalism in the area' / HS190_F 'Flag' / HY010 'Total household gross income (DE, EE, SI, UK: Adjustments)' / HY010_F 'Flag' / HY010_I 'Imputation factor' / HY020 'Total disposable household income (DE, EE, SI, UK: Adjustments)' / HY020_F 'Flag' / HY020_I 'Imputation factor' / HY022 'Total disposable household income before social transfers other than old-age and survivors benefits (DE, EE, SI, UK: Adjustments)' / HY022_F Flag / HY022_I 'Imputation factor' / HY023 'Total disposable household income before social transfers including old-age and survivors benefits (DE, EE, SI, UK: Adjustments)' / HY023_F 'Flag' / HY023_I 'Imputation factor' / HY030G 'Imputed rent (gross)' / HY030G_F 'Flag' / HY040G 'Income from rental of a property or land (gross; DE, SI: Top coding)' / HY040G_F 'Flag' / HY040G_I 'Imputation factor' / HY050G 'Family/Children related allowances (gross; SI: Top coding)' / HY050G_F 'Flag' / HY050G_I 'Imputation factor' / HY051G 'Family/children-related allowances (contributory and means-tested)' / HY051G_F 'Flag' / HY052G 'Family/children-related allowances (contributory and non means-tested)' / HY052G_F 'Flag' / HY053G 'Family/children-related allowances (non-contributory and means-tested)' / HY053G_F 'Flag' / HY054G 'Family/children-related allowance (non-contributory and non means-tested)' / HY054G_F 'Flag' / HY060G 'Social exclusion not elsewhere classified (gross; SI: Top coding)' / HY060G_F 'Flag' / HY060G_I 'Imputation factor' / HY061G 'Social exclusion not elsewhere classified (contributory and means-tested)' / HY061G_F 'Flag' / HY062G 'Social exclusion not elsewhere classified (contributory and non means-tested)' / HY062G_F 'Flag' / HY063G 'Social exclusion not elsewhere classified (non-contributory and means-tested)' / HY063G_F 'Flag' / HY064G 'Social exclusion not elsewhere classified (non-contributory and non means-tested)' / HY064G_F 'Flag' / HY070G 'Housing allowances (gross)' / HY070G_F 'Flag' / HY070G_I 'Imputation factor' / HY071G 'Housing allowances (contributory and means-tested)' / HY071G_F 'Flag' / HY072G 'Housing allowances (contributory and non means-tested)' / HY072G_F 'Flag' / HY073G 'Housing allowances (non-contributory and means-tested)' / HY073G_F 'Flag' / HY074G 'Housing allowances (non-contributory and non means-tested)' / HY074G_F 'Flag' / HY080G 'Regular interhousehold cash transfer received (gross; SI: Top coding)' / HY080G_F 'Flag' / HY080G_I 'Imputation factor' / HY081G 'Alimonies received (gross; SI: Top coding)' / HY081G_F 'Flag' / HY081G_I 'Imputation factor' / HY090G 'Interests, dividends, profit from capital investment in uncorporated business (gross; DE, EE, SI, UK: Top coding)' / HY090G_F 'Flag' / HY090G_I 'Imputation factor' / HY100G 'Interest repayments on mortgage (gross)' / HY100G_F 'Flag' / HY100G_I 'Imputation factor' / HY110G 'Income received by people aged under 16 (gross; SI: Top coding)' / HY110G_F 'Flag' / HY110G_I 'Imputation factor' / HY120G 'Regular taxes on wealth (gross, EE, SI, UK: Top coding)' / HY120G_F 'Flag' / HY120G_I 'Imputation factor' / HY130G 'Regular interhousehold cash transfer paid (gross; SI: Top coding)' / HY130G_F 'Flag' / HY130G_I 'Imputation factor' / HY131G 'Alimonies paid (gross; SI: Top coding)' / HY131G_F 'Flag' / HY131G_I 'Imputation factor' / HY140G 'Tax on income and social contributions (gross)' / HY140G_F 'Flag' / HY140G_I 'Imputation factor' / HY170G 'Value of goods produced for own consumption (gross)' / HY170G_F 'Flag' / HY170G_I 'Imputation factor' / HY030N 'Imputed rent (net)' / HY030N_F 'Flag' / HY040N 'Income from rental of a property or land (net; DE, SI: Top coding)' / HY040N_F 'Flag' / HY040N_I 'Imputation factor' / HY050N 'Family/Children related allowances (net; SI: Top coding)' / HY050N_F 'Flag' / HY050N_I 'Imputation factor' / HY060N 'Social exclusion not elsewhere classified (net; SI: Top coding)' / HY060N_F 'Flag' / HY060N_I 'Imputation factor' / HY070N 'Housing allowances (net; SI: Top coding)' / HY070N_F 'Flag' / HY070N_I 'Imputation factor' / HY080N 'Regular inter-household cash received (net; SI: Top coding)' / HY080N_F 'Flag' / HY080N_I 'Imputation factor' / HY081N 'Alimonies received (net; SI: Top coding)' / HY081N_F 'Flag' / HY081N_I 'Imputation factor' / HY090N 'Interests, dividends, profit from capital investment in uncorporated business (net; DE, SI: Top coding)' / HY090N_F 'Flag' / HY090N_I 'Imputation factor' / HY100N 'Interest repayment on mortgage (net)' / HY100N_F 'Flag' / HY100N_I 'Imputation factor' / HY110N 'Income received by people aged under 16 (net; SI: Top coding)' / HY110N_F 'Flag' / HY110N_I 'Imputation factor' / HY120N 'Regular taxes on wealth (net; SI: Top coding)' / HY120N_F 'Flag' / HY120N_I 'Imputation factor' / HY130N 'Regular inter-household cash transfer paid (net; SI: Top coding)' / HY130N_F 'Flag' / HY130N_I 'Imputation factor' / HY131N 'Alimonies paid (net; SI: Top coding)' / HY131N_F 'Flag' / HY131N_I 'Imputation factor' / HY140N 'Tax on income and social contribution' / HY140N_F 'Flag' / HY140N_I 'Imputation factor' / HY145N 'Repayments or receipts for tax adjustment (net; SI: Top & bottom coding)' / HY145N_F 'Flag' / HY145N_I 'Imputation factor' / HY170N 'Value of goods produced for own consumption (net)' / HY170N_F 'Flag' / HY170N_I 'Imputation factor' / HX010 'Change rate' / HX040 'Household size (MT: Top coded to 6; DE: deleted 7 or more HH)' / HX050 'Equivalised household size' / HX060 'Household type' / HX070 'Tenure state' / HX080 'Poverty indicator' / HX090 'Equivalised disposable income (SI: Adjustments)' / HX120 'Overcrowded household'/ HC040_2016 'Affordability of childcare services' / /* Please note a change of variable: In 2012 HC040 was "Adequate plumbing/water installations" */ HC040_F_2016 'Flag' / HC050_2016 'Unmet needs for formal childcare services' / /* Please note a change of variable: In 2012 HC050 was "Dwelling equipped with heating facilities" */ HC050_F_2016 'Flag' / HC060_2016 'Main reason for not making (more) use of formal childcare services' / /* Please note a change of variable: In 2012 HC060 was "Dwelling comfortably warm during winter time" */ HC060_F_2016 'Flag' / HC100_2016 'Affordability of formal education' / /* Please note a change of variable: In 2012 HC100 was "Accessibility of banking services" */ HC100_F_2016 'Flag' / HC160_2016 'Use of health care services' / /* Please note a change of variable: In 2012 HC160 was "Main reason for the expectation to be forced to leave the dwelling" / HC160_F_2016 'Flag' / HC170 'Payment for health care services' / HC170_F 'Flag' / HC180 'Affordability of health care services' / HC180_F 'Flag' / HC190 'Presence in the household of people who need help due to long-term physical or mental ill-health, infirmity or because of old age' / HC190_F 'Flag' / HC200 'Professional home care received' / HC200_F 'Flag' / HC210 'Number of hours per week of professional home care received' / HC210_F 'Flag' / HC220 'Payment for professional home care' / HC220_F 'Flag' / HC230 'Affordability of professional home care services' / HC230_F 'Flag' / HC240 'Unmet needs for professional home care' / HC240_F 'Flag' / HC250 'Main reason for not receiving (more) professional home care services' / HC250_F 'Flag' / . * For HY010, HY020, HY022, HY023: Please see Differences Collection vs UDB for more information. VALUE LABELS HB050 1 "January, February, March" 2 "April, May, June" 3 "July, August, September" 4 "October, November, December" / HB050_F 1 "filled" -1 "missing" / HB060_F 1 "filled" / HB070_F 1 "filled" -1 "missing" / HB080_F 1 "filled" -1 "missing" / HB090_F 1 "filled" -1 "missing" -2 "not applicable (no 2nd responsible)" / HB100_F 1 "filled" -1 "missing" / HD080 1 'Yes' 2 'No - household cannot afford it' 3 'No - other reason' / HD080_F 1 'filled' -1 'missing' -2 'not applicable (no children aged between 1 and 15)' -5 'Not collected' / HH010 1 "detached house" 2 "semi-detached house" 3 "apartment or flat in a building with < 10 dwellings" 4 "apartment or flat in a building with >=10 dwellings" / HH010_F 1 "filled" -1 "missing" / HH021 1 "Outright owner" 2 "Owner paying mortgage" 3 "Tenant/subtenant paying rent at prevailing or market rate" 4 "Accommodation is rented at a reduced rate (lower price that the market price)" 5 "Accommodation is provided free" / HH021_F 1 "filled" -1 "missing" / HH030 6 "6 or more rooms" / HH031 1961 "PT:1961 and earlier" 1945 "SI:1945 and earlier" / HH030_F 1 "filled" -1 "missing" / HH031_F 1 "filled" -1 "missing" -2 "n.a." / HH040 1 "yes" 2 "no" / HH040_F 1 "filled" -1 "missing" / HH050 1 "yes" 2 "no" / HH050_F 1 "filled" -1 "missing" / HH060_F 1 "filled" -1 "missing" -2 "not applicable (HH021 not = 3 or 4)" / HH061_F 1 "filled" -1 "missing" -2 "not applicable (HH021 = 3) or (MS do not use subjective method to calculate imputed rent)" / HH070_F 1 "filled" -1 "missing" / HH071_F 1 "filled" -1 "missing" -2 "not applicable (HH021 ne 2)" / HH081 1 "yes, for sole use of the household" 2 "yes, shared" 3 "no" / HH081_F 1 "filled" -1 "missing" / HH091 1 "yes, for sole use of the household" 2 "yes, shared" 3 "no" / HH091_F 1 "filled" -1 "missing" / HS011 1 "yes, once" 2 "yes, twice or more" 3 "no" / HS011_F 1 "filled" -1 "missing" -2 "not applicable" / HS021 1 "yes, once" 2 "yes, twice or more" 3 "no" / HS021_F 1 "filled" -1 "missing" -2 "not applicable" / HS031 1 "yes, once" 2 "yes, twice or more" 3 "no" / HS031_F 1 "filled" -1 "missing" -2 "not applicable" / HS040 1 "yes" 2 "no" / HS040_F 1 "filled" -1 "missing" / HS050 1 "yes" 2 "no" / HS050_F 1 "filled" -1 "missing" / HS060 1 "yes" 2 "no" / HS060_F 1 "filled" -1 "missing" / HS070 1 "yes" 2 "no - cannot afford" 3 "no - other reason" / HS070_F 1 "filled" -1 "missing" / HS080 1 "yes" 2 "no - cannot afford" 3 "no - other reason" / HS080_F 1 "filled" -1 "missing" / HS090 1 "yes" 2 "no - cannot afford" 3 "no - other reason" / HS090_F 1 "filled" -1 "missing" / HS100 1 "yes" 2 "no - cannot afford" 3 "no - other reason" / HS100_F 1 "filled" -1 "missing" / HS110 1 "yes" 2 "no - cannot afford" 3 "no - other reason" / HS110_F 1 "filled" -1 "missing" / HS120 1 "with great difficulty" 2 "with difficulty" 3 "with some difficulty" 4 "fairly easily" 5 "easily" 6 "very easily" / HS120_F 1 "filled" -1 "missing" / HS130_F 1 "filled" -1 "missing" / HS140 1 "A heavy burden" 2 "somewhat a burden" 3 "not a burden at all" / HS140_F 1 "filled" -1 "missing" -2 "not applicable (no housing costs)" / HS150 1 "repayment is a heavy burden" 2 "repayment is somewhat a burden" 3 "repayment is not a burden at all" / HS150_F 1 "filled" -1 "missing" -2 "not applicable (no repayment of debts)" / HS160 1 "yes" 2 "no" / HS160_F 1 "filled" -1 "missing" / HS170 1 "yes" 2 "no" / HS170_F 1 "filled" -1 "missing" / HS180 1 "yes" 2 "no" / HS180_F 1 "filled" -1 "missing" / HS190 1 "yes" 2 "no" / HS190_F 1 "filled" -1 "missing" / HY010_F HY020_F HY022_F HY023_F 0 "no income" 1 "data collection:net" 2 "data collection:gross" 3 "data collection:net and gross" 4 "data collection:unknown" -1 "missing" / HY030G_F 0 "no income" 1 "income (variable is filled)" -1 "missing" -5 "not filled:variable of net (...g)gross (...n) series is filled" / HY040G_F HY050G_F HY060G_F HY070G_F HY080G_F HY081G_F HY090G_F HY100G_F HY110G_F HY120G_F HY130G_F HY131G_F HY170G_F 0 "No income" 1 "Collected net of tax on income at source and social contributions" 2 "Collected net of tax on income at source" 3 "Collected net of tax on social contributions" 4 "Collected gross" 5 "Collected unknown" 6 "Mix (parts of the component collected according to different ways" -1 "Missing" -4 "Missing (amount included in another income component)" -5 "Not filled: variable of net series is filled" / HY051G_F HY061G_F HY071G_F HY052G_F HY062G_F HY072G_F HY053G_F HY063G_F HY073G_F HY054G_F HY064G_F HY074G_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 does not exist at national level' -7 'N/A HB010 < 2014' / HY030N_F 0 "no income" 1 "income(variable is filled)" -1 "Missing" -5 "not filled: variable of gross series is filled" / HY040N_F HY050N_F HY060N_F HY070N_F HY080N_F HY081N_F HY090N_F HY100N_F HY110N_F HY120N_F HY130N_F HY131N_F HY145N_F HY170N_F 0 "No income" 1 "Net of tax on income at source and social contributions" 13 "Collected net of tax on income at source & social contributions & recorded net of tax on social contribution" 11 "Collected & recorded net of tax on income at source & social contributions" 22 "Collected & recorded net of tax on income at source" 31 "Collected net of tax on social contribution/recorded net of tax on income & social contributions" 32 "Collected net of tax on social contribution/rec. net of tax on income at source" 33 "Collected & recorded net of tax on social contributions" 41 "Collected gross/recorded net of tax on income & social contributions" 42 "Collected gross/recorded net of tax on income at source" 43 "Collected gross/recorded net of tax on social contributions" 51 "Collected unknown/recorded net of tax on income & social contributions" 52 "Collected unknown/recorded net of tax on income at source" 53 "Collected unknown/recorded net of tax on social contributions" 55 "Unknown" 56 "Collected unknown/recorded mixed" 61 "Mix (parts of the component collected according to different ways/deductive imputation)" -1 "Missing" -4 "Missing (amount included in another income component)" -5 "Not filled: variable of gross series is filled" / HY140N_F 0 "no income" 1 "variable is filled" -1 "missing" -5 "Not filled: variable of the gross series is filled" / HX040 6 " 6; MT:Top Coding" 7 "DE: deleted 7 or more households" / HX060 5 "One person household" 6 "2 adults, no dependent children, both adults under 65 years" 7 "2 adults, no dependent children, at least one adult >=65 years" 8 "Other households without dependent children" 9 "Single parent household, one or more dependent children" 10 "2 adults, one dependent child" 11 "2 adults, two dependent children" 12 "2 adults, three or more dependent children" 13 "Other households with dependent children" 16 "Other (these household are excluded from Laeken indicators calculation)" / HX070 1 "when HH021= 1, 2, 5" 2 "when HH021= 3 or 4" / HX080 0 "when HX090>= at risk of poverty threshold (60% of Median HX090)" 1 "when HX090 < at risk of poverty threshold (60% of Median HX090)" / HX120 0 "not overcrowded" 1 "overcrowded" / HC040_2016 1 "With great difficulty" 2 "With difficulty" 3 "With some difficulty" 4 "Fairly easily" 5 "Easily" 6 "Very easily" / HC040_F_2016 1 "Filled" -1 "Missing" -4 "No costs of childcare in the household" -5 "No children aged 0-12 in the household" -7 "Not applicable (HB010 not 2016)" / HC050_2016 1 "Yes" 2 "No" / HC050_F_2016 1 "Filled" -1 "Missing" -5 "No children aged 0-12 in the household" -7 "Not applicable (HB010 not 2016)" / HC060_2016 1 "Cannot afford it" 2 "No places available" 3 "Places available but not nearby" 4 "Places available but opening hours not suitable" 5 "Places available but the quality of the services available not satisfactory" 6 "Other reasons" / HC060_F_2016 1 "Filled" -1 "Missing" -2 "Not applicable (HC050 = 2)" -5 "No children aged 0-12 in the household" -7 "Not applicable (HB010 not 2016)" / HC100_2016 1 "With great difficulty" 2 "With difficulty" 3 "With some difficulty" 4 "Fairly easily" 5 "Easily" 6 "Very easily" / HC100_F_2016 1 "Filled" -1 "Missing" -4 "No costs of formal education in the household" -5 "Nobody in the household follows formal education" -7 "Not applicable (HB010 not 2016)" / HC160_2016 1 "Yes" 2 "No" / HC160_F_2016 1 "Filled" -1 "Missing" -7 "Not applicable (HB010 not 2016)" / HC170 1 "Yes" 2 "No" / HC170_F 1 "Filled" -1 "Missing" -2 "Not applicable (HC060 = 2)" -7 "Not applicable (HB010 not 2016)" / HC180 1 "With great difficulty" 2 "With difficulty" 3 "With some difficulty" 4 "Fairly easily" 5 "Easily" 6 "Very easily" / HC180_F 1 "Filled" -1 "Missing" -2 "Not applicable (HC160 = 2)" -7 "Not applicable (HB010 not 2016)" / HC190 1 "Yes" 2 "No" / HC190_F 1 "Filled" -1 "Missing" -7 "Not applicable (HB010 not 2016)" / HC200 1 "Yes" 2 "No" / HC200_F 1 "Filled" -1 "Missing" -2 "Not applicable (HC190 = 2)" -7 "Not applicable (HB010 not 2016)" / HC210 1 "Less than 10 hours per week" 2 "At least 10 but less than 20 hours per week" 3 "20 hours per week or more" / HC210_F 1 "Filled" -1 "Missing" -2 "Not applicable (HC190=2 or HC200=2)" -7 "Not applicable (HB010 not 2016)" / HC220 1 "Yes" 2 "No" / HC220_F 1 "Filled" -1 "Missing" -2 "Not applicable (HC190=2 or HC200=2)" -7 "Not applicable (HB010 not 2016)" / HC230 1 "With great difficulty" 2 "With difficulty" 3 "With some difficulty" 4 "Fairly easily" 5 "Easily" 6 "Very easily" / HC230_F 1 "Filled" -1 "Missing" -2 "Not applicable (HC190=2 or HC200=2 or HC220=2)" -7 "Not applicable (HB010 not 2016)" / HC240 1 "Yes" 2 "No" / HC240_F 1 "Filled" -1 "Missing" -2 "Not applicable (HC190=2)" -7 "Not applicable (HB010 not 2016)" / HC250 1 "Cannot afford it" 2 "Refused by person needing such services" 3 "No such care services available" 4 "Quality of the services available not satisfactory" 5 "Other reasons" / HC250_F 1 "Filled" -1 "Missing" -2 "Not applicable (HC190=2 or HC240=2)" -7 "Not applicable (HB010 not 2016)". SAVE OUTFILE= !QUOTE(!CONCAT(!spss_path,'UDB_c',!i,'16H.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,'16H.sav')). !LET !firstfile=0. !ELSE ADD FILES FILE=* /FILE=!QUOTE(!CONCAT(!spss_path,!filestub,'16H.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,'16H.sav')). !DOEND. !ENDDEFINE. *----------------------------------------------------------------- End definition macro ---------------------------------------------------------------. *----------------------------------------------------------------- Invoke macro ---------------------------------------------------------------------------. !C2016_H.