****************************************************************************************. * SPSS Command Syntax File * PASW Statistics 21 * Release 21.0.0.1 * * Transforms the EU-SILC CSV-data (as released by Eurostat) into an SPSS-Systemfile * * EU-SILC - Cross 2011 * Household register file: * UDB_c11D_ver 2011-2 from 01-08-13.csv * * (c) GESIS 2013-09-23 * GESIS - Leibniz Institute for the Social Sciences * German Microdata Lab * Heike Wirth; Florian Bains * * http://www.gesis.org/en/institute/ * http://www.gesis.org/en/services/data-analysis/official-microdata/european-microdata/eu-silc/eu-silc-tools/ * * Contact: heike.wirth@gesis.org ***************************************************************************************. * The following command should contain the complete path and name of the raw data file; Change CSV_DATA_FILENAME to your filename . file handle csv_data / name = "CSV_DATA_FILENAME". * The following command should contain the complete path and name of the SPSS file, usual file extension "sav"; Change SPSS_FILENAME to your filename . file handle spss_reference / name = "SPSS_FILENAME". * There should be probably nothing to change below this line . * - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - . set decimal dot. * When using SPSS earlier than V16 you might not use "set unicode" . set unicode no. GET DATA /TYPE=TXT /FILE=csv_data /ENCODING='Locale' /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 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. Variable labels DB010 'Year of the Survey' /DB020 'Country' /DB030 'Household ID' /DB040 'Region (NUTS 1 or 2)' /DB040_F 'Flag' /DB060 'Primary Sampling Units (PSU)' /DB060_F 'Flag' /DB062 'Secondary Sampling Units (SSU)' /DB062_F 'Flag' /DB070 'Order of selection of PSU' /DB070_F 'Flag' /DB075 'Rotation Group' /DB075_F 'Flag' /DB090 'Household cross-sectional weight' /DB090_F 'Flag' /DB100 'Degree of urbanisation' /DB100_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' "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" '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' "Slovenská 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' "Etelä-Suomi" 'FI1D' "Pohjois- ja Itä-Suomi" 'HR0' "Hrvatska"/ 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'. SAVE OUTFILE=spss_reference /compressed.