* Encoding: windows-1252. ****************************************************************************************. * 2006_c_y_panel_eu_silc_hhld_reg_d.sps * * SPSS Command Syntax File * Release 24.0.0.1 * * Transforms the EU-SILC CSV-data (as released by Eurostat) into an SPSS-Systemfile * * EU-SILC - Panel 2006_c_y * Household register file: * This version of the EU-SILC has been delivered in form of seperate country files. * The following syntax transformes the raw data into one SPSS file using all available country files. * Country files are delivered in the format UDB_l*country_stub*06D.csv * * 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-2006 DIFFERENCES BETWEEN DATA COLLECTED.doc * * (c) GESIS 2018-06-08 * GESIS - Leibniz Institute for the Social Sciences * German Microdata Lab * Heike Wirth; Anika Herter * * https://www.gesis.org/gml/european-microdata/eu-silc/ * * Contact: heike.wirth@gesis.org ***************************************************************************************. set decimal=DOT. * When using SPSS earlier than V16 you might not use "set unicode" . set unicode=OFF. * The csv file for Greece is not appropriately named. The following command changes the name on the hardrive in order for the macro to work properly. * The renaming is permanent and needs only to be executed once for every file. * Change csv_data_path_GR to the path where the csv file for Greece is stored. HOST COMMAND =['RENAME "csv_data_path_EL\UDB_lGR06D.csv" UDB_lEL06D.csv']. *----------------------------------------------------------------- Start definition macro ---------------------------------------------------------------. DEFINE !L2006_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-2015\); * 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 !csvfiles= 'UDB_lAT UDB_lBE UDB_lCY UDB_lCZ UDB_lDK UDB_lEE UDB_lEL UDB_lES' + ' UDB_lFI UDB_lFR UDB_lHU UDB_lIE UDB_lIS UDB_lIT UDB_lLT UDB_lLU UDB_lLV UDB_lNL' + ' UDB_lNO UDB_lPL UDB_lPT UDB_lSE UDB_lSI UDB_lSK UDB_lUK'. !LET !CC= 'AT BE CY CZ DK EE EL ES FI FR HU IE IS IT LT LU LV NL NO PL PT SE SI SK UK'. !DO !i !IN (!CC) GET DATA /TYPE=TXT /FILE=!QUOTE(!CONCAT(!csv_path,!i,'\2006\UDB_l',!i,'06D.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 F1.0 DB060_F F2.0 DB062 F1.0 DB062_F F2.0 DB070 F1.0 DB070_F F2.0 DB075 F1.0 DB075_F F1.0 DB090 COMMA8.0 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'/ DB030 'Household ID'/ DB040 'Region'/ 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'/ DB100_F 'Flag'/ DB110 'Household status'/ DB110_F 'Flag'. value labels DB020 'BE' "Belgique" 'DK' "Danmark" 'GR' "Ellada" 'ES' "Espana" 'FR' "France" 'IE' "Ireland" 'IT' "Italia" 'LU' "Luxembourg" 'NL' "Nederland" 'AT' "Oesterreich" 'PT' "Portugal" 'FI' "Suomi" 'SE' "Sverige" 'UK' "United Kingdom" 'CY' "Cyprus" 'CZ' "Czech Republic" 'EE' "Estonia" 'HU' "Hungary" 'LV' "Latvia" 'LT' "Lithuania" 'PL' "Poland" 'SK' "Slovak Republic" 'SI' "Slovenia" 'IS' "Iceland" 'NO' "Norway"/ DB030 /*ID number see construction doc 'UDB description' point 8.6.6*// DB040 'AT1' "Ostösterreich" 'AT2' "Südösterreich" 'AT3' "Westösterreich" 'BE1' "Région de Bruxelle-Capitale/Brussels Hoofdstedelijk Gewest" 'BE2' "Vlaams Gewest" 'BE3' "Region Wallonne" 'CY0' "KYPROS / 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' "País Vasco" 'ES22' "Comunidad Foral de Navarra" 'ES23' "La Rioja" 'ES24' "Aragón" 'ES30' "Comunidad de Madrid" 'ES41' "Castilla y León" 'ES42' "Castilla-La Mancha" 'ES43' "Extremadura" 'ES51' "Cataluńa" 'ES52' "Comunidad Valenciana" 'ES53' "Illes Balears" 'ES61' "Andalucía" 'ES62' "Región de Murcia" 'ES63' "Ciudad Autónoma de Ceuta" 'ES64' "Ciudad Autónoma de Melilla" 'ES70' "Canarias" 'FI1' "MANNER-SUOMI" 'FR10' "Île 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-Comté" 'FR51' "Pays de la Loire" 'FR52' "Bretagne" 'FR53' "Poitou-Charentes" 'FR61' "Aquitaine" 'FR62' "Midi-Pyrénées" 'FR63' "Limousin" 'FR71' "Rhône-Alpes" 'FR72' "Auvergne" 'FR81' "Languedoc-Roussillon" 'FR82' "Provence-Alpes-Côte dAzur" 'FR83' "Corse" 'GR1' "voreia ellada" 'GR2' "kentriki ellada" 'GR3' "attiki" 'GR4' "NISIA AIGAIOU, KRITI" 'HU1' "KOZEP-MAGYARORSZAG" 'HU2' "DUNANTUL" 'HU3' "ALFOLD ES ESZAK" 'IE0' "IRELAND" 'IS' " ÍSLAND" 'ITC' "NORD-OVEST" 'ITD' "NORD-EST" 'ITE' "CENTRO (I)" 'ITF' "SUD" 'ITG' "ISOLE" 'LT0' "LIETUVA" 'LV0' "LATVIJA" 'LU0' "LUXEMBOURG (GRAND-DUCHÉ)" 'NO0' " NORGE" 'PL1' "REGION CENTRALNY" 'PL2' "REGION POLUDNIOWY" 'PL3' "REGION WSCHODNI" 'PL4' "REGION POLNOCNO-ZACHODNI" 'PL5' "REGION POLUDNIOWO-ZACHODNI" 'PL6' "REGION POLNOCNY" 'SK0' "SLOVENSKA REPUBLIKA" 'SE1' " Östra Sverige" 'SE2' " Södra Sverige" 'SE3' " Norra Sverige"/ DB040_F -1 'missing' 1 'filled'/ 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 'at the same address as last interview ' 2 'entire household moves to a private household within the country (household from previous wave)' 3 'Entire household moved to a collective household or institution within the country (household no longer in scope)' 4 'Household moved outside the country (household no longer in scope)' 5 'Entire household died (household no longer in scope)' 6 'Household does not contain sample person(household no longer in scope)' 7 'Address non-contacted (no access, lost,no information on what happened to hh) (hh no longer in scope)' 8 'Split-off household (new household for this wave)' 9 'new address added to the sample this wave or first wave (new household for this wave)' 10 'Fusion'/ DB110_F 1 'filled'. SAVE OUTFILE= !QUOTE(!CONCAT(!spss_path,'UDB_l',!i,'06D.sav')). !DOEND. *-------------------------------------------------- Compile and save final file -----------------------------------------------------------------------------------. !LET !firstfile=1. !DO !filestub !IN (!csvfiles). !IF (!firstfile=1) !THEN GET FILE=!QUOTE(!CONCAT(!spss_path,!filestub,'06D.sav')). !LET !firstfile=0. !ELSE ADD FILES FILE=* /FILE=!QUOTE(!CONCAT(!spss_path,!filestub,'06D.sav')). !IFEND. !DOEND. SAVE OUTFILE=!QUOTE(!CONCAT(!spss_path,!finalfile,'.sav')). *--------------------------------------------------------Delete single country files -------------------------------------------------------------------------------. !DO !filestub !IN (!csvfiles). ERASE FILE=!QUOTE(!CONCAT(!spss_path,!filestub,'06D.sav')). !DOEND. !ENDDEFINE. *----------------------------------------------------------------- End definition macro ---------------------------------------------------------------. *----------------------------------------------------------------- Invoke macro ---------------------------------------------------------------------------. !L2006_nD.