* eu_silc_panel_household_register_d_2008.do * * STATA Command Syntax File * Stata 11.0; * * Transforms the EU-SILC CSV-data (as released by Eurostat) into a Stata-Systemfile * * EU-SILC - Panel 2008 * Household register file: * UDB_l08D_ver 2008-1 from 01-08-2010.csv * * (c) GESIS 2010-09-01 * GESIS - Leibniz Institute for the Social Sciences * German Microdata Lab * Verena Lichtenberger; Heike Wirth * http://www.gesis.org/en/institute/ * * Contact: heike.wirth@gesis.org * /* Initialization commands */ clear capture log close set more off set memory 600m version 11.0 set linesize 250 memory #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 and name of the CSV data file. Change UDB_l08D_ver 2008-1 from 01-08-2010.csv to your filename ; local csv_data_file "UDB_l08D_ver 2008-1 from 01-08-2010.csv"; * The following command should contain the complete path and name of the STATA file, usual file extension "dta". Change STATA_FILENAME to your filename ; local stata_file "STATA_FILENAME" ; * CONFIGURATION SECTION - End ; * There should be probably nothing to change below this line ; * - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ; log using "`log_file'", replace text ; insheet using "`csv_data_file'", comma names case; label define DB020_neu 1 "BE" 2 "DK" 3 "DE" 4 "GR" 5 "ES" 6 "FR" 7 "IE" 8 "IT" 9 "LU" 10 "NL" 11 "AT" 12 "PT" 13 "FI" 14 "SE" 15 "UK" 16 "BG" 17 "CY" 18 "CZ" 19 "EE" 20 "HU" 21 "LV" 22 "LT" 23 "MT" 24 "PL" 25 "RO" 26 "SK" 27 "SI" 28 "IS" 29 "NO" 30 "CH" ; encode DB020, gen(DB020_neu) ; label define DB040_neu 1 "BE1" 2 "BE2" 3 "BE3" 4 "CZ01" 5 "CZ02" 6 "CZ03" 7 "CZ04" 8 "CZ05" 9 "CZ06" 10 "CZ07" 11 "CZ08" 12 "DK0" 13 "DE1" 14 "DE2" 15 "DEA" 16 "DECE" 17 "DENE" 18 "DENW" 19 "EE0" 20 "GR1" 21 "GR2" 22 "GR3" 23 "GR4" 24 "ES11" 25 "ES12" 26 "ES13" 27 "ES21" 28 "ES22" 29 "ES23" 30 "ES24" 31 "ES30" 32 "ES41" 33 "ES42" 34 "ES43" 35 "ES51" 36 "ES52" 37 "ES53" 38 "ES61" 39 "ES62" 40 "ES63" 41 "ES64" 42 "ES70" 43 "FI13" 44 "FI18" 45 "FI19" 46 "FI1A" 47 "FR10" 48 "FR21" 49 "FR22" 50 "FR23" 51 "FR24" 52 "FR25" 53 "FR26" 54 "FR30" 55 "FR41" 56 "FR42" 57 "FR43" 58 "FR51" 59 "FR52" 60 "FR53" 61 "FR61" 62 "FR62" 63 "FR63" 64 "FR71" 65 "FR72" 66 "FR81" 67 "FR82" 68 "FR83" 69 "IE0" 70 "ITC" 71 "ITD" 72 "ITE" 73 "ITF" 74 "ITG" 75 "CY0" 76 "LV0" 77 "LT0" 78 "LU0" 79 "HU1" 80 "HU2" 81 "HU3" 82 "AT1" 83 "AT2" 84 "AT3" 85 "PL1" 86 "PL2" 87 "PL3" 88 "PL4" 89 "PL5" 90 "PL6" 91 "SK0" 92 "FI1" 93 "SE0" 94 "NO0" 95 "IS" 96 "BG31" 97 "BG32" 98 "BG33" 99 "BG34" 100 "BG41" 101 "BG42" 102 "RO11" 103 "RO12" 104 "RO21" 105 "RO22" 106 "RO31" 107 "RO32" 108 "RO41" 109 "RO42" 110 "SE1" 111 "SE2" 112 "SE3" ; encode DB040, gen(DB040_neu) ; recode DB040_neu (miss = -99) ; rename DB020_neu DB020_num ; label define DB020_num_VALUE_LABELS 1 "BE Belgique" 2 "DK Danmark" 3 "DE Deutschland" 4 "GR Ellada" 5 "ES Espana" 6 "FR France" 7 "IE Ireland" 8 "IT Italia" 9 "LU Luxembourg" 10 "NL Nederland" 11 "AT Oesterreich" 12 "PT Portugal" 13 "FI Suomi" 14 "SE Sverige" 15 "UK United Kingdom" 16 "BG Bulgaria" 17 "CY Cyprus" 18 "CZ Czech Republic" 19 "EE Estonia" 20 "HU Hungary" 21 "LV Latvia" 22 "LT Lithuania" 23 "MT Malta" 24 "PL Poland" 25 "RO Romania" 26 "SK Slovak Republic" 27 "SI Slovenia" 28 "IS Iceland" 29 "NO Norway" 30 "Ch Switzerland" ; rename DB040_neu DB040_num ; label define DB040_num_VALUE_LABELS 1 "BE1 Region de Bruxelle-CapitaleBrussels Hoofdstedelijk Gewest" 2 "BE2 Vlaams Gewest" 3 "BE3 Region Wallonne" 4 "CZ01 Praha" 5 "CZ02 Stredni Cechy" 6 "CZ03 Jihozapad" 7 "CZ04 Severozapad" 8 "CZ05 Severovychod" 9 "CZ06 Jihovychod" 10 "CZ07 Stredni Morava" 11 "CZ08 Moravskoslezsko" 12 "DK0 Danmark" 13 "DE1 Baden-Wuerttemberg" 14 "DE2 Bayern" 15 "DEA Nordrhein-Westphalen" 16 "DECE Hessen, Rheinland-Pfalz, Saarland" 17 "DENE Berlin, Brandenburg,M-V, Sachsen, S-A, Thueringen" 18 "DENW Bremen, Hamburg, Niedersachsen, Schleswig-Holstein" 19 "EE0 Eesti" 20 "GR1 voreia ellada" 21 "GR2 kentriki ellada" 22 "GR3 attiki" 23 "GR4 NISIA AIGAIOU, KRITI" 24 "ES11 Galicia" 25 "ES12 Principado de Asturias" 26 "ES13 Cantabria" 27 "ES21 País Vasco" 28 "ES22 Comunidad Foral de Navarra" 29 "ES23 La Rioja" 30 "ES24 Aragon" 31 "ES30 Comunidad de Madrid" 32 "ES41 Castilla y Leon" 33 "ES42 Castilla-La Mancha" 34 "ES43 Extremadura" 35 "ES51 Cataluna" 36 "ES52 Comunidad Valenciana" 37 "ES53 Illes Balears" 38 "ES61 Andalucía" 39 "ES62 Region de Murcia" 40 "ES63 Ciudad Autonoma de Ceuta" 41 "ES64 Ciudad Autonoma de Melilla" 42 "ES70 Canarias" 43 "FI13 Itae-Suomi" 44 "FI18 FI18 Etelae-Suomi, FI20 Aland" 45 "FI19 Laensi-Suomi" 46 "FI1A Pohjois-Suomi" 47 "FR10 Ile de France" 48 "FR21 Champagne-Ardenne" 49 "FR22 Picardie" 50 "FR23 Haute-Normandie" 51 "FR24 Centre" 52 "FR25 Basse-Normandie" 53 "FR26 Bourgogne" 54 "FR30 Nord - Pas-de-Calais" 55 "FR41 Lorraine" 56 "FR42 Alsace" 57 "FR43 Franche-Comte" 58 "FR51 Pays de la Loire" 59 "FR52 Bretagne" 60 "FR53 Poitou-Charentes" 61 "FR61 Aquitaine" 62 "FR62 Midi-Pyrenees" 63 "FR63 Limousin" 64 "FR71 Rhone-Alpes" 65 "FR72 Auvergne" 66 "FR81 Languedoc-Roussillon" 67 "FR82 Provence-Alpes-Cote dAzur" 68 "FR83 Corse" 69 "IE0 IRELAND" 70 "ITC NORD-OVEST" 71 "ITD NORD-EST" 72 "ITE CENTRO (I)" 73 "ITF SUD" 74 "ITG ISOLE" 75 "CY0 KYPROS KIBRIS" 76 "LV0 LATVIJA" 77 "LT0 LIETUVA" 78 "LU0 LUXEMBOURG (GRAND-DUCHE)" 79 "HU1 KOZEP-MAGYARORSZAG" 80 "HU2 DUNANTUL" 81 "HU3 ALFOLD ES ESZAK" 82 "AT1 Ostoesterreich" 83 "AT2 Suedoesterreich" 84 "AT3 Westoesterreich" 85 "PL1 REGION CENTRALNY" 86 "PL2 REGION POLUDNIOWY" 87 "PL3 REGION WSCHODNI" 88 "PL4 REGION POLNOCNO-ZACHODNI" 89 "PL5 REGION POLUDNIOWO-ZACHODNI" 90 "PL6 REGION POLNOCNY" 91 "SK0 SLOVENSKA REPUBLIKA" 92 "FI1 MANNER-SUOMI" 93 "SE0 Sweden" 94 "NO0 NORGE" 95 "IS ISLAND" 96 "BG31 Northwestern" 97 "BG32 North Central" 98 "BG33 Northeastern" 99 "BG34 Southeastern" 100 "BG41 Southwestern" 101 "BG42 South Centra" 102 "RO11 Nord-Vest" 103 "RO12 Centru" 104 "RO21 Nord-Est" 105 "RO22 Sud-Est" 106 "RO31 Sud-Muntenia" 107 "RO32 Bucuresti-Ilfov" 108 "RO41 Sud-Vest Oltenia" 109 "RO42 Vest" 110 "SE1 Ostra Sverige" 111 "SE2 Sodra Sverige" 112 "SE3 Norra Sverige" -99 "DE;NL;PT;SI;UK: no info provided" ; * Definition of variable labels ; label variable DB010 "Year of the Survey" ; label variable DB020 "Country alphanumeric" ; label variable DB020_num "Country numeric" ; label variable DB030 "Household ID" ; label variable DB040 "Region (NUTS 1 or 2)" ; label variable DB040 "Region (NUTS 1 or 2) numeric" ; label variable DB040_F "Flag" ; label variable DB060 "PSU-1 (First stage)" ; label variable DB060_F "Flag" ; label variable DB062 "PSU-2 (Second stage)" ; label variable DB062_F "Flag" ; label variable DB070 "Order of selection of PSU" ; label variable DB070_F "Flag" ; label variable DB075 "Rotational Group" ; label variable DB075_F "Flag" ; label variable DB090 "Household cross-sectional weight" ; label variable DB090_F "Flag" ; label variable DB100 "Degree of urbanisation" ; label variable DB100_F "Flag" ; label variable DB110 "Household status" ; label variable DB110_F "Flag" ; * Definition of category labels ; * DB030 *ID number see construction doc "UDB description" point 8.6.6 ; label define DB040_F_VALUE_LABELS 1 "filled according to NUTS-03" 2 "filled according to NUTS-08" -1 "missing" ; label define DB060_F_VALUE_LABELS 1 "filled" -2 "not applicable" ; label define DB062_F_VALUE_LABELS 1 "filled" -2 "not applicable" ; label define DB070_F_VALUE_LABELS 1 "filled" -2 "not applicable" ; label define DB075_F_VALUE_LABELS 1 "filled" -2 "na (no rotational design is used)" ; label define DB090_F_VALUE_LABELS 1 "filled" ; label define DB100_VALUE_LABELS 1 "densely populated area" 2 "intermediate area" 3 "thinly populated area" ; label define DB100_F_VALUE_LABELS 1 "filled" -1 "missing" ; label define DB110_VALUE_LABELS 1 "Hhld from prev. wave: At the same address as last interview" 2 "Hhld from prev. wave:Entire household moved to a private hhld within the country" 3 "Hhld no longer in-scope: Entire hhld moved to a collective hhld institution within the country" 4 "Hhld no longer in-scope: Hhld moved outside the country" 5 "Hhld no longer in-scope: Entire household died" 6 "Hhld no longer in-scope: Hhld does not contain sample person" 7 "Address non-contacted(unable to access, lost-no info on record on what happened to the hhld-)" 8 "New household for this wave: Split-off household" 9 "New household for this wave: New address added to the sample this wave or first wave" 10 "Fusion" 11 "Lost household (no information on record on what happened to the hhld)" ; label define DB110_F_VALUE_LABELS 1"filled" ; * Attachment of category labels to variable ; label values DB020_num DB020_num_VALUE_LABELS ; label values DB040_num DB040_num_VALUE_LABELS ; label values DB040_F DB040_F_VALUE_LABELS ; label values DB060_F DB060_F_VALUE_LABELS ; label values DB062_F DB062_F_VALUE_LABELS ; label values DB070_F DB070_F_VALUE_LABELS ; label values DB075_F DB075_F_VALUE_LABELS ; label values DB090_F DB090_F_VALUE_LABELS ; label values DB100 DB100_VALUE_LABELS ; label values DB100_F DB100_F_VALUE_LABELS ; label values DB110 DB110_VALUE_LABELS ; label values DB110_F DB110_F_VALUE_LABELS ; label data "Panel: Household Register file 2008" ; compress ; save "`stata_file'", replace ; log close ; set more on #delimit cr