****************************************************************************************. * SPSS Command Syntax File * PASW Statistics 18 * Release 18.0.1 * * Transforms the EU-SILC CSV-data (as released by Eurostat) into an SPSS-Systemfile * * EU-SILC - Cross 2009 * Household data file: * UDB_c09H_ver 2009-1 from 01-03-11.csv * * (c) GESIS 2011-07-15 * GESIS - Leibniz Institute for the Social Sciences * German Microdata Lab * Verena Lichtenberger; Heike Wirth * * http://www.gesis.org/en/institute/ * http://www.gesis.org/en/services/data-analysis/official-microdata/european-microdata/eu-silc/eu-silc-tools/ * * Contact: heike.wirth@gesis.org ***************************************************************************************. set decimal dot. * When using SPSS earlier than V16 you might not use "set unicode" . set unicode no. * The following command should contain the complete path and name of the raw data file; Change CSV_DATA_FILENAME to your filename . file handle csv_data / name = "CSV_DATA_FILENAME" . * The following command should contain the complete path and name of the SPSS file, usual file extension "sav"; Change SPSS_FILENAME to your filename . file handle spss_reference / name = "SPSS_FILENAME" . * There should be probably nothing to change below this line . * - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - .set decimal dot. GET DATA /TYPE=TXT /FILE=csv_data /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 COMMA7.0 HY022 COMMA9.0 HY022_F F1.0 HY022_I COMMA7.0 HY023 COMMA9.0 HY023_F F1.0 HY023_I COMMA7.0 HY025 COMMA7.0 HY025_F F1.0 HY030N COMMA8.0 HY030N_F F1.0 HY040N COMMA8.0 HY040N_F F2.0 HY040N_I COMMA7.0 HY050N COMMA8.0 HY050N_F F2.0 HY050N_I COMMA7.0 HY060N COMMA7.0 HY060N_F F2.0 HY060N_I COMMA7.0 HY070N COMMA7.0 HY070N_F F2.0 HY070N_I COMMA7.0 HY080N COMMA8.0 HY080N_F F2.0 HY080N_I COMMA7.0 HY081N COMMA8.0 HY081N_F F2.0 HY081N_I COMMA9.0 HY090N COMMA8.0 HY090N_F F2.0 HY090N_I COMMA7.0 HY100N COMMA7.0 HY100N_F F1.0 HY100N_I COMMA9.0 HY110N COMMA7.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 HY131N COMMA8.0 HY131N_F F1.0 HY131N_I COMMA9.0 HY140N COMMA8.0 HY140N_F F1.0 HY140N_I COMMA9.0 HY145N COMMA8.0 HY145N_F F1.0 HY145N_I COMMA7.0 HY030G COMMA8.0 HY030G_F F1.0 HY040G COMMA8.0 HY040G_F F1.0 HY040G_I COMMA7.0 HY050G COMMA8.0 HY050G_F F1.0 HY050G_I COMMA7.0 HY060G COMMA7.0 HY060G_F F1.0 HY060G_I COMMA7.0 HY070G COMMA7.0 HY070G_F F1.0 HY070G_I COMMA7.0 HY080G COMMA8.0 HY080G_F F1.0 HY080G_I COMMA7.0 HY081G F1.0 HY081G_F F1.0 HY081G_I COMMA9.0 HY090G COMMA8.0 HY090G_F F1.0 HY090G_I COMMA7.0 HY100G COMMA7.0 HY100G_F F1.0 HY100G_I COMMA9.0 HY110G COMMA7.0 HY110G_F F1.0 HY110G_I COMMA7.0 HY120G COMMA9.0 HY120G_F F1.0 HY120G_I COMMA9.0 HY130G COMMA8.0 HY130G_F F1.0 HY130G_I COMMA7.0 HY131G F1.0 HY131G_F F1.0 HY131G_I COMMA9.0 HY140G COMMA8.0 HY140G_F F1.0 HY140G_I COMMA9.0 HS010 F1.0 HS010_F F2.0 HS011 F1.0 HS011_F F2.0 HS020 F1.0 HS020_F F2.0 HS021 F1.0 HS021_F F1.0 HS030 F1.0 HS030_F F2.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 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 F1.0 HH020 F1.0 HH020_F F1.0 HH030 F1.0 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 COMMA8.0 HH060_F F2.0 HH061 COMMA7.0 HH061_F F2.0 HH070 COMMA8.0 HH070_F F2.0 HH080 F1.0 HH080_F F1.0 HH081 F1.0 HH081_F F2.0 HH090 F1.0 HH090_F F1.0 HH091 F1.0 HH091_F F2.0 HD010 F1.0 HD010_F F1.0 HD020 F1.0 HD020_F F1.0 HD025 F1.0 HD025_F F1.0 HD030 F1.0 HD030_F F1.0 HD035 F3.0 HD035_F F1.0 HD040 F1.0 HD040_F F1.0 HD050 F1.0 HD050_F F1.0 HD060 F1.0 HD060_F F1.0 HD070 F1.0 HD070_F F1.0 HD080 F1.0 HD080_F F1.0 HD090 F1.0 HD090_F F1.0 HD100 F1.0 HD100_F F1.0 HD110 F1.0 HD110_F F1.0 HD120 F1.0 HD120_F F1.0 HD130 F1.0 HD130_F F1.0 HD140 F1.0 HD140_F F1.0 HD150 F1.0 HD150_F F1.0 HD160 F1.0 HD160_F F1.0 HD170 F1.0 HD170_F F1.0 HD180 F1.0 HD180_F F1.0 HD190 F1.0 HD190_F F1.0 HD200 F1.0 HD200_F F1.0 HD210 F1.0 HD210_F F1.0 HD220 F1.0 HD220_F F1.0 HD230 F1.0 HD230_F F1.0 HD240 F1.0 HD240_F F1.0 HD250 F1.0 HD250_F F1.0 HD255 F1.0 HD255_F F1.0 HD260 F1.0 HD260_F F1.0 HD265 F1.0 HD265_F F1.0 HX040 F2.0 HX050 COMMA4.0 HX090 COMMA12.0 HX080 F1.0 HX060 F2.0 HX070 F1.0 HX020 F1.0 HX010 COMMA9.0. VARIABLE LABELS HB010 'Year of the survey'/ HB020 'country'/ 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 'Total Disposable Household Income before social transfers other than old-age and survivors benefits'/ HY022_F 'Flag'/ HY022_I 'Imputation Factor'/ HY023 'Total disposable Household income before social transfers incl 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 transfer received (net)'/ HY080N_F 'Flag'/ HY080N_I 'Imputation Factor'/ HY081N 'Alimonies received (net)'/ HY081N_F 'Flag'/ HY081N_I 'Imputation Factor'/ HY090N 'Interests,dividends,profit from capital investment in uncorporated 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'/ HY131N 'Alimonies paid (net)'/ HY131N_F 'Flag'/ HY131N_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'/ HY081G 'Alimonies received (gross)'/ HY081G_F 'Flag'/ HY081G_I 'Imputation Factor'/ HY090G 'Interests,dividends,profit from capital investment in uncorporated 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'/ HY131G 'Alimonies paid (gross)'/ HY131G_F 'Flag'/ HY131G_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'/ HS011 ' Arrears on Mortgage or Rent Payments'/ HS011_F 'Flag'/ HS020 'Arrears on utility bills'/ HS020_F 'Flag'/ HS021 'Arrears on utility bills'/ HS021_F 'Flag'/ HS030 'Arrears on Hire purchase instalments or other loan payments'/ HS030_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 (incl 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'/ HH081 'Bath or shower in Dwelling'/ HH081_F 'Flag'/ HH090 'Indoor flushing toilet for sole use of household'/ HH090_F 'Flag'/ HH091 'Indoor flushing toilet for sole use of household'/ HH091_F 'Flag'/ HD010 'Place to live with hot running water'/ HD010_F 'Flag'/ HD020 'Expectation of household to change dwelling'/ HD020_F 'Flag'/ HD025 'Main reason for the expactation to change dwelling'/ HD025_F 'Flag'/ HD030 'Shortage of space in dwelling'/ HD030_F 'Flag'/ HD035 'Size of dwelling in square metres'/ HD035_F 'Flag'/ HD040 'Litter lying around in the neighbourhood'/ HD040_F 'Flag'/ HD050 'Damaged public amenities (bus stops, lamp posts, pavements, etc.) in the neighbourhood'/ HD050_F 'Flag'/ HD060 'Accessibility of public transport'/ HD060_F 'Flag'/ HD070 'Accessibility of postal or banking services'/ HD070_F 'Flag'/ HD080 'Replacing worn-out furniture'/ HD080_F 'Flag'/ HD090 'Internet connection'/ HD090_F 'Flag'/ HD100 'Some new (not second-hand) clothes'/ HD100_F 'Flag'/ HD110 'Two pairs of properly fitting shoes (including a pair of all-weather shoes)'/ HD110_F 'Flag'/ HD120 'Fresh fruit and vegetables once a day'/ HD120_F 'Flag'/ HD130 'Three meals a day'/ HD130_F 'Flag'/ HD140 'One mealwith meat, chickenor fish (or vegetarian equivalant) at least once a day'/ HD140_F 'Flag'/ HD150 'Books at home suitable for theit age'/ HD150_F 'Flag'/ HD160 'Outdoor leisure equipment (bicycle, roller skates, etc.)'/ HD160_F 'Flag'/ HD170 'Indoor games (educational baby toys, building blocks, board games, computergames, etc.)'/ HD170_F 'Flag'/ HD180 'Regular leisure activity (swimming, playing an instrument, youth organisations, etc.)'/ HD180_F 'Flag'/ HD190 'Celebrations on special occasions (birthdays, name days, religious events, etc.)'/ HD190_F 'Flag'/ HD200 'Invite friends round to play and eat from time to time'/ HD200_F 'Flag'/ HD210 'participate in school trips and school eventsthat cost money'/ HD210_F 'Flag'/ HD220 'Suitableplace to study or do homework'/ HD220_F 'Flag'/ HD230 'Outdoor space in the neighbourhood where children can play safely'/ HD230_F 'Flag'/ HD240 'Go on holiday away from home at least 1 week per year'/ HD240_F 'Flag'/ HD250 'unmet need for consulting a gp or specialist, excluding dentists a and ophthalmologists'/ HD250_F 'Flag'/ HD255 'main reason for unmet need for consulting a gp or specialist, excluding dentists a and ophthalmologists'/ HD255_F 'Flag'/ HD260 'unmet need for consulting a dentist'/ HD260_F 'Flag'/ HD265 'main reason for unmet need for consulting a dentist'/ HD265_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'/ HX010 'Change rate'. Value labels HB020 'BE' "Belgique" 'BG' "Bulgaria" 'CZ' "Czech Republic" 'DK' "Danmark" 'DE' "Deutschland" 'EE' "Estonia" 'IE' "Ireland" 'GR' "Ellada" 'ES' "Espana" 'FR' "France" 'IT' "Italia" 'CY' "Cyprus" 'LV' "Latvia" 'LT' "Lithuania" 'LU' "Luxembourg" 'HU' "Hungary" 'MT' "Malta" 'NL' "Nederland" 'AT' "Oesterreich" 'PL' "Poland" 'PT' "Portugal" 'RO' "Romania" 'SI' "Slovenia" 'SK' "Slovak Republic" 'FI' "Suomi" 'SE' "Sverige" 'UK' "United Kingdom" 'Ch' "Switzerland" 'HR' "Croatia" 'IS' "Iceland" 'NO' "Norway" 'TR' "Turkey"/ 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' 43 'collected gross/recorded net of tax on social contrib.' 51 'collected unknown/recorded net of tax on income & social contrib.' 55 'unknown' -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' 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 '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' 43 'collected gross/recorded net of tax on social contrib.' 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'/ HY081N_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' 43 'collected gross/recorded net of tax on social contrib.' 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.' 12 'collec. net of tax on inc. at source & soc. contrib./recorded net of tax on inc. at source' 22 'collec. & recorded net of tax on income at source' 31 'collected net of tax on social contrib./recorded net of tax on income & social contrib.' 33 'collected & recorded net of tax on social contrib.' 41 'collected gross/recorded net of tax on income & social contrib.' 42 'collected gross/recorded net of tax on income at source' 43 'collected gross/recorded net of tax on social contrib.' 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'/ HY131N_F 0 'none' 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'/ HY081G_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'/ HY131G_F 0 'none' 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' -5 'missing value of HS010 because HS011 is used'/ HS011 1 'yes, once' 2 'yes, twice or more' 3 'no'/ HS011_F 1 'filled' -1 'missing' -2 'not applicable' -5 'missing value of HS011 because HS010 is still used'/ HS020 1 'yes' 2 'no'/ HS020_F 1 'filled' -1 'missing' -2 'not applicable' -5 'missing value of HS020 because HS021 is used'/ HS021 1 'yes,once' 2 'yes,twice or more' 3 'no'/ HS021_F 1 'filled' -1 'missing' -2 'not applicable' -5 'missing value of HS021 because HS020 is still used'/ HS030 1 'yes' 2 'no'/ HS030_F 1 'filled' -1 'missing' -2 'not applicable' -5 'missing value of HS030 because HS031 is used'/ HS031 1 'yes,once' 2 'yes,twice or more' 3 'no'/ HS031_F 1 'filled' -1 'missing' -2 'not applicable' -5 'missing value of HS031 because HS030 is still used'/ 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 'a slight burden' 3 'not 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'/ 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.(MS using objective national methods to calculate imputed rent)'/ 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' -5 'missing value of HH080 because HH081 is used'/ HH081 1 'yes, for sole use of the household' 2 'yes, shared' 3 'no'/ HH081_F 1 'filled' -1 'missing' -5 'missing value of HH081 because HH080 is still used'/ HH090 1 'yes' 2 'no'/ HH090_F 1 'filled ' -1 'missing' -5 'missing value of HH090 because HH091 is used'/ HH091 1 'yes, for sole use of the household' 2 'yes, shared' 3 'no'/ HH091_F 1 'filled ' -1 'missing' -5 'missing value of HH091 because HH090 is still used'/ HD010 1 'yes' 2 'no'/ HD010_F 1 'filled' -1 'missing'/ HD020 1 'yes' 2 'no'/ HD020_F 1 'filled' -1 'missing'/ HD025 1 'Household will be forced to leave, since notice has been/will be given on termination of the contract' 2 'Household will be forced to leave, since notice has been/will be given in the absence of a formal contract' 3 'Household will be forced to leave because of eviction or distraint' 4 'Household will be forced to leave for financial difficulties' 5 'Household will leave for a family-related reason' 6 'Household will leave for an employment-related reason' 7 'Household will leave for some other reason'/ HD025_F 1 'filled' -1 'missing' -2 'not applicable (HD020=2)'/ HD030 1 'yes' 2 'no'/ HD030_F 1 'filled' -1 'missing'/ HD035_F 1 'filled' -1 'missing'/ HD040 1 'Very frequently' 2 'Frequently' 3 'Sometimes' 4 'Rarely or never'/ HD040_F 1 'filled' -1 'missing'/ HD050 1 'Very frequently' 2 'Frequently' 3 'Sometimes' 4 'Rarely or never'/ HD050_F 1 'filled' -1 'missing'/ HD060 1 'with great difficulty' 2 'with some difficulty' 3 'easily' 4 'very easily'/ HD060_F 1 'filled' -1 'missing' -2 'n/a (services not used by household)'/ HD070 1 'with great difficulty' 2 'with some difficulty' 3 'easily' 4 'very easily'/ HD070_F 1 'filled' -1 'missing' -2 'n/a (services not used by household)'/ HD080 1 'Yes' 2 'No, because the household cannot afford it' 3 'No, for some other reason'/ HD080_F 1 'filled' -1 'missing'/ HD090 1 'Yes' 2 'No, because the household cannot afford it' 3 'No, for some other reason'/ HD090_F 1 'filled' -1 'missing'/ HD100 1 'Yes' 2 'No, because the household cannot afford it' 3 'No, for some other reason'/ HD100_F 1 'filled' -1 'missing' -2 'not applicable (no children aged under 16)' -4 'not applicable because no children aged above 1'/ HD110 1 'Yes' 2 'No, because the household cannot afford it' 3 'No, for some other reason'/ HD110_F 1 'filled' -1 'missing' -2 'not applicable (no children aged under 16)' -4 'not applicable because no children aged above 1'/ HD120 1 'Yes' 2 'No, because the household cannot afford it' 3 'No, for some other reason'/ HD120_F 1 'filled' -1 'missing' -2 'not applicable (no children aged under 16)' -4 'not applicable because no children aged above 1'/ HD130 1 'Yes' 2 'No, because the household cannot afford it' 3 'No, for some other reason'/ HD130_F 1 'filled' -1 'missing' -2 'not applicable (no children aged under 16)' -4 'not applicable because no children aged above 1'/ HD140 1 'Yes' 2 'No, because the household cannot afford it' 3 'No, for some other reason'/ HD140_F 1 'filled' -1 'missing' -2 'not applicable (no children aged under 16)' -4 'not applicable because no children aged above 1'/ HD150 1 'Yes' 2 'No, because the household cannot afford it' 3 'No, for some other reason'/ HD150_F 1 'filled' -1 'missing' -2 'not applicable (no children aged under 16)' -4 'not applicable because no children aged above 1'/ HD160 1 'Yes' 2 'No, because the household cannot afford it' 3 'No, for some other reason'/ HD160_F 1 'filled' -1 'missing' -2 'not applicable (no children aged under 16)' -4 'not applicable because no children aged above 1'/ HD170 1 'Yes' 2 'No, because the household cannot afford it' 3 'No, for some other reason'/ HD170_F 1 'filled' -1 'missing' -2 'not applicable (no children aged under 16)' -4 'not applicable because no children aged above 1'/ HD180 1 'Yes' 2 'No, because the household cannot afford it' 3 'No, for some other reason'/ HD180_F 1 'filled' -1 'missing' -2 'not applicable (no children aged under 16)' -4 'not applicable because no children aged above 1'/ HD190 1 'Yes' 2 'No, because the household cannot afford it' 3 'No, for some other reason'/ HD190_F 1 'filled' -1 'missing' -2 'not applicable (no children aged under 16)' -4 'not applicable because no children aged above 1'/ HD200 1 'Yes' 2 'No, because the household cannot afford it' 3 'No, for some other reason'/ HD200_F 1 'filled' -1 'missing' -2 'not applicable (no children aged under 16)' -4 'not applicable because no children aged above 1'/ HD210 1 'Yes' 2 'No, because the household cannot afford it' 3 'No, for some other reason'/ HD210_F 1 'filled' -1 'missing' -2 'not applicable (no children aged under 16)' -4 'not applicable because no children attending school'/ HD220 1 'Yes' 2 'No'/ HD220_F 1 'filled' -1 'missing' -2 'not applicable (no children aged under 16)' -4 'not applicable because no children attending school'/ HD230 1 'Yes' 2 'No'/ HD230_F 1 'filled' -1 'missing' -2 'not applicable (no children aged under 16)'/ HD240 1 'Yes' 2 'No, because the household cannot afford it' 3 'No, for some other reason'/ HD240_F 1 'filled' -1 'missing' -2 'not applicable (no children aged under 16)'/ HD250 1 'Yes, there was at least one occasion' 2 'No, there was no occasion'/ HD250_F 1 'filled' -1 'missing' -2 'not applicable (no children aged under 16)'/ HD255 1 'Could not afford to (too expensive)' 2 'Waiting list' 3 'Could not take the time because of work, care of other children or of other persons' 4 'Too far to travel/no means of transport' 5 'Other reason'/ HD255_F 1 'filled' -1 'missing' -2 'not applicable (HD250=2)'/ HD260 1 'Yes, there was at least one occasion' 2 'No, there was no occasion'/ HD260_F 1 'filled' -1 'missing' -2 'not applicable (no children aged under 16)'/ HD265 1 'Could not afford to (too expensive)' 2 'Waiting list' 3 'Could not take the time because of work, care of other children or of other persons' 4 'Too far to travel/no means of transport' 5 'Other reason'/ HD265_F 1 'filled' -1 'missing' -2 'not applicable (HD260=2)'/ 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=spss_reference /COMPRESSED.