* Encoding: windows-1252. * ==================================================================================================. * EU-SILC Cross 2007 - release 2021-09 / DOI: TBD. * * When publishing statistics derived from the EU-SILC UDB, please state as source: * "EU-SILC UDB - version of 2021-09" * * SPSS Command Syntax File * 2007_cross_eu_silc_h_ver_2022_03.sps * * (c) 2022-06-02 GESIS * * PLEASE NOTE * For Differences between data as described in the guidelines * and the anonymised user database as well as country specific anonymisation measures see: * C-2007 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 free software: you can redistribute it and/or modify * it under the terms of the GNU Affero General Public License as * published by the Free Software Foundation, either version 3 of the * License, or (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Affero General Public License for more details. * * You should have received a copy of the GNU Affero General Public License * along with this program. If not, see . * * * Pforr, Klaus and Johanna Jung (2022): 2007_cross_eu_silc_h_ver_2022_03.sps. * SPSS-Syntax for transforming EU-SILC csv data into an SPSS-Systemfile. * * https://www.gesis.org/gml/european-microdata/eu-silc/ * * Contact: klaus.pforr@gesis.org ************************************************************************************************************************************. set decimal=DOT. * When using SPSS earlier than V16 you might not use "set unicode" . set unicode=OFF. *----------------------------------------------------------------- Start definition macro ---------------------------------------------------------------. DEFINE !C2007_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 !CC1= 'AT BE CY DE DK EE FI GR IE NL PL SE SI SK UK'. !LET !CC2= 'BG CH CZ ES FR HU IS IT LT LU LV MT NO PT RO'. !LET !CC= 'AT BE CY DE DK EE FI GR IE NL PL SE SI SK UK BG CH CZ ES FR HU IS IT LT LU LV MT NO PT RO'. !DO !j !IN (!CC1) !IF (!j="GR") !THEN !LET !i="EL". !ELSE !LET !i=!j. !IFEND. GET DATA /TYPE=TXT /FILE=!QUOTE(!CONCAT(!csv_path,!i,'\2007\UDB_c',!j,'07H.csv')) /ENCODING='Locale' /DELCASE=LINE /DELIMITERS="," /ARRANGEMENT=DELIMITED /FIRSTCASE=2 /IMPORTCASE=ALL /VARIABLES= HB010 F4.0 HB020 A2 HB030 F3.0 HB050 F1.0 HB050_F F1.0 HB060 F4.0 HB060_F F1.0 HB070 F5.0 HB070_F F1.0 HB080 F5.0 HB080_F F1.0 HB090 F5.0 HB090_F F2.0 HB100 F2.0 HB100_F F1.0 HY010 COMMA9.0 HY010_F F1.0 HY010_I COMMA7.0 HY020 COMMA9.0 HY020_F F1.0 HY020_I COMMA8.0 HY022 COMMA9.0 HY022_F F1.0 HY022_I COMMA8.0 HY023 COMMA9.0 HY023_F F1.0 HY023_I COMMA8.0 HY025 COMMA7.0 HY025_F F1.0 HY030N COMMA8.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 COMMA8.0 HY060N_F F2.0 HY060N_I COMMA9.0 HY070N COMMA7.0 HY070N_F F2.0 HY070N_I COMMA7.0 HY080N COMMA7.0 HY080N_F F2.0 HY080N_I COMMA9.0 HY090N COMMA8.0 HY090N_F F2.0 HY090N_I COMMA8.0 HY100N COMMA8.0 HY100N_F F1.0 HY100N_I COMMA9.0 HY110N COMMA8.0 HY110N_F F2.0 HY110N_I COMMA9.0 HY120N COMMA8.0 HY120N_F F1.0 HY120N_I COMMA9.0 HY130N COMMA8.0 HY130N_F F2.0 HY130N_I COMMA9.0 HY140N COMMA8.0 HY140N_F F2.0 HY140N_I COMMA9.0 HY145N COMMA8.0 HY145N_F F1.0 HY145N_I COMMA9.0 HY030G COMMA8.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 COMMA8.0 HY060G_F F1.0 HY060G_I COMMA9.0 HY070G COMMA8.0 HY070G_F F1.0 HY070G_I COMMA9.0 HY080G COMMA8.0 HY080G_F F1.0 HY080G_I COMMA9.0 HY090G COMMA8.0 HY090G_F F1.0 HY090G_I COMMA7.0 HY100G COMMA8.0 HY100G_F F1.0 HY100G_I COMMA9.0 HY110G COMMA8.0 HY110G_F F1.0 HY110G_I COMMA9.0 HY120G COMMA8.0 HY120G_F F1.0 HY120G_I COMMA9.0 HY130G COMMA8.0 HY130G_F F1.0 HY130G_I COMMA9.0 HY140G COMMA9.0 HY140G_F F1.0 HY140G_I COMMA9.0 HS010 F1.0 HS010_F F2.0 HS020 F1.0 HS020_F F1.0 HS030 F1.0 HS030_F F2.0 HS040 F1.0 HS040_F F2.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 F2.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 HH020 F1.0 HH020_F F1.0 HH030 F1.0 HH030_F F1.0 HH031 F4.0 HH031_F F2.0 HH040 F1.0 HH040_F F1.0 HH050 F1.0 HH050_F F1.0 HH060 COMMA6.0 HH060_F F2.0 HH061 COMMA7.0 HH061_F F2.0 HH070 COMMA7.0 HH070_F F2.0 HH080 F1.0 HH080_F F1.0 HH090 F1.0 HH090_F F1.0 MH010 F1.0 MH010_F F1.0 MH020 F1.0 MH020_F F1.0 MH030 F1.0 MH030_F F1.0 MH040 F1.0 MH040_F F1.0 MH050 F1.0 MH050_F F1.0 MH060 F1.0 MH060_F F1.0 MH070 F1.0 MH070_F F1.0 MH080 F1.0 MH080_F F2.0 MH090 F1.0 MH090_F F2.0 MH100 F1.0 MH100_F F2.0 MH110 F1.0 MH110_F F2.0 MH120 F1.0 MH120_F F2.0 MH130 F1.0 MH130_F F2.0 MH140 F1.0 MH140_F F2.0 MH150 F1.0 MH150_F F1.0 MH160 F1.0 MH160_F F2.0 HX040 F1.0 HX050 COMMA4.0 HX090 COMMA9.0 HX080 F1.0 HX060 F2.0 HX070 F1.0 HX020 F1.0 HX010 COMMA9.0 HY081N COMMA8.0 HY131N COMMA8.0 HY081G COMMA8.0 HY131G COMMA8.0. VARIABLE LABELS HB010 'Year of the survey'/ HB020 'Country alphanumerical'/ HB030 'Household ID'/ HB050 'Quarter of household interview' / HB050_F 'Flags' / 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'/ HY010 'Total household gross income'/ HY010_F 'Flag'/ HY010_I 'Imputation factor'/ HY020 'Total disposable household income'/ HY020_F 'Flag'/ HY020_I 'Imputation Factor'/ HY022 'Tt disp. Hhld Inc. Bef. social trnsfrs other than old-age and survivors benefits'/ HY022_F 'Flag'/ HY022_I 'Imputation Factor'/ HY023 'Tt disp. Hhld inc. Bef. social trnsfrs including old-age and survivors benefits'/ HY023_F 'Flag'/ HY023_I 'Imputation Factor'/ HY025 'Within Household non-response inflation factor'/ HY025_F 'Flag'/ HY030N 'Imputed rent (net)'/ HY030N_F 'Flag'/ HY040N 'Income from rental of a property or land(net)'/ HY040n_F 'Flag'/ HY040n_I 'Imputation factor'/ HY050N 'Family/Children related allowances (net)'/ HY050N_F 'Flag'/ HY050N_I 'Imputation factor'/ HY060N 'Social Exclusion not elsewhere classified(net)'/ HY060N_F 'Flag'/ HY060N_I 'Imputation Factor'/ HY070N 'Housing Allowances(net)'/ HY070N_F 'Flag'/ HY070N_I 'Imputation factor'/ HY080N 'Regular inter-household cash received (net)'/ HY080N_F 'Flag'/ HY080N_I 'Imputation Factor'/ HY090N 'Interests, dividends, profit from capital investment in uncorp. business (net)'/ 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)'/ HY110N_F 'Flag'/ HY110N_I 'Imputation Factor'/ HY120N 'Regular taxes on wealth(net)'/ HY120N_F 'Flag'/ HY120n_I 'Imputation Factor'/ HY130N 'Regular inter-household cash transfer paid'/ HY130N_F 'Flag'/ HY130N_I 'Imputation factor'/ HY140N 'Tax on income and social contribution'/ HY140N_F 'Flag'/ HY140N_I 'Imputation factor'/ HY145N 'Repayments/receipts for tax adjustment(net)'/ HY145N_F 'Flag'/ HY145N_I 'Imputation factor'/ HY030G 'Imputed rent (gross)'/ HY030G_F 'Flag'/ HY040G 'Income from rental of a property or land (gross)'/ HY040G_F 'Flag'/ HY040G_I 'Imputation factor'/ HY050G 'Family/Children related allowances (gross)'/ HY050G_F 'Flag'/ HY050G_I 'Imputation factor'/ HY060G 'Social Exclusion not elsewhere classified(gross)'/ HY060g_F 'Flag'/ HY060G_I 'Imputation factor'/ HY070G 'Housing allowances(gross)'/ HY070G_F 'Flag'/ HY070G_I 'Imputation factor'/ HY080G 'Regular Interhousehold cash transfer received(gross)'/ HY080G_F 'Flag'/ HY080g_I 'Imputation factor'/ HY090g 'Interests, dividends, profit from capital investment in uncorp. business (gross)'/ 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)'/ HY110g_F 'Flag'/ HY110G_I 'Imputation factor'/ HY120G 'Regular taxes on wealth(Gross)'/ HY120g_F 'Flag'/ HY120g_I 'Imputation factor'/ HY130g 'Regular interhousehold cash transfer paid(gross)'/ HY130g_F 'Flag'/ HY130g_I 'Imputation factor'/ HY140G 'Tax on income and social contributions(gross)'/ HY140G_F 'Flag'/ HY140G_I 'Imputation factor'/ HS010 'Arrears on mortgage or rent payments'/ HS010_F 'Flag'/ HS020 'Arrears on utility bills'/ HS020_F 'Flag'/ HS030 'Arrears on hire purchase instalments or other loan payments'/ HS030_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 veg. equiv.) ev. sec. day'/ HS050_F 'Flag'/ HS060 'Capacity to face unexpected financial expenses'/ HS060_F 'Flag'/ HS070 'Do you have a telephone (including mobile phone)?'/ 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 machine?'/ 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'/ HH010 'Dwelling type'/ HH010_F 'Flag'/ HH020 'Tenure status'/ Hh020_F 'Flag'/ HH030 'Number of rooms available to the household'/ 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'/ Hh080 'Bath or shower in dwelling'/ Hh080_F 'Flag'/ HH090 'Indoor flushing toilet for sole use of household'/ HH090_F 'Flag'/ MH010 'Shortage of space in dwelling'/ MH010_F 'Flag'/ MH020 'Adequate electrical installations'/ MH020_F 'Flag'/ MH030 'Adequate plumbing/water installations'/ MH030_F 'Flag'/ MH040 'Dwelling equipped with heating facilities'/ MH040_F 'Flag'/ MH050 'Dwelling comfortably warm during winter time'/ MH050_F 'Flag' / MH060 'Dwelling equipped with air conditioning facilities'/ MH060_F 'Flag'/ MH070 'Dwelling comfortably cool during summer time'/ MH070_F 'Flag'/ MH080 'Overall satisfaction with dwelling'/ MH080_F 'Flag'/ MH090 'Accessibility of grocery services'/ MH090_F 'Flag'/ MH100 'Accessibility of banking services'/ MH100_F 'Flag'/ MH110 'Accessibility of postal services'/ MH110_F 'Flag'/ MH120 'Accessibility of public transport'/ MH120_F 'Flag'/ MH130 'Accessibility of primary health care services'/ MH130_F 'Flag'/ MH140 'Accessibility of compulsory school'/ MH140_F 'Flag'/ MH150 'Change of dwelling'/ MH150_F 'Flag'/ MH160 'Main reason for change of dwelling'/ MH160_F 'Flag'/ HX040 'Household size'/ HX050 'Equivalised household Size'/ HX090 'Equivalised disposable income'/ HX080 'Poverty indicator'/ HX060 'Household type'/ HX070 'Tenure state'/ HX020 'Work intensity status (n.a. BG, CZ, ES, FR, IS, IT, LT, LU, LV, NO, PT, RO)'/ HX010 'Change rate'/ HY081G 'Alimonies received (gross)'/ HY081N 'Alimonies received (net)'/ HY131G 'Alimonies paid (gross)' HY131N 'Alimonies paid (net)'. value labels HB020 '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"/ 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'/ HY010_F 0 'no income' 1 'data collection:net' 2 'data collection:gross' 3 'data collection:net and gross' 4 'data collection:unknown' -1 'missing' -5 'not filled: no conversion to gross is done'/ HY020_F 0 'no income' 1 'data collection:net' 2 'data collection:gross' 3 'data collection:net and gross' 4 'data collection:unknown' -1 'missing' / HY022_F 0 'no income' 1 'data collection:net' 2 'data collection:gross' 3 'data collection:net and gross' 4 'data collection:unknown' -1 'missing'/ 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'/ HY025_F 1 'filled' -1 'missing'/ HY030N_F 0 'no income' 1 'income(variable is filled)' -1 'Missing' -5 'not filled: variable of gross series is filled'/ HY040N_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.' -1 'missing' -5 'not filled: variable of gross series is filled'/ HY050N_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.' 55 'unknown' -1 'missing' -5 'not filled: variable of gross series is filled'/ HY060N_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.' 55 'unknown' -1 'missing' -5 'not filled: variable of gross series is filled'/ HY070N_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.' 55 'unknown' -1 'missing' -5 'not filled: variable of gross series is filled'/ HY080N_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.' 55 'unknown' -1 'missing' -5 'not filled: variable of gross series is filled'/ HY090N_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.' 55 'unknown' 1 'net of tax on income at source and social contribution' -1 'missing' -5 'not filled: variable of gross series is filled'/ HY100n_F 0 'no income' 1 'variable is filled' -1 'missing' -5 'not filled:variable of the gross series is filled'/ HY110N_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.' 55 'unknown' -1 'missing' -5 'not filled: variable of gross series is filled'/ HY120N_F 0 'no income' 1 'variable is filled' -1 'missing' -4 'Amount included in another income component' -5 'Not filled: variable of the gross series is filled'/ HY130N_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.' 55 'unknown' -1 'missing' -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'/ HY145N_F 0 'no income' 1 'variable is filled' -1 'missing' -5 'Not filled: variable of gross series is filled'/ 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 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' -1 'missing' -5 'not filled:variable of net series is filled'/ HY050G_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' -1 'missing' -5 'not filled:variable of net series is filled'/ HY060G_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' -1 'missing' -5 'not filled:variable of net series is filled'/ HY070G_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' -1 'missing' -5 'not filled:variable of net series is filled'/ HY080G_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' -1 'missing' -5 'not filled:variable of net series is filled'/ HY090G_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' -1 'missing' -5 'not filled:variable of net series is filled'/ HY100G_F 0 'no income' 1 'variable is filled' -1 'missing' -5 'not filled: variable of net/gross series is filled'/ HY110G_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' -1 'missing' -5 'not filled:variable of net series is filled'/ HY120G_F 0 'no income' 1 'variable is filled' -1 'missing' -4 'amount included in another income component' -5 'not filled: variable of the net series is filled'/ HY130G_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' -1 'missing' -5 'not filled:variable of net series is filled'/ HY140G_F 0 'no income' 1 'variable is filled' -1 'missing' -5 'not filled: variable of the net/gross series is filled'/ HS010 1 'yes' 2 'no'/ HS010_F 1 'filled' -1 'missing' -2 'not applicable'/ HS020 1 'yes' 2 'no'/ HS020_F 1 'filled' -1 'missing' -2 'not applicable'/ HS030 1 'yes' 2 'no'/ HS030_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'/ 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 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'/ 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'/ HH020 1 'owner' 2 'tenant or subtenant paying rent at prevailing or market rate' 3 'accommodation is rented at a reduced rate(lower price than market price)' 4 'accommodation is provided free'/ HH020_F 1 'filled' -1 'missing'/ HH030 6 'six or more rooms'/ 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 'n.a. (HH020 ne 2 or 3)'/ HH061_F 1 'filled' -1 'missing' -2 'na'/ HH070_F 1 'filled' -1 'missing'/ HH080 1 'yes' 2 'no'/ HH080_F 1 'filled' -1 'missing'/ HH090 1 'yes' 2 'no'/ HH090_F 1 'filled ' -1 'missing'/ HX060 5 'one person household' 6 '2 adults no dependent children, both adults under 65 years' 7 '2 adults, no dependant children, at least one adult 65 years or more' 8 'other households with 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 households are excluded from Laeken indicators calculation)'/ MH010 1 'yes' 2 'no'/ MH010_F -1 'missing' 1 'filled'/ MH020 1 'yes' 2 'no'/ MH020_F -2 'not applicable (no electricity/installations)' -1 'missing' 1 'filled'/ MH030 1 'yes' 2 'no'/ MH030_F -2 'not applicable (no plumbing/water installtionsinstallations)' -1 'missing' 1 'filled'/ MH040 1 'yes - central heating or similar' 2 'yes - other fixed heating' 3 'no - no fixed heating'/ MH040_F -1 'missing' 1 'filled'/ MH050 1 'yes' 2 'no'/ MH050_F -1 'missing' 1 'filled'/ MH060 1 'yes' 2 'no'/ MH060_F -1 'missing' 1 'filled'/ MH070 1 'yes' 2 'no'/ MH070_F -1 'missing' 1 'filled'/ MH080 1 'very dissatisfied' 2 'somewhat dissatisfied' 3 'satisfied' 4 'very satisfied'/ MH080_F -1 'missing' 1 'filled'/ MH090 1 'with great difficulty' 2 'with some difficulty' 3 'easily' 4 'very easily'/ MH090_F -2 'n/a (services not used by household)' -1 'missing' 1 'filled'/ MH100 1 'with great difficulty' 2 'with some difficulty' 3 'easily' 4 'very easily'/ MH100_F -2 'n/a (services not used by household)' -1 'missing' 1 'filled'/ MH110 1 'with great difficulty' 2 'with some difficulty' 3 'easily' 4 'very easily'/ MH110_F -2 'n/a (services not used by household)' -1 'missing' 1 'filled'/ MH120 1 'with great difficulty' 2 'with some difficulty' 3 'easily' 4 'very easily'/ MH120_F -2 'n/a (services not used by household)' -1 'missing' 1 'filled'/ MH130 1 'with great difficulty' 2 'with some difficulty' 3 'easily' 4 'very easily'/ MH130_F -2 'n/a (services not used by household)' -1 'missing' 1 'filled'/ MH140 1 'with great difficulty' 2 'with some difficulty' 3 'easily' 4 'very easily'/ MH140_F -2 'n/a (services not used by household)' -1 'missing' 1 'filled'/ MH150 1 'yes' 2 'no'/ MH150_F -1 'missing' 1 'filled'/ MH160 1 'family related reasons' 2 'employment related reasons' 3 'housing related reasons' 4 'eviction/distraint' 5 'landlord did not prolong the contract' 6 'financial reasons' 7 'other'/ MH160_F -2 'n/a (MH150 not = 1)' -1 'missing' 1 'filled'/ HX020 1 'WI = 0' 2 '0 < WI < 0.5' 3 '0.5 <= WI < 1' 4 'WI = 1'/ 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 HH020= 1 or 4' 2 'when HH020= 2 or 3'/ 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)'. SAVE OUTFILE= !QUOTE(!CONCAT(!spss_path,'UDB_c',!j,'07H.sav')). !DOEND. !DO !i !IN (!CC2) GET DATA /TYPE=TXT /FILE=!QUOTE(!CONCAT(!csv_path,!i,'\2007\UDB_c',!i,'07H.csv')) /ENCODING='Locale' /DELCASE=LINE /DELIMITERS="," /ARRANGEMENT=DELIMITED /FIRSTCASE=2 /IMPORTCASE=ALL /VARIABLES= HB010 AUTO HB020 AUTO HB030 AUTO HB050 AUTO HB050_F AUTO HB060 AUTO HB060_F AUTO HB070 AUTO HB070_F AUTO HB080 AUTO HB080_F AUTO HB090 AUTO HB090_F AUTO HB100 AUTO HB100_F AUTO HY010 AUTO HY010_F AUTO HY010_I AUTO HY020 AUTO HY020_F AUTO HY020_I AUTO HY022 AUTO HY022_F AUTO HY022_I AUTO HY023 AUTO HY023_F AUTO HY023_I AUTO HY025 AUTO HY025_F AUTO HY030N AUTO HY030N_F AUTO HY040N AUTO HY040N_F AUTO HY040N_I AUTO HY050N AUTO HY050N_F AUTO HY050N_I AUTO HY060N AUTO HY060N_F AUTO HY060N_I AUTO HY070N AUTO HY070N_F AUTO HY070N_I AUTO HY080N AUTO HY080N_F AUTO HY080N_I AUTO HY090N AUTO HY090N_F AUTO HY090N_I AUTO HY100N AUTO HY100N_F AUTO HY100N_I AUTO HY110N AUTO HY110N_F AUTO HY110N_I AUTO HY120N AUTO HY120N_F AUTO HY120N_I AUTO HY130N AUTO HY130N_F AUTO HY130N_I AUTO HY140N AUTO HY140N_F AUTO HY140N_I AUTO HY145N AUTO HY145N_F AUTO HY145N_I AUTO HY030G AUTO HY030G_F AUTO HY040G AUTO HY040G_F AUTO HY040G_I AUTO HY050G AUTO HY050G_F AUTO HY050G_I AUTO HY060G AUTO HY060G_F AUTO HY060G_I AUTO HY070G AUTO HY070G_F AUTO HY070G_I AUTO HY080G AUTO HY080G_F AUTO HY080G_I AUTO HY090G AUTO HY090G_F AUTO HY090G_I AUTO HY100G AUTO HY100G_F AUTO HY100G_I AUTO HY110G AUTO HY110G_F AUTO HY110G_I AUTO HY120G AUTO HY120G_F AUTO HY120G_I AUTO HY130G AUTO HY130G_F AUTO HY130G_I AUTO HY140G AUTO HY140G_F AUTO HY140G_I AUTO HS010 AUTO HS010_F AUTO HS020 AUTO HS020_F AUTO HS030 AUTO HS030_F AUTO HS040 AUTO HS040_F AUTO HS050 AUTO HS050_F AUTO HS060 AUTO HS060_F AUTO HS070 AUTO HS070_F AUTO HS080 AUTO HS080_F AUTO HS090 AUTO HS090_F AUTO HS100 AUTO HS100_F AUTO HS110 AUTO HS110_F AUTO HS120 AUTO HS120_F AUTO HS130 AUTO HS130_F AUTO HS140 AUTO HS140_F AUTO HS150 AUTO HS150_F AUTO HS160 AUTO HS160_F AUTO HS170 AUTO HS170_F AUTO HS180 AUTO HS180_F AUTO HS190 AUTO HS190_F AUTO HH010 AUTO HH010_F AUTO HH020 AUTO HH020_F AUTO HH030 AUTO HH030_F AUTO HH031 AUTO HH031_F AUTO HH040 AUTO HH040_F AUTO HH050 AUTO HH050_F AUTO HH060 AUTO HH060_F AUTO HH061 AUTO HH061_F AUTO HH070 AUTO HH070_F AUTO HH080 AUTO HH080_F AUTO HH090 AUTO HH090_F AUTO MH010 AUTO MH010_F AUTO MH020 AUTO MH020_F AUTO MH030 AUTO MH030_F AUTO MH040 AUTO MH040_F AUTO MH050 AUTO MH050_F AUTO MH060 AUTO MH060_F AUTO MH070 AUTO MH070_F AUTO MH080 AUTO MH080_F AUTO MH090 AUTO MH090_F AUTO MH100 AUTO MH100_F AUTO MH110 AUTO MH110_F AUTO MH120 AUTO MH120_F AUTO MH130 AUTO MH130_F AUTO MH140 AUTO MH140_F AUTO MH150 AUTO MH150_F AUTO MH160 AUTO MH160_F AUTO lastup AUTO lasttime AUTO HX040 AUTO HX050 AUTO HX090 AUTO EQ_INC23 AUTO HY20 AUTO HX080 AUTO QITILE AUTO ARPT60t AUTO HX060 AUTO HT1 AUTO HX070 AUTO TENSTA_2 AUTO OVERCROWDED AUTO HX010 AUTO ppp AUTO HY081N AUTO HY131N AUTO HY081G AUTO HY131G AUTO. DELETE VARIABLES lastup lasttime EQ_INC23 HY20 QITILE ARPT60t HT1 TENSTA_2 OVERCROWDED ppp. VARIABLE LABELS HB010 'Year of the survey'/ HB020 'Country alphanumerical'/ HB030 'Household ID'/ HB050 'Quarter of household interview' / HB050_F 'Flags' / 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'/ HY010 'Total household gross income'/ HY010_F 'Flag'/ HY010_I 'Imputation factor'/ HY020 'Total disposable household income'/ HY020_F 'Flag'/ HY020_I 'Imputation Factor'/ HY022 'Tt disp. Hhld Inc. Bef. social trnsfrs other than old-age and survivors benefits'/ HY022_F 'Flag'/ HY022_I 'Imputation Factor'/ HY023 'Tt disp. Hhld inc. Bef. social trnsfrs including old-age and survivors benefits'/ HY023_F 'Flag'/ HY023_I 'Imputation Factor'/ HY025 'Within Household non-response inflation factor'/ HY025_F 'Flag'/ HY030N 'Imputed rent (net)'/ HY030N_F 'Flag'/ HY040N 'Income from rental of a property or land(net)'/ HY040n_F 'Flag'/ HY040n_I 'Imputation factor'/ HY050N 'Family/Children related allowances (net)'/ HY050N_F 'Flag'/ HY050N_I 'Imputation factor'/ HY060N 'Social Exclusion not elsewhere classified(net)'/ HY060N_F 'Flag'/ HY060N_I 'Imputation Factor'/ HY070N 'Housing Allowances(net)'/ HY070N_F 'Flag'/ HY070N_I 'Imputation factor'/ HY080N 'Regular inter-household cash received (net)'/ HY080N_F 'Flag'/ HY080N_I 'Imputation Factor'/ HY090N 'Interests, dividends, profit from capital investment in uncorp. business (net)'/ 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)'/ HY110N_F 'Flag'/ HY110N_I 'Imputation Factor'/ HY120N 'Regular taxes on wealth(net)'/ HY120N_F 'Flag'/ HY120n_I 'Imputation Factor'/ HY130N 'Regular inter-household cash transfer paid'/ HY130N_F 'Flag'/ HY130N_I 'Imputation factor'/ HY140N 'Tax on income and social contribution'/ HY140N_F 'Flag'/ HY140N_I 'Imputation factor'/ HY145N 'Repayments/receipts for tax adjustment(net)'/ HY145N_F 'Flag'/ HY145N_I 'Imputation factor'/ HY030G 'Imputed rent (gross)'/ HY030G_F 'Flag'/ HY040G 'Income from rental of a property or land (gross)'/ HY040G_F 'Flag'/ HY040G_I 'Imputation factor'/ HY050G 'Family/Children related allowances (gross)'/ HY050G_F 'Flag'/ HY050G_I 'Imputation factor'/ HY060G 'Social Exclusion not elsewhere classified(gross)'/ HY060g_F 'Flag'/ HY060G_I 'Imputation factor'/ HY070G 'Housing allowances(gross)'/ HY070G_F 'Flag'/ HY070G_I 'Imputation factor'/ HY080G 'Regular Interhousehold cash transfer received(gross)'/ HY080G_F 'Flag'/ HY080g_I 'Imputation factor'/ HY090g 'Interests, dividends, profit from capital investment in uncorp. business (gross)'/ 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)'/ HY110g_F 'Flag'/ HY110G_I 'Imputation factor'/ HY120G 'Regular taxes on wealth(Gross)'/ HY120g_F 'Flag'/ HY120g_I 'Imputation factor'/ HY130g 'Regular interhousehold cash transfer paid(gross)'/ HY130g_F 'Flag'/ HY130g_I 'Imputation factor'/ HY140G 'Tax on income and social contributions(gross)'/ HY140G_F 'Flag'/ HY140G_I 'Imputation factor'/ HS010 'Arrears on mortgage or rent payments'/ HS010_F 'Flag'/ HS020 'Arrears on utility bills'/ HS020_F 'Flag'/ HS030 'Arrears on hire purchase instalments or other loan payments'/ HS030_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 veg. equiv.) ev. sec. day'/ HS050_F 'Flag'/ HS060 'Capacity to face unexpected financial expenses'/ HS060_F 'Flag'/ HS070 'Do you have a telephone (including mobile phone)?'/ 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 machine?'/ 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'/ HH010 'Dwelling type'/ HH010_F 'Flag'/ HH020 'Tenure status'/ Hh020_F 'Flag'/ HH030 'Number of rooms available to the household'/ 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'/ Hh080 'Bath or shower in dwelling'/ Hh080_F 'Flag'/ HH090 'Indoor flushing toilet for sole use of household'/ HH090_F 'Flag'/ MH010 'Shortage of space in dwelling'/ MH010_F 'Flag'/ MH020 'Adequate electrical installations'/ MH020_F 'Flag'/ MH030 'Adequate plumbing/water installations'/ MH030_F 'Flag'/ MH040 'Dwelling equipped with heating facilities'/ MH040_F 'Flag'/ MH050 'Dwelling comfortably warm during winter time'/ MH050_F 'Flag' / MH060 'Dwelling equipped with air conditioning facilities'/ MH060_F 'Flag'/ MH070 'Dwelling comfortably cool during summer time'/ MH070_F 'Flag'/ MH080 'Overall satisfaction with dwelling'/ MH080_F 'Flag'/ MH090 'Accessibility of grocery services'/ MH090_F 'Flag'/ MH100 'Accessibility of banking services'/ MH100_F 'Flag'/ MH110 'Accessibility of postal services'/ MH110_F 'Flag'/ MH120 'Accessibility of public transport'/ MH120_F 'Flag'/ MH130 'Accessibility of primary health care services'/ MH130_F 'Flag'/ MH140 'Accessibility of compulsory school'/ MH140_F 'Flag'/ MH150 'Change of dwelling'/ MH150_F 'Flag'/ MH160 'Main reason for change of dwelling'/ MH160_F 'Flag'/ HX040 'Household size'/ HX050 'Equivalised household Size'/ HX090 'Equivalised disposable income'/ HX080 'Poverty indicator'/ HX060 'Household type'/ HX070 'Tenure state'/ HX010 'Change rate'/ HY081G 'Alimonies received (gross)'/ HY081N 'Alimonies received (net)'/ HY131G 'Alimonies paid (gross)' HY131N 'Alimonies paid (net)'. value labels HB020 '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"/ 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'/ HY010_F 0 'no income' 1 'data collection:net' 2 'data collection:gross' 3 'data collection:net and gross' 4 'data collection:unknown' -1 'missing' -5 'not filled: no conversion to gross is done'/ HY020_F 0 'no income' 1 'data collection:net' 2 'data collection:gross' 3 'data collection:net and gross' 4 'data collection:unknown' -1 'missing' / HY022_F 0 'no income' 1 'data collection:net' 2 'data collection:gross' 3 'data collection:net and gross' 4 'data collection:unknown' -1 'missing'/ 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'/ HY025_F 1 'filled' -1 'missing'/ HY030N_F 0 'no income' 1 'income(variable is filled)' -1 'Missing' -5 'not filled: variable of gross series is filled'/ HY040N_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.' -1 'missing' -5 'not filled: variable of gross series is filled'/ HY050N_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.' 55 'unknown' -1 'missing' -5 'not filled: variable of gross series is filled'/ HY060N_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.' 55 'unknown' -1 'missing' -5 'not filled: variable of gross series is filled'/ HY070N_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.' 55 'unknown' -1 'missing' -5 'not filled: variable of gross series is filled'/ HY080N_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.' 55 'unknown' -1 'missing' -5 'not filled: variable of gross series is filled'/ HY090N_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.' 55 'unknown' 1 'net of tax on income at source and social contribution' -1 'missing' -5 'not filled: variable of gross series is filled'/ HY100n_F 0 'no income' 1 'variable is filled' -1 'missing' -5 'not filled:variable of the gross series is filled'/ HY110N_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.' 55 'unknown' -1 'missing' -5 'not filled: variable of gross series is filled'/ HY120N_F 0 'no income' 1 'variable is filled' -1 'missing' -4 'Amount included in another income component' -5 'Not filled: variable of the gross series is filled'/ HY130N_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.' 55 'unknown' -1 'missing' -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'/ HY145N_F 0 'no income' 1 'variable is filled' -1 'missing' -5 'Not filled: variable of gross series is filled'/ 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 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' -1 'missing' -5 'not filled:variable of net series is filled'/ HY050G_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' -1 'missing' -5 'not filled:variable of net series is filled'/ HY060G_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' -1 'missing' -5 'not filled:variable of net series is filled'/ HY070G_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' -1 'missing' -5 'not filled:variable of net series is filled'/ HY080G_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' -1 'missing' -5 'not filled:variable of net series is filled'/ HY090G_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' -1 'missing' -5 'not filled:variable of net series is filled'/ HY100G_F 0 'no income' 1 'variable is filled' -1 'missing' -5 'not filled: variable of net/gross series is filled'/ HY110G_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' -1 'missing' -5 'not filled:variable of net series is filled'/ HY120G_F 0 'no income' 1 'variable is filled' -1 'missing' -4 'amount included in another income component' -5 'not filled: variable of the net series is filled'/ HY130G_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' -1 'missing' -5 'not filled:variable of net series is filled'/ HY140G_F 0 'no income' 1 'variable is filled' -1 'missing' -5 'not filled: variable of the net/gross series is filled'/ HS010 1 'yes' 2 'no'/ HS010_F 1 'filled' -1 'missing' -2 'not applicable'/ HS020 1 'yes' 2 'no'/ HS020_F 1 'filled' -1 'missing' -2 'not applicable'/ HS030 1 'yes' 2 'no'/ HS030_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'/ 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 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'/ 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'/ HH020 1 'owner' 2 'tenant or subtenant paying rent at prevailing or market rate' 3 'accommodation is rented at a reduced rate(lower price than market price)' 4 'accommodation is provided free'/ HH020_F 1 'filled' -1 'missing'/ HH030 6 'six or more rooms'/ 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 'n.a. (HH020 ne 2 or 3)'/ HH061_F 1 'filled' -1 'missing' -2 'na'/ HH070_F 1 'filled' -1 'missing'/ HH080 1 'yes' 2 'no'/ HH080_F 1 'filled' -1 'missing'/ HH090 1 'yes' 2 'no'/ HH090_F 1 'filled ' -1 'missing'/ HX060 5 'one person household' 6 '2 adults no dependent children, both adults under 65 years' 7 '2 adults, no dependant children, at least one adult 65 years or more' 8 'other households with 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 households are excluded from Laeken indicators calculation)'/ MH010 1 'yes' 2 'no'/ MH010_F -1 'missing' 1 'filled'/ MH020 1 'yes' 2 'no'/ MH020_F -2 'not applicable (no electricity/installations)' -1 'missing' 1 'filled'/ MH030 1 'yes' 2 'no'/ MH030_F -2 'not applicable (no plumbing/water installtionsinstallations)' -1 'missing' 1 'filled'/ MH040 1 'yes - central heating or similar' 2 'yes - other fixed heating' 3 'no - no fixed heating'/ MH040_F -1 'missing' 1 'filled'/ MH050 1 'yes' 2 'no'/ MH050_F -1 'missing' 1 'filled'/ MH060 1 'yes' 2 'no'/ MH060_F -1 'missing' 1 'filled'/ MH070 1 'yes' 2 'no'/ MH070_F -1 'missing' 1 'filled'/ MH080 1 'very dissatisfied' 2 'somewhat dissatisfied' 3 'satisfied' 4 'very satisfied'/ MH080_F -1 'missing' 1 'filled'/ MH090 1 'with great difficulty' 2 'with some difficulty' 3 'easily' 4 'very easily'/ MH090_F -2 'n/a (services not used by household)' -1 'missing' 1 'filled'/ MH100 1 'with great difficulty' 2 'with some difficulty' 3 'easily' 4 'very easily'/ MH100_F -2 'n/a (services not used by household)' -1 'missing' 1 'filled'/ MH110 1 'with great difficulty' 2 'with some difficulty' 3 'easily' 4 'very easily'/ MH110_F -2 'n/a (services not used by household)' -1 'missing' 1 'filled'/ MH120 1 'with great difficulty' 2 'with some difficulty' 3 'easily' 4 'very easily'/ MH120_F -2 'n/a (services not used by household)' -1 'missing' 1 'filled'/ MH130 1 'with great difficulty' 2 'with some difficulty' 3 'easily' 4 'very easily'/ MH130_F -2 'n/a (services not used by household)' -1 'missing' 1 'filled'/ MH140 1 'with great difficulty' 2 'with some difficulty' 3 'easily' 4 'very easily'/ MH140_F -2 'n/a (services not used by household)' -1 'missing' 1 'filled'/ MH150 1 'yes' 2 'no'/ MH150_F -1 'missing' 1 'filled'/ MH160 1 'family related reasons' 2 'employment related reasons' 3 'housing related reasons' 4 'eviction/distraint' 5 'landlord did not prolong the contract' 6 'financial reasons' 7 'other'/ MH160_F -2 'n/a (MH150 not = 1)' -1 'missing' 1 'filled'/ 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 HH020= 1 or 4' 2 'when HH020= 2 or 3'/ 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)'. SAVE OUTFILE= !QUOTE(!CONCAT(!spss_path,'UDB_c',!i,'07H.sav')). !DOEND. *-------------------------------------------------- Compile and save final file -----------------------------------------------------------------------------------. !LET !firstfile=1. !DO !i !IN (!CC). !IF (!firstfile=1) !THEN GET FILE=!QUOTE(!CONCAT(!spss_path,'UDB_c',!i,'07H.sav')). !LET !firstfile=0. !ELSE ADD FILES FILE=* /FILE=!QUOTE(!CONCAT(!spss_path,'UDB_c',!i,'07H.sav')). !IFEND. !DOEND. SAVE OUTFILE=!QUOTE(!CONCAT(!spss_path,!finalfile,'.sav')). *--------------------------------------------------------Delete single country files -------------------------------------------------------------------------------. !DO !i !IN (!CC). ERASE FILE=!QUOTE(!CONCAT(!spss_path,'UDB_c',!i,'07H.sav')). !DOEND. !ENDDEFINE. *----------------------------------------------------------------- End definition macro ---------------------------------------------------------------. *----------------------------------------------------------------- Invoke macro ---------------------------------------------------------------------------. !C2007_H.