****************************************************************************************. * SPSS Command Syntax File * PASW Statistics 18 * Release 18.0.1 * * Transform the EU-SILC CSV-data (as released by Eurostat) into an SPSS-Systemfile * * EU-SILC - Cross 2006 * Household register file: * UDB_c06D_ver 2006-4 from 01-03-10.csv * * (c) GESIS 2010-05-27 * GESIS - Leibniz Institute for the Social Sciences * German Microdata Lab * Heike Wirth, Verena Lichtenberger, Sabine Doebbeling, Mairena Hirschberg * http://www.gesis.org/en/institute/ * * Contact: heike.wirth@gesis.org ***************************************************************************************. set decimal dot. * When using SPSS earlier than V16 you might not use "set unicode" . set unicode no. ***************************************************************************************. * In the following /FILE command the directory * as well as the name of the csv-data must be * specified! * * Change 'e:\directory\' according your own directory ***************************************************************************************. GET DATA /TYPE=TXT /FILE='e:\directory\UDB_c06D_ver 2006-4 from 01-03-10.csv' /DELCASE=LINE /DELIMITERS="," /ARRANGEMENT=DELIMITED /FIRSTCASE=2 /IMPORTCASE=ALL /VARIABLES= DB010 F4.0 DB020 A2 DB030 F3.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. Variable labels DB010 'Year of the Survey' /DB020 'Country' /DB030 'Household ID' /DB040 'Region (NUTS 1 or 2)' /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'. value labels DB020 'BE' "Belgique" 'DK' "Danmark" 'DE' "Deutschland" '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" 'BG' "Bulgaria" 'CY' "Cyprus" 'CZ' "Czech Republic" 'EE' "Estonia" 'HU' "Hungary" 'LV' "Latvia" 'LT' "Lithuania" 'MT' "Malta" 'PL' "Poland" 'RO' "Romania" 'SK' "Slovak Republic" 'SI' "Slovenia" 'IS' "Iceland" 'NO' "Norway" 'Ch' "Switzerland"/ DB030 /*ID number see construction doc 'UDB description' point 8.6.6*// DB040 'BE1' "Region de Bruxelle-Capitale/Brussels Hoofdstedelijk Gewest" 'BE2' "Vlaams Gewest" 'BE3' "Region Wallonne" 'CZ01' "Praha" 'CZ02' "Stredni Cechy" 'CZ03' "Jihozapad" 'CZ04' "Severozapad" 'CZ05' "Severovychod" 'CZ06' "Jihovychod" 'CZ07' "Stredni Morava" 'CZ08' "Moravskoslezsko" 'DK0' "Danmark" 'DE1' "Baden-Wuerttemberg" 'DE2' "Bayern" 'DEA' "Nordrhein-Westphalen" 'DECE' "Hessen, Rheinland-Pfalz, Saarland" 'DENE' "Berlin, Brandenburg,M-V, Sachsen, S-A, Thueringen" 'DENW' "Bremen, Hamburg, Niedersachsen, Schleswig-Holstein" 'EE0' "Eesti" 'GR1' "voreia ellada" 'GR2' "kentriki ellada" 'GR3' "attiki" 'GR4' "NISIA AIGAIOU, KRITI" 'ES11' "Galicia" 'ES12' "Principado de Asturias" 'ES13' "Cantabria" 'ES21' "País 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' "Andalucía" '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 dAzur" 'FR83' "Corse" 'IE0' "IRELAND" 'ITC' "NORD-OVEST" 'ITD' "NORD-EST" 'ITE' "CENTRO (I)" 'ITF' "SUD" 'ITG' "ISOLE" 'CY0' "KYPROS / KIBRIS" 'LV0' "LATVIJA" 'LT0' "LIETUVA" 'LU0' "LUXEMBOURG (GRAND-DUCHE)" 'HU1' "KOZEP-MAGYARORSZAG" 'HU2' "DUNANTUL" 'HU3' "ALFOLD ES ESZAK" 'AT1' "Ostoesterreich" 'AT2' "Suedoesterreich" 'AT3' "Westoesterreich" 'PL1' "REGION CENTRALNY" 'PL2' "REGION POLUDNIOWY" 'PL3' "REGION WSCHODNI" 'PL4' "REGION POLNOCNO-ZACHODNI" 'PL5' "REGION POLUDNIOWO-ZACHODNI" 'PL6' "REGION POLNOCNY" 'SK0' "SLOVENSKA REPUBLIKA" 'FI1' "MANNER-SUOMI" 'SE0' "Sweden" 'NO0' "NORGE" 'IS' "ISLAND"/ 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'. ***************************************************************************************. * In the following SAVE OUTFILE command the directory * as well as the name of the new SPSS-data file (UDB_c06D_ver 2006-4 from 01-03-10.sav) * must be specified! * * Change 'e:\directory\' to your own directory and (if you like) change * also the name of the the SPSS-data file ***************************************************************************************. SAVE OUTFILE='e:\directory\UDB_c06D_ver 2006-4 from 01-03-10.sav' /COMPRESSED.