* 2012_cross_eu_silc_h_ver_2021_09.do * * STATA Command Syntax File * Stata 17; * * Transforms the EU-SILC CSV-data (as released by Eurostat) into a Stata systemfile * * EU-SILC Cross 2012 - release 2021-09 / DOI: https://doi.org/10.2907/EUSILC2004-2020V.1 * * When publishing statistics derived from the EU-SILC UDB, please state as source: * "EU-SILC UDB – version of 2021-09" * * Household data file: * This version of the EU-SILC has been delivered in form of seperate country files. * The following do-file transforms the raw data into a single Stata file using all available country files. * Country files are delivered in the format UDB_l*country_stub*12H.csv * * (c) GESIS 2022-02-08 * * PLEASE NOTE * For Differences between data as described in the guidelines * and the anonymised user database as well as country specific anonymisation measures see: * L-2012 DIFFERENCES BETWEEN DATA COLLECTED.doc * * This Stata-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): 2012_cross_eu_silc_h_ver_2021_09.do. * Stata-Syntax for transforming EU-SILC csv data into a Stata-Systemfile. * * https://www.gesis.org/gml/european-microdata/eu-silc/ * * Contact: klaus.pforr@gesis.org /* Initialization commands */ clear capture log close set more off set linesize 250 set varabbrev off #delimit ; * - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -; * CONFIGURATION SECTION - Start ; * The following command should contain the complete path and * name of the Stata log file. * Change LOG_FILENAME to your filename ; local log_file "LOG_FILENAME" ; * The following command should contain the complete path where the CSV data files are stored * Change CSV_PATH to your file path (e.g.: C:/EU-SILC/Crossectional 2004-2020) * Use forward slashes and keep path structure as delivered by Eurostat CSV_PATH/COUNTRY/YEAR; global csv_path "CSV_PATH" ; * The following command should contain the complete path and * name of the STATA file, usual file extension "dta". * Change STATA_FILENAME to your final filename ; local stata_file "STATA_FILENAME" ; * CONFIGURATION SECTION - End ; * There should be probably nothing to change below this line ; * - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ; * Loop to open and convert csv files into one dta file ; tempfile temp ; save `temp', emptyok ; foreach CC in 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 SE SI SK UK { ; cd "$csv_path/`CC'/2012" ; import delimited using "UDB_c`CC'12H.csv", case(upper) asdouble clear ; append using `temp', force ; save `temp', replace ; } ; * Countries in data file are sorted in alphanumeric order ; sort HB020 ; log using "`log_file'", replace text ; * Definition of variable labels ; label variable HB010 "Year of the survey" ; label variable HB020 "Country alphanumeric" ; label variable HB030 "Household ID" ; label variable HB050 "Quarter of household interview" ; label variable HB050_F "Flag" ; label variable HB060 "Year of household interview" ; label variable HB060_F "Flag" ; label variable HB070 "Person responding to household questionnaire" ; label variable HB070_F "Flag" ; label variable HB080 "Person 1 responsible for the accommodation" ; label variable HB080_F "Flag" ; label variable HB090 "Person 2 responsible for the accommodation" ; label variable HB090_F "Flag" ; label variable HB100 "Number of minutes to complete the household questionnaire" ; label variable HB100_F "Flag" ; label variable HY010 "Total household gross income" ; label variable HY010_F "Flag" ; label variable HY010_I "Imputation factor" ; label variable HY020 "Total disposable household income" ; label variable HY020_F "Flag" ; label variable HY020_I "Imputation factor" ; label variable HY022 "Tt disp. Hhld Inc. Bef. social trnsfrs other than old-age and survivors benefits" ; label variable HY022_F "Flag" ; label variable HY022_I "Imputation factor" ; label variable HY023 "Tt disp. Hhld inc. Bef. social trnsfrs including old-age and survivors benefits" ; label variable HY023_F "Flag" ; label variable HY023_I "Imputation factor" ; label variable HY025 "Within household non-response inflation factor" ; label variable HY025_F "Flag" ; label variable HY030N "Imputed rent (net)" ; label variable HY030N_F "Flag" ; label variable HY040N "Income from rental of a property or land (net)" ; label variable HY040N_F "Flag" ; label variable HY040N_I "Imputation factor" ; label variable HY050N "Family/Children-related allowances (net)" ; label variable HY050N_F "Flag" ; label variable HY050N_I "Imputation factor" ; label variable HY060N "Social exclusion not elsewhere classified (net)" ; label variable HY060N_F "Flag" ; label variable HY060N_I "Imputation factor" ; label variable HY070N "Housing allowances (net)" ; label variable HY070N_F "Flag" ; label variable HY070N_I "Imputation factor" ; label variable HY080N "Regular interhousehold cash received (net)" ; label variable HY080N_F "Flag" ; label variable HY080N_I "Imputation factor" ; label variable HY090N "Interests, dividends, profit from capital investment in uncorp. business (net)" ; label variable HY090N_F "Flag" ; label variable HY090N_I "Imputation factor" ; label variable HY100N "Interest Repayment on mortgage (net)" ; label variable HY100N_F "Flag" ; label variable HY100N_I "Imputation factor" ; label variable HY110N "Income received by people aged under 16 (net)" ; label variable HY110N_F "Flag" ; label variable HY110N_I "Imputation factor" ; label variable HY120N "Regular taxes on wealth (net)" ; label variable HY120N_F "Flag" ; label variable HY120N_I "Imputation factor" ; label variable HY130N "Regular interhousehold cash transfer paid" ; label variable HY130N_F "Flag" ; label variable HY130N_I "Imputation factor" ; label variable HY140N "Tax on income and social contribution" ; label variable HY140N_F "Flag" ; label variable HY140N_I "Imputation factor" ; label variable HY145N "Repayments/receipts for tax adjustment (net)" ; label variable HY145N_F "Flag" ; label variable HY145N_I "Imputation factor" ; label variable HY030G "Imputed rent (gross)" ; label variable HY030G_F "Flag" ; label variable HY040G "Income from rental of a property or land (gross)" ; label variable HY040G_F "Flag" ; label variable HY040G_I "Imputation factor" ; label variable HY050G "Family/Children-related allowances (gross)" ; label variable HY050G_F "Flag" ; label variable HY050G_I "Imputation factor" ; label variable HY060G "Social exclusion not elsewhere classified (gross)" ; label variable HY060G_F "Flag" ; label variable HY060G_I "Imputation factor" ; label variable HY070G "Housing allowances (gross)" ; label variable HY070G_F "Flag" ; label variable HY070G_I "Imputation factor" ; label variable HY080G "Regular interhousehold cash transfer received (gross)" ; label variable HY080G_F "Flag" ; label variable HY080G_I "Imputation factor" ; label variable HY090G "Interests, dividends, profit from capital investment in uncorp. business (gross)" ; label variable HY090G_F "Flag" ; label variable HY090G_I "Imputation factor" ; label variable HY100G "Interest repayments on mortgage (gross)" ; label variable HY100G_F "Flag" ; label variable HY100G_I "Imputation factor" ; label variable HY110G "Income received by people aged under 16 (gross)" ; label variable HY110G_F "Flag" ; label variable HY110G_I "Imputation factor" ; label variable HY120G "Regular taxes on wealth (gross)" ; label variable HY120G_F "Flag" ; label variable HY120G_I "Imputation factor" ; label variable HY130G "Regular interhousehold cash transfer paid (gross)" ; label variable HY130G_F "Flag" ; label variable HY130G_I "Imputation factor" ; label variable HY140G "Tax on income and social contributions (gross)" ; label variable HY140G_F "Flag" ; label variable HY140G_I "Imputation factor" ; label variable HS011 "Arrears on mortgage or rent payments" ; label variable HS011_F "Flag" ; label variable HS021 "Arrears on utility bills" ; label variable HS021_F "Flag" ; label variable HS031 "Arrears on hire purchase instalments or other loan payments" ; label variable HS031_F "Flag" ; label variable HS040 "Capacity to afford paying for one week annual holiday away from home" ; label variable HS040_F "Flag" ; label variable HS050 "Capacity to afford a meal with meat, chicken, fish (or veg. equiv.) ev. sec. day" ; label variable HS050_F "Flag" ; label variable HS060 "Capacity to face unexpected financial expenses" ; label variable HS060_F "Flag" ; label variable HS070 "Do you have a telephone (including mobile phone)?" ; label variable HS070_F "Flag" ; label variable HS080 "Do you have a colour TV?" ; label variable HS080_F "Flag" ; label variable HS090 "Do you have a computer?" ; label variable HS090_F "Flag" ; label variable HS100 "Do you have a washing machine?" ; label variable HS100_F "Flag" ; label variable HS110 "Do you have a car?" ; label variable HS110_F "Flag" ; label variable HS120 "Ability to make ends meet" ; label variable HS120_F "Flag" ; label variable HS130 "Lowest monthly income to make end meet" ; label variable HS130_F "Flag" ; label variable HS140 "Financial burden of the total housing cost" ; label variable HS140_F "Flag" ; label variable HS150 "Financial burden of the repayment of debts from hire purchases or loans" ; label variable HS150_F "Flag" ; label variable HH010 "Dwelling type" ; label variable HH010_F "Flag" ; label variable HH030 "Number of rooms available to the household" ; label variable HH030_F "Flag" ; label variable HH031 "Year of contract or purchasing or installation" ; label variable HH031_F "Flag" ; label variable HH040 "Leaking roof, damp walls/floors/foundation, or rot in window frame or floor" ; label variable HH040_F "Flag" ; label variable HH050 "Ability to keep home adequately warm" ; label variable HH050_F "Flag" ; label variable HH060 "Current rent related to occupied dwelling" ; label variable HH060_F "Flag" ; label variable HH061 "Subjective rent" ; label variable HH061_F "Flag" ; label variable HH081 "Bath or shower in dwelling" ; label variable HH081_F "Flag" ; label variable HH091 "Indoor flushing toilet for sole use of household" ; label variable HH091_F "Flag" ; label variable HX040 "Household size" ; label variable HX050 "Equivalised household size" ; label variable HX090 "Equivalised disposable income" ; label variable HX010 "Change rate" ; label variable HY081G "Alimonies received (gross)" ; label variable HY081G_F "Flag" ; label variable HY081G_I "Imputation factor" ; label variable HY081N "Alimonies received (net)" ; label variable HY081N_F "Flag" ; label variable HY081N_I "Imputation factor" ; label variable HY131G "Alimonies paid (gross)" ; label variable HY131G_F "Flag" ; label variable HY131G_I "Imputation factor" ; label variable HY131N "Alimonies paid (net)" ; label variable HY131N_F "Flag" ; label variable HY131N_I "Imputation factor" ; label variable HX120 "Overcrowded household"; label variable HX060 "Household type"; label variable HX070 "Tenure status"; label variable HH070 "Total housing cost" ; label variable HH070_F "Flag" ; label variable HH071 "Mortgage principal repayment" ; label variable HH071_F "Flag" ; label variable HH021 "Tenure status" ; label variable HH021_F "Flag" ; label variable HS160 "Problems with the dwelling: Too dark, not enough light" ; label variable HS160_F "Flag" ; label variable HS170 "Noise from neighbours or from the street" ; label variable HS170_F "Flag" ; label variable HS180 "Pollution, grime or other environmental problems" ; label variable HS180_F "Flag" ; label variable HS190 "Crime, violence or vandalism in the area" ; label variable HS190_F "Flag" ; label variable HY170G "Value of goods produced for own consumption (gross)" ; label variable HY170G_F "Flag" ; label variable HY170G_I "Imputation factor" ; label variable HY170N "Value of goods produced for own consumption (net)" ; label variable HY170N_F "Flag" ; label variable HY170N_I "Imputation factor" ; label variable HX080 "Poverty indicator" ; label variable HC010 "Shortage of space in the dwelling" ; label variable HC010_F "Flag" ; label variable HC020 "Size of the dwelling in square meters" ; label variable HC020_F "Flag" ; label variable HC030 "Adequate electrical installations" ; label variable HC030_F "Flag" ; label variable HC040 "Adequate plumbing/water installations" ; label variable HC040_F "Flag" ; label variable HC050 "Dwelling equipped with heating facilities" ; label variable HC050_F "Flag" ; label variable HC060 "Dwelling comfortably warm during winter time" ; label variable HC060_F "Flag" ; label variable HC070 "Dwelling comfortably cool during summer time" ; label variable HC070_F "Flag" ; label variable HC080 "Overall satisfaction with the dwelling" ; label variable HC080_F "Flag" ; label variable HC090 "Accessibility of grocery services" ; label variable HC090_F "Flag" ; label variable HC100 "Accessibility of banking services" ; label variable HC100_F "Flag" ; label variable HC110 "Accessibility of postal services" ; label variable HC110_F "Flag" ; label variable HC120 "Accessibility of public transport" ; label variable HC120_F "Flag" ; label variable HC130 "Accessibility of primary health care services" ; label variable HC130_F "Flag" ; label variable HC140 "Accessibility of compulsory school" ; label variable HC140_F "Flag" ; label variable HC150 "Immediate risk of changing the dwelling" ; label variable HC150_F "Flag" ; label variable HC160 "Main reason for the expectation to be forced to leave the dwelling" ; label variable HC160_F "Flag" ; * Definition of category labels ; label define HB050_VALUE_LABELS 1 "January,February,March" 2 "April, May, June" 3 "July, August, September" 4 "October, November, December" ; label define HB050_F_VALUE_LABELS 1 "filled" -1 "missing" ; label define HB060_F_VALUE_LABELS 1 "filled" ; label define HB070_F_VALUE_LABELS 1 "filled" -1 "missing" ; label define HB080_F_VALUE_LABELS 1 "filled" -1 "missing" ; label define HB090_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "not applicable (no 2nd responsible)" ; label define HB100_F_VALUE_LABELS 1 "filled" -1 "missing" ; label define HY010_F_VALUE_LABELS 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" ; label define HY020_F_VALUE_LABELS 0 "no income" 1 "data collection:net" 2 "data collection:gross" 3 "data collection:net and gross" 4 "data collection:unknown" -1 "missing" ; label define HY022_F_VALUE_LABELS 0 "no income" 1 "data collection:net" 2 "data collection:gross" 3 "data collection:net and gross" 4 "data collection:unknown" -1 "missing" ; label define HY023_F_VALUE_LABELS 0 "no income" 1 "data collection:net" 2 "data collection:gross" 3 "data collection:net and gross" 4 "data collection:unknown" -1 "missing" ; label define HY025_F_VALUE_LABELS 1 "filled" -1 "missing" ; label define HY030N_F_VALUE_LABELS 0 "no income" 1 "income(variable is filled)" -1 "Missing" -2 "value not defined in data documentation" -5 "not filled: variable of gross series is filled" ; label define HY040N_F_VALUE_LABELS 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 "collec. net of tax on social contrib.recorded net of tax on income & social contrib." 33 "collec. & recorded net of tax on social contrib." 41 "collec. gross-recorded net of tax on income & social contrib." 42 "collec. gross-recorded net of tax on income at source" 43 "collec. gross-recorded net of tax on social contrib." 51 "collec. unknownrecorded net of tax on income & social contrib." 52 "collec. unknown-recorded net of tax on income at source" 53 "collec. unknown-recorded net of tax on social contrib." 55 "unknown" 61 "mix(parts of the component collec. according to different ways/deductive imputation)" -1 "missing" -5 "not filled: variable of gross series is filled" ; label define HY050N_F_VALUE_LABELS 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 "collec. net of tax on social contrib.recorded net of tax on income & social contrib." 33 "collec. & recorded net of tax on social contrib." 41 "collec. gross-recorded net of tax on income & social contrib." 42 "collec. gross-recorded net of tax on income at source" 43 "collec. gross-recorded net of tax on social contrib." 51 "collec. unknown-recorded net of tax on income & social contrib." 52 "collec. unknown-recorded net of tax on income at source" 53 "collec. unknown-recorded net of tax on social contrib." 55 "unknown" 61 "mix(parts of the component collec. according to different ways/deductive imputation)" -1 "missing" -5 "not filled: variable of gross series is filled" ; label define HY060N_F_VALUE_LABELS 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 "collec. net of tax on social contrib.recorded net of tax on income & social contrib." 33 "collec. & recorded net of tax on social contrib." 41 "collec. gross-recorded net of tax on income & social contrib." 42 "collec. gross-recorded net of tax on income at source" 43 "collec. gross-recorded net of tax on social contrib." 51 "collec. unknown-recorded net of tax on income & social contrib." 52 "collec. unknown-recorded net of tax on income at source" 53 "collec. unknown-recorded net of tax on social contrib." 55 "unknown" 61 "mix(parts of the component collec. according to different ways/deductive imputation)" -1 "missing" -5 "not filled: variable of gross series is filled" ; label define HY070N_F_VALUE_LABELS 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 "collec. net of tax on social contrib.recorded net of tax on income & social contrib." 33 "collec. & recorded net of tax on social contrib." 41 "collec. gross-recorded net of tax on income & social contrib." 42 "collec. gross-recorded net of tax on income at source" 51 "collec. unknown-recorded net of tax on income & social contrib." 55 "unknown" 61 "mix(parts of the component collec. according to different ways/deductive imputation)" -1 "missing" -5 "not filled: variable of gross series is filled" ; label define HY080N_F_VALUE_LABELS 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 "collec. net of tax on social contrib.recorded net of tax on income & social contrib." 33 "collec. & recorded net of tax on social contrib." 41 "collec. gross-recorded net of tax on income & social contrib." 42 "collec. gross-recorded net of tax on income at source" 51 "collec. unknown-recorded net of tax on income & social contrib." 55 "unknown" 61 "mix(parts of the component collec. according to different ways/deductive imputation)" -1 "missing" -5 "not filled: variable of gross series is filled" ; label define HY081N_F_VALUE_LABELS 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 "collec. net of tax on social contrib.;recorded net of tax on income & social contrib." 33 "collec. & recorded net of tax on social contrib." 41 "collec. gross-recorded net of tax on income & social contrib." 42 "collec. gross-recorded net of tax on income at source" 51 "collec. unknown-recorded net of tax on income & social contrib." 55 "unknown" 61 "mix(parts of the component collec. according to different ways/deductive imputation)" -1 "missing" -2 "value not defined in data documentation" -5 "not filled: variable of gross series is filled" ; label define HY090N_F_VALUE_LABELS 0 "no income" 11 "collec. & recorded net of tax on income at source & social contrib." 13 "collec.net of tax on inc. at source & soc.contrib./recorded net of tax on inc.& soc.contrib." 22 "collec. & recorded net of tax on income at source" 31 "collec. net of tax on social contrib.recorded net of tax on income & social contrib." 33 "collec. & recorded net of tax on social contrib." 41 "collec. gross-recorded net of tax on income & social contrib." 42 "collec. gross-recorded net of tax on income at source" 43 "collec. gross-recorded net of tax on social contrib." 51 "collec. unknown-recorded net of tax on income & social contrib." 55 "unknown" 61 "mix(parts of the component collec. according to different ways/deductive imputation)" 1 "net of tax on income at source and social contribution" -1 "missing" -5 "not filled: variable of gross series is filled" ; label define HY100N_F_VALUE_LABELS 0 "no income" 1 "variable is filled" -1 "missing" -2 "value not defined in data documentation" -5 "not filled:variable of the gross series is filled" ; label define HY110N_F_VALUE_LABELS 0 "no income" 11 "collec. & recorded net of tax on income at source & social contrib." 12 "collec. net of tax on income at source & social contrib. recorded net of tax on income at source" 22 "collec. & recorded net of tax on income at source" 31 "collec. net of tax on social contrib. recorded net of tax on income & social contrib." 33 "collec. & recorded net of tax on social contrib." 41 "collec. gross-recorded net of tax on income & social contrib." 42 "collec. gross-recorded net of tax on income at source" 51 "collec. unknown-recorded net of tax on income & social contrib." 55 "unknown" 61 "mix(parts of the component collec. according to different ways/deductive imputation)" -1 "missing" -5 "not filled: variable of gross series is filled" ; label define HY120N_F_VALUE_LABELS 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" ; label define HY130N_F_VALUE_LABELS 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 "collec. net of tax on social contrib.recorded net of tax on income & social contrib." 33 "collec. & recorded net of tax on social contrib." 41 "collec. gross-recorded net of tax on income & social contrib." 42 "collec. gross-recorded net of tax on income at source" 51 "collec. unknownrecorded net of tax on income & social contrib." 55 "unknown" 61 "mix(parts of the component collec. according to different ways/deductive imputation)" -1 "missing" -5 "not filled: variable of gross series is filled" ; label define HY131N_F_VALUE_LABELS 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 "collec. net of tax on social contrib.;recorded net of tax on income & social contrib." 33 "collec. & recorded net of tax on social contrib." 41 "collec. gross;recorded net of tax on income & social contrib." 42 "collec. gross;recorded net of tax on income at source" 51 "collec. unknown;recorded net of tax on income & social contrib." 55 "unknown" 61 "mix(parts of the component collec. according to different ways/deductive imputation)" -1 "missing" -2 "value not defined in data documentation" -5 "not filled: variable of gross series is filled" ; label define HY140N_F_VALUE_LABELS 0 "no income" 1 "variable is filled" -1 "missing" -5 "Not filled: variable of the gross series is filled" ; label define HY145N_F_VALUE_LABELS 0 "no income" 1 "variable is filled" -1 "missing" -5 "Not filled: variable of gross series is filled" ; label define HY030G_F_VALUE_LABELS 0 "no income" 1 "income (variable is filled)" -1 "missing" -2 "value not defined in data documentation" -5 "not filled:variable of net (...g)gross (...n) series is filled" ; label define HY040G_F_VALUE_LABELS 0 "no income" 1 "collec.:net of tax on income at source and social contributions" 2 "collec.:net of tax on income at source" 3 "collec.:net of tax on social contributions" 4 "collec.:gross" 5 "collec.:unknown" 6 "mix(parts of the component collec. according to different ways" -1 "missing" -5 "not filled:variable of net series is filled" ; label define HY050G_F_VALUE_LABELS 0 "no income" 1 "collec.:net of tax on income at source and social contributions" 2 "collec.:net of tax on income at source" 3 "collec.:net of tax on social contributions" 4 "collec.:gross" 5 "collec.:unknown" 6 "mix(parts of the component collec. according to different ways" -1 "missing" -5 "not filled:variable of net series is filled" ; label define HY060G_F_VALUE_LABELS 0 "no income" 1 "collec.:net of tax on income at source and social contributions" 2 "collec.:net of tax on income at source" 3 "collec.:net of tax on social contributions" 4 "collec.:gross" 5 "collec.:unknown" 6 "mix(parts of the component collec. according to different ways" -1 "missing" -5 "not filled:variable of net series is filled" ; label define HY070G_F_VALUE_LABELS 0 "no income" 1 "collec.:net of tax on income at source and social contributions" 2 "collec.:net of tax on income at source" 3 "collec.:net of tax on social contributions" 4 "collec.:gross" 5 "collec.:unknown" 6 "mix(parts of the component collec. according to different ways" -1 "missing" -5 "not filled:variable of net series is filled" ; label define HY080G_F_VALUE_LABELS 0 "no income" 1 "collec.:net of tax on income at source and social contributions" 2 "collec.:net of tax on income at source" 3 "collec.:net of tax on social contributions" 4 "collec.:gross" 5 "collec.:unknown" 6 "mix(parts of the component collec. according to different ways" -1 "missing" -5 "not filled:variable of net series is filled" ; label define HY081G_F_VALUE_LABELS 0 "no income" 1 "collec.:net of tax on income at source and social contributions" 2 "collec.:net of tax on income at source" 3 "collec.:net of tax on social contributions" 4 "collec.:gross" 5 "collec.:unknown" 6 "mix(parts of the component collec. according to different ways" -1 "missing" -2 "value not defined in data documentation" -5 "not filled:variable of net series is filled" ; label define HY090G_F_VALUE_LABELS 0 "no income" 1 "collec.:net of tax on income at source and social contributions" 2 "collec.:net of tax on income at source" 3 "collec.:net of tax on social contributions" 4 "collec.:gross" 5 "collec.:unknown" 6 "mix(parts of the component collec. according to different ways" -1 "missing" -5 "not filled:variable of net series is filled" ; label define HY100G_F_VALUE_LABELS 0 "no income" 1 "variable is filled" -1 "missing" -2 "value not defined in data documentation" -5 "not filled: variable of netgross series is filled" ; label define HY110G_F_VALUE_LABELS 0 "no income" 1 "collec.:net of tax on income at source and social contributions" 2 "collec.:net of tax on income at source" 3 "collec.:net of tax on social contributions" 4 "collec.:gross" 5 "collec.:unknown" 6 "mix(parts of the component collec. according to different ways" -1 "missing" -5 "not filled:variable of net series is filled" ; label define HY120G_F_VALUE_LABELS 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" ; label define HY130G_F_VALUE_LABELS 0 "no income" 1 "collec.:net of tax on income at source and social contributions" 2 "collec.:net of tax on income at source" 3 "collec.:net of tax on social contributions" 4 "collec.:gross" 5 "collec.:unknown" 6 "mix(parts of the component collec. according to different ways" -1 "missing" -5 "not filled:variable of net series is filled" ; label define HY131G_F_VALUE_LABELS 0 "none" 1 "collec.:net of tax on income at source and social contributions" 2 "collec.:net of tax on income at source" 3 "collec.:net of tax on social contributions" 4 "collec.:gross" 5 "collec.:unknown" 6 "mix(parts of the component collec. according to different ways" -1 "missing" -2 "value not defined in data documentation" -5 "not filled:variable of net series is filled" ; label define HY140G_F_VALUE_LABELS 0 "no income" 1 "variable is filled" -1 "missing" -5 "not filled: variable of the netgross series is filled" ; label define HS011_VALUE_LABELS 1 "yes, once" 2 "yes, twice or more" 3 "no" ; label define HS011_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "not applicable" -5 "missing value of HS011 because HS010 is still used" ; label define HS021_VALUE_LABELS 1 "yes, once" 2 "yes, twice or more" 3 "no" ; label define HS021_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "not applicable" -5 "missing value of HS021 because HS020 is used" ; label define HS031_VALUE_LABELS 1 "yes, once" 2 "yes, twice or more" 3 "no" ; label define HS031_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "not applicable" -5 "missing value of HS031 because HS030 is used" ; label define HS040_VALUE_LABELS 1 "yes" 2 "no" ; label define HS040_F_VALUE_LABELS 1 "filled" -1 "missing" ; label define HS050_VALUE_LABELS 1 "yes" 2 "no" ; label define HS050_F_VALUE_LABELS 1 "filled" -1 "missing" ; label define HS060_VALUE_LABELS 1 "yes" 2 "no" ; label define HS060_F_VALUE_LABELS 1 "filled" -1 "missing" ; label define HS070_VALUE_LABELS 1 "yes" 2 "no - cannot afford" 3 "no - other reason" ; label define HS070_F_VALUE_LABELS 1 "filled" -1 "missing" ; label define HS080_VALUE_LABELS 1 "yes" 2 "no - cannot afford" 3 "no - other reason" ; label define HS080_F_VALUE_LABELS 1 "filled" -1 "missing" ; label define HS090_VALUE_LABELS 1 "yes" 2 "no - cannot afford" 3 "no - other reason" ; label define HS090_F_VALUE_LABELS 1 "filled" -1 "missing" ; label define HS100_VALUE_LABELS 1 "yes" 2 "no - cannot afford" 3 "no - other reason" ; label define HS100_F_VALUE_LABELS 1 "filled" -1 "missing" ; label define HS110_VALUE_LABELS 1 "yes" 2 "no - cannot afford" 3 "no - other reason" ; label define HS110_F_VALUE_LABELS 1 "filled" -1 "missing" ; label define HS120_VALUE_LABELS 1 "with great difficulty" 2 "with difficulty" 3 "with some difficulty" 4 "fairly easily" 5 "easily" 6 "very easily" ; label define HS120_F_VALUE_LABELS 1 "filled" -1 "missing" ; label define HS130_F_VALUE_LABELS 1 "filled" -1 "missing" ; label define HS140_VALUE_LABELS 1 "A heavy burden" 2 "somewhat a burden" 3 "not a burden at all" ; label define HS140_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "not applicable (no housing costs)" ; label define HS150_VALUE_LABELS 1 "repayment is a heavy burden" 2 "repayment is somewhat a burden" 3 "repayment is not a burden at all" ; label define HS150_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "not applicable (no repayment of debts)" ; label define HH010_VALUE_LABELS 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" ; label define HH010_F_VALUE_LABELS 1 "filled" -1 "missing" ; label define HH030_VALUE_LABELS 6 "six or more rooms" ; label define HH030_F_VALUE_LABELS 1 "filled" -1 "missing" ; label define HH031_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "n.a." ; label define HH040_VALUE_LABELS 1 "yes" 2 "no" ; label define HH040_F_VALUE_LABELS 1 "filled" -1 "missing" ; label define HH050_VALUE_LABELS 1 "yes" 2 "no" ; label define HH050_F_VALUE_LABELS 1 "filled" -1 "missing" ; label define HH060_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "not applicable (HH021 not = 3 or 4)" ; label define HH061_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "not applicable (HH021 = 3) or (MS do not use subjective method to calculate imputed rent)" ; label define HH071_F_VALUE_LABELS 1 "filled" -1 "missing" -2 "not applicable (HH021 ne 2)" ; label define HH081_VALUE_LABELS 1 "yes, for sole use of the household" 2 "yes, shared" 3 "no" ; label define HH081_F_VALUE_LABELS 1 "filled" -1 "missing" -5 "missing value of HH081 because HH080 is still used" ; label define HH091_VALUE_LABELS 1 "yes, for sole use of the household" 2 "yes, shared" 3 "no" ; label define HH091_F_VALUE_LABELS 1 "filled" -1 "missing" -5 "missing value of HH091 because HH090 is still used" ; label define HX120_VALUE_LABELS 0 "not overcrowded" 1 "overcrowded" ; label define HX040_VALUE_LABELS 6 "6; MT: Top coding" ; label define HX060_VALUE_LABELS 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)" ; label define HX070_VALUE_LABELS 1 "when HH020= 1 or 4" 2 "when HH020= 2 or 3" ; label define HX080_VALUE_LABELS 0 "when HX090>= at risk of poverty threshold (60% of Median HX090)" 1 "when HX090 < at risk of poverty threshold (60% of Median HX090)" ; label define HS160_VALUE_LABELS 1 "yes" 2 "no" ; label define HS160_F_VALUE_LABELS 1 "filled" -1 "missing" ; label define HS170_VALUE_LABELS 1 "yes" 2 "no" ; label define HS170_F_VALUE_LABELS 1 "filled" -1 "missing" ; label define HS180_VALUE_LABELS 1 "yes" 2 "no" ; label define HS180_F_VALUE_LABELS 1 "filled" -1 "missing" ; label define HS190_VALUE_LABELS 1 "yes" 2 "no" ; label define HS190_F_VALUE_LABELS 1 "filled" -1 "missing" ; label define HY170G_F_VALUE_LABELS 0 "no income" 1 "collec.:net of tax on income at source and social contributions" 2 "collec.:net of tax on income at source" 3 "collec.:net of tax on social contributions" 4 "collec.:gross" 5 "collec.:unknown" 6 "mix (parts of the component collec. according to different ways)" -1 "missing" -4 "amount included in another income component" -5 "not filled: variable of the net series is filled" ; label define HY170N_F_VALUE_LABELS 0 "no income" 1 "collec. net of tax on income at source & social contrib." 11 "collec. & recorded net of tax on income at source & social contrib." 12 "collec.net of tax on income at source and social contributions/recorded net of tax on income at source" 22 "collec. & recorded net of tax on income at source" 31 "collec. net of tax on social contrib.recorded net of tax on income & social contrib." 32 "collec.net of tax on social contributions/recorded net of tax on income at source." 33 "collec. & recorded net of tax on social contrib." 41 "collec. gross/recorded net of tax on income & social contrib." 42 "collec. gross/recorded net of tax on income at source" 43 "collec. gross/recorded net of tax on social contrib." 51 "collec. unknown/recorded net of tax on income & social contrib." 55 "unknown" 61 "mix(parts of the component collec. according to different ways/deductive imputation)" -1 "missing" -4 "Amount included in another income component" -5 "not filled: variable of gross series is filled" ; label define HH021_VALUE_LABELS 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" ; label define HH021_F_VALUE_LABELS 1 "filled" -1 "missing" -5 "mv of HH021 because HH021 is still used" ; label define HH070_F_VALUE_LABELS 1 "filled" -1 "missing" ; label define HC010_VALUE_LABELS 1 "Yes" 2 "No" ; label define HC030_VALUE_LABELS 1 "Yes" 2 "No" ; label define HC040_VALUE_LABELS 1 "Yes" 2 "No" ; label define HC050_VALUE_LABELS 1 "Yes ֠central heating or similar" 2 "Yes ֠other fixed heating" 3 "Yes ֠non-fixed heating" 4 "No ֠no heating at all" ; label define HC060_VALUE_LABELS 1 "Yes" 2 "No" ; label define HC070_VALUE_LABELS 1 "Yes" 2 "No" ; label define HC080_VALUE_LABELS 1 "Very dissatisfied" 2 "Dissatisfied" 3 "Satisfied" 4 "Very satisfied" ; label define HC090_VALUE_LABELS 1 "With great difficulty" 2 "With some difficulty" 3 "Easily" 4 "Very easily" ; label define HC100_VALUE_LABELS 1 "With great difficulty" 2 "With some difficulty" 3 "Easily" 4 "Very easily" ; label define HC110_VALUE_LABELS 1 "With great difficulty" 2 "With some difficulty" 3 "Easily" 4 "Very easily" ; label define HC120_VALUE_LABELS 1 "With great difficulty" 2 "With some difficulty" 3 "Easily" 4 "Very easily" ; label define HC130_VALUE_LABELS 1 "With great difficulty" 2 "With some difficulty" 3 "Easily" 4 "Very easily" ; label define HC140_VALUE_LABELS 1 "With great difficulty" 2 "With some difficulty" 3 "Easily" 4 "Very easily" ; label define HC150_VALUE_LABELS 1 "Yes ֠household will be forced to leave the dwelling" 2 "Yes ֠household plans to change the dwelling" 3 "No ֠household does not expect any change of the dwelling" ; label define HC160_VALUE_LABELS 1 "Household will be forced to leave, since notice has been/will be given by the landlord on termination of the contract" 2 "Household will be forced to leave, since notice has been/will be given by the landlord in the absence of a formal contract" 3 "Household will be forced to leave because of eviction" 4 "Household will be forced to leave for financial difficulties" 5 "Household will be forced to leave for some other reasons" ; label define HC010_F_VALUE_LABELS 1 "Filled" -1 "Missing" ; label define HC020_F_VALUE_LABELS 1 "Filled" -1 "Missing" ; label define HC030_F_VALUE_LABELS 1 "Filled" -1 "Missing" -2 "Not applicable (no electrical installations)" ; label define HC040_F_VALUE_LABELS 1 "Filled" -1 "Missing" -2 "Not applicable (no plumbing/water installations)" ; label define HC050_F_VALUE_LABELS 1 "Filled" -1 "Missing" ; label define HC060_F_VALUE_LABELS 1 "Filled" -1 "Missing" ; label define HC070_F_VALUE_LABELS 1 "Filled" -1 "Missing" ; label define HC080_F_VALUE_LABELS 1 "Filled" -1 "Missing" ; label define HC090_F_VALUE_LABELS 1 "Filled" -1 "Missing" -2 "Not applicable (services not used by the household)" ; label define HC100_F_VALUE_LABELS 1 "Filled" -1 "Missing" -2 "Not applicable (services not used by the household)" ; label define HC110_F_VALUE_LABELS 1 "Filled" -1 "Missing" -2 "Not applicable (services not used by the household)" ; label define HC120_F_VALUE_LABELS 1 "Filled" -1 "Missing" -2 "Not applicable (services not used by the household)" ; label define HC130_F_VALUE_LABELS 1 "Filled" -1 "Missing" -2 "Not applicable (services not used by the household)" ; label define HC140_F_VALUE_LABELS 1 "Filled" -1 "Missing" -2 "Not applicable (services not used by the household)" ; label define HC150_F_VALUE_LABELS 1 "Filled" -1 "Missing" ; label define HC160_F_VALUE_LABELS 1 "Filled" -1 "Missing" -2 "Not applicable (HC150=2 or 3)" ; * Attachement of category labels to variable ; label values HB050 HB050_VALUE_LABELS ; label values HB050_F HB050_F_VALUE_LABELS ; label values HB060_F HB060_F_VALUE_LABELS ; label values HB070_F HB070_F_VALUE_LABELS ; label values HB080_F HB080_F_VALUE_LABELS ; label values HB090_F HB090_F_VALUE_LABELS ; label values HB100_F HB100_F_VALUE_LABELS ; label values HY010_F HY010_F_VALUE_LABELS ; label values HY020_F HY020_F_VALUE_LABELS ; label values HY022_F HY022_F_VALUE_LABELS ; label values HY023_F HY023_F_VALUE_LABELS ; label values HY025_F HY025_F_VALUE_LABELS ; label values HY030N_F HY030N_F_VALUE_LABELS ; label values HY040N_F HY040N_F_VALUE_LABELS ; label values HY050N_F HY050N_F_VALUE_LABELS ; label values HY060N_F HY060N_F_VALUE_LABELS ; label values HY070N_F HY070N_F_VALUE_LABELS ; label values HY080N_F HY080N_F_VALUE_LABELS ; label values HY081N_F HY081N_F_VALUE_LABELS ; label values HY090N_F HY090N_F_VALUE_LABELS ; label values HY100N_F HY100N_F_VALUE_LABELS ; label values HY110N_F HY110N_F_VALUE_LABELS ; label values HY120N_F HY120N_F_VALUE_LABELS ; label values HY130N_F HY130N_F_VALUE_LABELS ; label values HY131N_F HY131N_F_VALUE_LABELS ; label values HY140N_F HY140N_F_VALUE_LABELS ; label values HY145N_F HY145N_F_VALUE_LABELS ; label values HY030G_F HY030G_F_VALUE_LABELS ; label values HY040G_F HY040G_F_VALUE_LABELS ; label values HY050G_F HY050G_F_VALUE_LABELS ; label values HY060G_F HY060G_F_VALUE_LABELS ; label values HY070G_F HY070G_F_VALUE_LABELS ; label values HY080G_F HY080G_F_VALUE_LABELS ; label values HY081G_F HY081G_F_VALUE_LABELS ; label values HY090G_F HY090G_F_VALUE_LABELS ; label values HY100G_F HY100G_F_VALUE_LABELS ; label values HY110G_F HY110G_F_VALUE_LABELS ; label values HY120G_F HY120G_F_VALUE_LABELS ; label values HY130G_F HY130G_F_VALUE_LABELS ; label values HY131G_F HY131G_F_VALUE_LABELS ; label values HY140G_F HY140G_F_VALUE_LABELS ; label values HS011 HS011_VALUE_LABELS ; label values HS011_F HS011_F_VALUE_LABELS ; label values HS021 HS021_VALUE_LABELS ; label values HS021_F HS021_F_VALUE_LABELS ; label values HS031 HS031_VALUE_LABELS ; label values HS031_F HS031_F_VALUE_LABELS ; label values HS040 HS040_VALUE_LABELS ; label values HS040_F HS040_F_VALUE_LABELS ; label values HS050 HS050_VALUE_LABELS ; label values HS050_F HS050_F_VALUE_LABELS ; label values HS060 HS060_VALUE_LABELS ; label values HS060_F HS060_F_VALUE_LABELS ; label values HS070 HS070_VALUE_LABELS ; label values HS070_F HS070_F_VALUE_LABELS ; label values HS080 HS080_VALUE_LABELS ; label values HS080_F HS080_F_VALUE_LABELS ; label values HS090 HS090_VALUE_LABELS ; label values HS090_F HS090_F_VALUE_LABELS ; label values HS100 HS100_VALUE_LABELS ; label values HS100_F HS100_F_VALUE_LABELS ; label values HS110 HS110_VALUE_LABELS ; label values HS110_F HS110_F_VALUE_LABELS ; label values HS120 HS120_VALUE_LABELS ; label values HS120_F HS120_F_VALUE_LABELS ; label values HS130_F HS130_F_VALUE_LABELS ; label values HS140 HS140_VALUE_LABELS ; label values HS140_F HS140_F_VALUE_LABELS ; label values HS150 HS150_VALUE_LABELS ; label values HS150_F HS150_F_VALUE_LABELS ; label values HH010 HH010_VALUE_LABELS ; label values HH010_F HH010_F_VALUE_LABELS ; label values HH030 HH030_VALUE_LABELS ; label values HH030_F HH030_F_VALUE_LABELS ; label values HH031_F HH031_F_VALUE_LABELS ; label values HH040 HH040_VALUE_LABELS ; label values HH040_F HH040_F_VALUE_LABELS ; label values HH050 HH050_VALUE_LABELS ; label values HH050_F HH050_F_VALUE_LABELS ; label values HH060_F HH060_F_VALUE_LABELS ; label values HH061_F HH061_F_VALUE_LABELS ; label values HH071_F HH071_F_VALUE_LABELS ; label values HH081 HH081_VALUE_LABELS ; label values HH081_F HH081_F_VALUE_LABELS ; label values HH091 HH091_VALUE_LABELS ; label values HH091_F HH091_F_VALUE_LABELS ; label values HX040 HX040_VALUE_LABELS ; label values HX060 HX060_VALUE_LABELS ; label values HX070 HX070_VALUE_LABELS ; label values HX080 HX080_VALUE_LABELS ; label values HX120 HX120_VALUE_LABELS ; label values HH070_F HH070_F_VALUE_LABELS ; label values HH021 HH021_VALUE_LABELS ; label values HH021_F HH021_F_VALUE_LABELS ; label values HS160 HS160_VALUE_LABELS ; label values HS160_F HS160_F_VALUE_LABELS ; label values HS170 HS170_VALUE_LABELS ; label values HS170_F HS170_F_VALUE_LABELS ; label values HS180 HS180_VALUE_LABELS ; label values HS180_F HS180_F_VALUE_LABELS ; label values HS190 HS190_VALUE_LABELS ; label values HS190_F HS190_F_VALUE_LABELS ; label values HY170N_F HY170N_F_VALUE_LABELS ; label values HY170G_F HY170G_F_VALUE_LABELS ; label values HC010 HC010_VALUE_LABELS ; label values HC030 HC040_VALUE_LABELS ; label values HC040 HC040_VALUE_LABELS ; label values HC050 HC050_VALUE_LABELS ; label values HC060 HC060_VALUE_LABELS ; label values HC070 HC070_VALUE_LABELS ; label values HC080 HC080_VALUE_LABELS ; label values HC090 HC090_VALUE_LABELS ; label values HC100 HC100_VALUE_LABELS ; label values HC110 HC110_VALUE_LABELS ; label values HC120 HC120_VALUE_LABELS ; label values HC130 HC130_VALUE_LABELS ; label values HC140 HC140_VALUE_LABELS ; label values HC150 HC150_VALUE_LABELS ; label values HC160 HC160_VALUE_LABELS ; label values HC010_F HC010_F_VALUE_LABELS ; label values HC020_F HC020_F_VALUE_LABELS ; label values HC030_F HC040_F_VALUE_LABELS ; label values HC040_F HC040_F_VALUE_LABELS ; label values HC050_F HC050_F_VALUE_LABELS ; label values HC060_F HC060_F_VALUE_LABELS ; label values HC070_F HC070_F_VALUE_LABELS ; label values HC080_F HC080_F_VALUE_LABELS ; label values HC090_F HC090_F_VALUE_LABELS ; label values HC100_F HC100_F_VALUE_LABELS ; label values HC110_F HC110_F_VALUE_LABELS ; label values HC120_F HC120_F_VALUE_LABELS ; label values HC130_F HC130_F_VALUE_LABELS ; label values HC140_F HC140_F_VALUE_LABELS ; label values HC150_F HC150_F_VALUE_LABELS ; label values HC160_F HC160_F_VALUE_LABELS ; label data "Household data file 2012" ; compress ; save "`stata_file'", replace ; log close ; set more on #delimit cr