* Encoding: windows-1252. * ==================================================================================================. * EU-SILC panel 2011 - 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" * * SPSS Command Syntax File * 2011_panel_eu_silc_d_ver_2021_09.sps * * (c) 2022-03-08 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: * L-2011 DIFFERENCES BETWEEN DATA COLLECTED.doc * * ==================================================================================================. * * EU-SILC - panel - Household register 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_l*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): 2011_panel_eu_silc_d_ver_2021_09.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 !L2011_nD (). *-------------------------------------------------------- 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\Longitudinal 2005-2017\); * 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 !CC= 'AT BE BG CY CZ DK EE EL ES FI FR HR HU IS IT LT LU LV MT NL NO PL PT RO SE SI SK UK'. !DO !i !IN (!CC) GET DATA /TYPE=TXT /FILE=!QUOTE(!CONCAT(!csv_path,!i,'\2011\UDB_l',!i,'11D.csv')) /ENCODING='Locale' /DELCASE=LINE /DELIMITERS="," /ARRANGEMENT=DELIMITED /FIRSTCASE=2 /IMPORTCASE=ALL /VARIABLES= DB010 F4.0 DB020 A2 DB030 F7.0 DB040 A4 DB040_F F1.0 DB060 COMMA1.0 DB060_F F2.0 DB062 COMMA1.0 DB062_F F2.0 DB070 F1.0 DB070_F F2.0 DB075 F1.0 DB075_F F1.0 DB090 COMMA8.5 DB090_F F1.0 DB100 F1.0 DB100_F F1.0 DB110 F1.0 DB110_F F1.0. Variable labels DB010 'Year of the survey' /DB020 'Country alphanumeric' /DB030 'Household ID' /DB040 'Region (NUTS 1 or 2; CZ,ES,FI,FR,UK: NUTS2)' /DB040_F 'Flag' /DB060 'PSU-1 (First stage)' /DB060_F 'Flag' /DB062 'PSU-2 (Second stage)' /DB062_F 'Flag' /DB070 'Order of selection of PSU' /DB070_F 'Flag' /DB075 'Rotational group' /DB075_F 'Flag' /DB090 'Household cross-sectional weight' /Db090_F 'Flag' /DB100 'Degree of urbanisation (EE,LV:lbl 2,1=1 ; MT:lbl 2,3=2)' /DB100_F 'Flag' /DB110 'Household status' /DB110_F 'Flag'. value labels DB020 'BE' "Belgique" 'BG' "Bulgaria" 'CZ' "Czech Republic" 'DK' "Danmark" 'DE' "Deutschland" 'EE' "Estonia" 'EL' "Ellada" '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"/ DB040 ' ' "no info provided:DE;NL;PT;SI" 'AT1' "Ostoesterreich" 'AT2' "Suedoesterreich" 'AT3' "Westoesterreich" 'BE1' "Region de Brux.-Capitale/Brux Hoofdstedelijk Gewest" 'BE2' "Vlaams Gewest" 'BE3' "Region Wallonne" 'BG3' "Severna I Iztochna Bulgaria" 'BG4' "Yugozapadna I Yuzhna Tsentralna Bulgaria" 'CY0' "Kibris" 'CZ01' "Praha" 'CZ02' "Stredni Cechy" 'CZ03' "Jihozapad" 'CZ04' "Severozapad" 'CZ05' "Severovychod" 'CZ06' "Jihovychod" 'CZ07' "Stredni Morava" 'CZ08' "Moravskoslezsko" 'DK0' "Danmark" 'EE0' "Eesti" 'ES11' "Galicia" 'ES12' "Principado de Asturias" 'ES13' "Cantabria" 'ES21' "Pais Vasco" 'ES22' "Comunidad Foral de Navarra" 'ES23' "La Rioja" 'ES24' "Aragon" 'ES30' "Comunidad de Madrid" 'ES41' "Castilla y Leon" 'ES42' "Castilla-La Mancha" 'ES43' "Extremadura" 'ES51' "Cataluna" 'ES52' "Comunidad Valenciana" 'ES53' "Illes Balears" 'ES61' "Andalucia" 'ES62' "Region de Murcia" 'ES63' "Ciudad Autonoma de Ceuta" 'ES64' "Ciudad Autonoma de Melilla" 'ES70' "Canarias" 'FI13' "Itae-Suomi" 'FI18' "FI18 Etelae-Suomi, FI20 Aland" 'FI19' "Laensi-Suomi" 'FI1A' "Pohjois-Suomi" 'FR10' "Ile de France" 'FR21' "Champagne-Ardenne" 'FR22' "Picardie" 'FR23' "Haute-Normandie" 'FR24' "Centre" 'FR25' "Basse-Normandie" 'FR26' "Bourgogne" 'FR30' "Nord - Pas-de-Calais" 'FR41' "Lorraine" 'FR42' "Alsace" 'FR43' "Franche-Comte" 'FR51' "Pays de la Loire" 'FR52' "Bretagne" 'FR53' "Poitou-Charentes" 'FR61' "Aquitaine" 'FR62' "Midi-Pyrenees" 'FR63' "Limousin" 'FR71' "Rhone-Alpes" 'FR72' "Auvergne" 'FR81' "Languedoc-Roussillon" 'FR82' "Provence-Alpes-Cote d'Azur" 'FR83' "Corse" 'HR0' "Hrvatska" 'HU1' "Kozep-Magyarorszag" 'HU2' "Dunantul" 'HU3' "Alfold es Eszak" 'IE0' "Ireland" 'IS' "Iceland" 'ITC' "Nord-ovest" 'ITF' "Sud" 'ITG' "Isole" 'ITH' "Nord-Est" 'ITI' "Centro" 'LT0' "Lietuva" 'LU0' "Luxembourg (Grand-Duche)" 'LV0' "Latvija" 'MT0' "Malta" 'NO0' "Norge" 'PL1' "Region Centralny" 'PL2' "Region Poludniowy" 'PL3' "Region Wschodni" 'PL4' "Region Polnocno-Zachodni" 'PL5' "Region Poludniowo-Zachodni" 'PL6' "Region Polnocny" 'RO1' "Macroregiunea unu" 'RO2' "Macroregiunea doi" 'RO3' "Macroregiunea trei" 'RO4' "Macroregiunea patru" 'SE1' "Oestra Sverige" 'SE2' "Soedra Sverige" 'SE3' "Norra Sverige" 'SK0' "Slovenska-Republika" 'UKC1' "Tees Valley and Durham" 'EL1' "Voria Ellada" 'EL2' "Kendriki Ellada" 'EL3' "Attiki" 'EL4' "Nisia Egeou, Kriti" 'UKC2' "Northumberland and Tyne and Wear" 'UKD1' "Cumbria" 'UKD3' "Cheshire" 'UKD4' "Greater Manchester" 'UKD6' "Lancashire" 'UKD7' "Merseyside" 'UKE1' "East Yorkshire and North Lincolnshire" 'UKE2' "North Yorkshire" 'UKE3' "South Yorkshire" 'UKE4' "West Yorkshire" 'UKF1' "Derbyshire and Nottinghamshire" 'UKF2' "Leicestershire, Rutland and Northamptonshire" 'UKF3' "Lincolnshire" 'UKG1' "Herefordshire, Worcestershire and Warwickshire" 'UKG2' "Shropshire and Staffordshire" 'UKG3' "West Midlands" 'UKH1' "East Anglia" 'UKH2' "Bedfordshire and Hertfordshire" 'UKH3' "Essex" 'UKI1' "Inner London" 'UKI2' "Outer London" 'UKJ1' "Berkshire, Buckinghamshire and Oxfordshire" 'UKJ2' "Surrey, East and West Sussex" 'UKJ3' "Hampshire and Isle of Wight" 'UKJ4' "Kent" 'UKK1' "Gloucestershire, Wiltshire and Bristol\Bath area" 'UKK2' "Dorset and Somerset" 'UKK3' "Cornwall and Isles of Scilly" 'UKK4' "Devon" 'UKL1' "West Wales and The Valleys" 'UKL2' "East Wales" 'UKM2' "Eastern Scotland" 'UKM3' "South Western Scotland" 'UKM5' "North Eastern Scotland" 'UKM6' "Highlands and Islands" 'UKN0' "Northern Ireland" 'CH0' "Switzerland" 'FI1B' "Helsinki-Uusimaa" 'FI1C' "Etela-Suomi" 'FI1D' "Pohjois- ja Ita-Suomi"/ DB030 /*ID number see construction doc 'UDB description' point 8.6.6*// DB040_F -1 'missing' 1 'filled according to NUTS-03' 2 'filled according to NUTS-08'/ DB060_F 1 'filled' -2 'not applicable'/ DB062_F 1 'filled' -2 'not applicable'/ DB070_F 1 'filled' -2 'not applicable'/ DB075_F 1 'filled' -2 'na (no rotational design is used)'/ DB090_F 1 'filled'/ DB100 1 'densely populated area' 2 'intermediate area' 3 'thinly populated area'/ DB100_F 1 'filled' -1 'missing'/ DB110 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 household)'/ DB110_F 1 'filled'. SAVE OUTFILE= !QUOTE(!CONCAT(!spss_path,'UDB_l',!i,'11D.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_l',!i,'11D.sav')). !LET !firstfile=0. !ELSE ADD FILES FILE=* /FILE=!QUOTE(!CONCAT(!spss_path,'UDB_l',!i,'11D.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_l',!i,'11D.sav')). !DOEND. !ENDDEFINE. *----------------------------------------------------------------- End definition macro ---------------------------------------------------------------. *----------------------------------------------------------------- Invoke macro ---------------------------------------------------------------------------. !L2011_nD.