* Encoding: windows-1252. * ==================================================================================================. * EU-SILC panel 2007 - release 2021-09 / DOI: TBD * * When publishing statistics derived from the EU-SILC UDB, please state as source: * "EU-SILC UDB - version of 2021-09" * * SPSS Command Syntax File * 2007_panel_eu_silc_r_ver_2022_03.sps * * (c) 2022-06-02 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-2007 DIFFERENCES BETWEEN DATA COLLECTED.doc * * ==================================================================================================. * * EU-SILC - panel - Personal 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): 2007_panel_eu_silc_r_ver_2022_03.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 !L2007_R (). *-------------------------------------------------------- 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 !CC1= 'AT BE CY DK EE FI EL IE NL PL PT SE SI SK UK'. !LET !CC2= 'BG CZ ES FR HU IS IT LT LU LV NO'. !LET !CC= 'AT BE BG CY CZ DK EE ES FI FR EL HU IE IS IT LT LU LV NL NO PL PT SE SI SK UK'. !DO !j !IN (!CC1) !IF (!j="EL") !THEN !LET !i="gr". !ELSE !LET !i=!j. !IFEND. SET DECIMAL DOT. GET DATA /TYPE=TXT /FILE=!QUOTE(!CONCAT(!csv_path,!j,'\2007\UDB_l',!i,'07R.csv')) /ENCODING='Locale' /DELCASE=LINE /DELIMITERS="," /ARRANGEMENT=DELIMITED /FIRSTCASE=2 /IMPORTCASE=ALL /VARIABLES= RB010 F4.0 RB020 A2 RB030 F9.0 RB040 F7.0 RB060 COMMA8.0 RB060_F F1.0 RB062 COMMA8.0 RB062_F F2.0 RB063 COMMA8.0 RB063_F F2.0 RB070 F1.0 RB070_F F1.0 RB080 F4.0 RB080_F F1.0 RB090 F1.0 RB090_F F1.0 RB100 F1.0 RB100_F F1.0 RB110 F1.0 RB110_F F1.0 RB120 F1.0 RB120_F F2.0 RB140 F1.0 RB140_F F2.0 RB150 F1.0 RB150_F F2.0 RB160 F1.0 RB160_F F2.0 RB170 F1.0 RB170_F F2.0 RB180 F1.0 RB180_F F2.0 RB190 F1.0 RB190_F F2.0 RB200 F1.0 RB200_F F1.0 RB210 F1.0 RB210_F F2.0 RB220 F9.0 RB220_F F2.0 RB230 F9.0 RB230_F F2.0 RB240 F9.0 RB240_F F2.0 RB245 F1.0 RB245_F F1.0 RB250 F2.0 RB250_F F2.0 RB260 F1.0 RB260_F F2.0 RB270 F9.0 RB270_F F2.0 RB064 F12.7 RB064_F F2 RX020 F2.0 RX010 F2.0. SAVE OUTFILE= !QUOTE(!CONCAT(!spss_path,'UDB_l',!j,'07R.sav')). !DOEND. !DO !i !IN (!CC2) GET DATA /TYPE=TXT /FILE=!QUOTE(!CONCAT(!csv_path,!i,'\2007\UDB_l',!i,'07R.csv')) /ENCODING='Locale' /DELCASE=LINE /DELIMITERS="," /ARRANGEMENT=DELIMITED /FIRSTCASE=2 /IMPORTCASE=ALL /VARIABLES= RB010 F4.0 RB020 A2 RB030 F9.0 RB040 F7.0 RB060 COMMA8.0 RB060_F F1.0 RB062 COMMA8.0 RB062_F F2.0 RB063 COMMA8.0 RB063_F F2.0 RB070 F1.0 RB070_F F1.0 RB080 F4.0 RB080_F F1.0 RB090 F1.0 RB090_F F1.0 RB100 F1.0 RB100_F F1.0 RB110 F1.0 RB110_F F1.0 RB120 F1.0 RB120_F F2.0 RB140 F1.0 RB140_F F2.0 RB150 F1.0 RB150_F F2.0 RB160 F1.0 RB160_F F2.0 RB170 F1.0 RB170_F F2.0 RB180 F1.0 RB180_F F2.0 RB190 F1.0 RB190_F F2.0 RB200 F1.0 RB200_F F1.0 RB210 F1.0 RB210_F F2.0 RB220 F9.0 RB220_F F2.0 RB230 F9.0 RB230_F F2.0 RB240 F9.0 RB240_F F2.0 RB245 F1.0 RB245_F F1.0 RB250 F2.0 RB250_F F2.0 RB260 F1.0 RB260_F F2.0 RB270 F9.0 RB270_F F2.0 RB064 F12.7 RB064_F F2 RX020 F2.0 RX010 F2.0 sel_wgt X. variable labels RB010 'Year of the survey'/ RB020 'Country'/ RB030 'Personal ID'/ RB040 'Current household ID'/ RB060 'Personal base weight'/ RB060_F 'Flag'/ Rb062 'Longitudinal weight(two-year duration)'/ RB062_F 'Flag'/ Rb063 'Longitudinal weight (three-year duration)'/ RB063_F 'Flag'/ RB064 'Longitudinal weight (four-year duration, only AT, BE, DK, FR)'/ RB064_F 'Flag'/ RB070 'Quarter of birth (NL,SI,UK: no info provided)'/ RB070_F 'Flag'/ RB080 'Year of birth'/ RB080_F 'Flag'/ RB090 'Sex'/ RB090_F 'Flag'/ RB100 'Sample person or co-resident'/ RB100_F 'Flag'/ RB110 'Membership status'/ RB110_F 'Flag'/ RB120 'Moved to'/ RB120_F 'Flag'/ RB140 'Quarter moved out and died (BE:coded in months; NL:info not provided)'/ RB140_F 'Flag'/ RB150 'Year moved out and died'/ RB150_F 'Flag'/ RB160 'Number of months in household during the income reference period'/ RB160_F 'Flag'/ RB170 'Main activity status during the income reference period'/ RB170_F 'Flag'/ RB180 'Quarter moved in (BE:coded in months; NL:info not provided)'/ RB180_F 'Flag'/ RB190 'Year moved in'/ RB190_F 'Flag'/ RB200 'Residential status'/ RB200_F 'Flag'/ RB210 'Basic activity status'/ RB210_F 'Flag'/ RB220 'Father ID'/ RB220_F 'Flag'/ RB230 'Mother ID'/ RB230_F 'Flag'/ RB240 'Spouse/Partner ID'/ RB240_F 'Flag'/ RB245 'Respondent status'/ RB245_F 'Flag'/ RB250 'Data status'/ RB250_F 'Flag'/ RB260 'Type of interview'/ RB260_F 'Flag'/ RB270 'Personal ID of proxy'/ RB270_F 'Flag'/ RX020 'Age at the end of the income reference period'/ RX010 'Age at the date of the interview'. value labels RB020 '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"/ RB060_F 1 'filled'/ RB062_F 1 'filled' -1 'missing' -2 'not applicable (no two year trajectory for the individual i.e. individual in 1st wave)'/ RB063_F 1 'filled' -1 'missing' -2 'not applicable (no 3-year trajectory for the individual i.e. individual in 1st or 2nd wave)'/ RB064_F 1 'filled' -1 'missing' -2 'not applicable (no 4-year trajectory for the individual i.e. individual in 1st,2nd or 3rd wave)'/ RB070 1 'January, February, March' 2 'April, May, June' 3 'July, August, September' 4 'October, November, December'/ RB070_F 1 'filled' -1 'missing'/ RB080 1923 "2003: 1923 & before" 1924 "2004: 1924 & before" 1925 "2005: 1925 & before" 1926 "2006: 1926 & before" 1927 "2007: 1927 & before"/ RB080_F 1 'filled' -1 'missing'/ Rb090 1 'Male' 2 'Female'/ RB090_F 1 'filled' -1 'missing'/ Rb100 1 'sample person' 2 'co-resident'/ RB100_F 1 'filled' -1 'missing'/ RB110 1 'was in hh in previous waves or current hh member' 2 'moved into hh from another sample hh since previous wave' 3 'moved into hh from outside sample since previous wave' 4 'newly born hh since last wave' 5 'moved out since previous wave if not contacted in previous wave)' 6 'died' 7 'lived in hh at least 3 months during the income ref. period, not recorded in the register of this hh'/ RB110_F 1 'filled' -1 'missing'/ RB120 1 'to a private household in the country' 2 'to a collective household or institution in the country' 3 'abroad' 4 'lost'/ RB120_F 1 'filled' -2 'na (RB110 not=5)'/ RB140 1 'January, February, March' 2 'April, May, June' 3 'July, August, September' 4 'October, November, December'/ RB140_F 1 'filled' -1 'missing' -2 'na(RB110 not=5 or 6)'/ RB150_F 1 'filled' -1 'missing' -2 'na (RB110 not =5 or 6)'/ RB160_F 1 'filled' -1 'missing' -2 'na (RB110 not = 5 or 6 or 7)'/ Rb170 1 'at work' 2 'unemployed' 3 'in retirement or early retirement' 4 'other inactive person'/ RB170_F 1 'filled' -1 'missing' -2 'na (RB110 not = 5 or 6 or 7)'/ RB180 1 'January, February, March' 2 'April, May, June' 3 'July, August, September' 4 'October, November, December'/ RB180_F 1 'filled' -1 'missing' -2 'na (RB110 not = 3)'/ RB190_F 1 'filled' -1 'missing' -2 'na (RB110 not = 3)'/ RB200 1 'currently living in the household' 2 'temporarily absent'/ RB200_F 1 'filled' -1 'missing' -2 'na(RB110 not 1,2,3 or 4)'/ RB210 1 'at work' 2 'unemployment' 3 'in retirement or early retirement' 4 'other inactive person'/ RB210_F 1 'filled' -1 'missing ' -2 'na(RB110 not 1,2,3 or 4)'/ RB220_F 1 'filled' -1 'missing' -2 'na(father is not a household member) or (RB110 not 1,2,3 or 4)'/ RB230_F 1 'filled' -1 'missing ' -2 'na(mother is not a household member) or (RB110 not 1,2,3 or 4)'/ RB240_F 1 'filled' -1 'missing' -2 'na(spouse/partner is not a household member) or (RB110 not 1,2,3 or 4)'/ RB245 1 'current household member aged 16 and over (all hm aged 16+ interviewed)' 2 'selected respondent (only selected hm aged 16+ interviewed)' 3 'not selected respondent(only selected hm aged 16+ interviewed)' 4 'not eligible person(Hm aged less than 16)'/ RB245_F 1 'filled ' -2 'na(RB110 not =1,2,3 or 4)'/ RB250 11 'information only completed from interview (information/interview completed) ' 12 'information only completed from registers (information/interview completed)' 13 'information completed from both: interview & registers (information/interview completed)' 14 'information completed from full-record imputation (information/interview completed)' 21 'unable to respond (illness, etc) no proxy possible (Interview not completed though contact made)' 22 'failed to return self-completed questionnaire (Interview not completed though contact made)' 23 'refusal to cooperate(Interview not completed though contact made) ' 31 'no contact because person temporarily away and no proxy possible' 32 'no contact for other reasons' 33 'information not completed: reason unknown'/ RB250_F 1 'filled' -2 'na (RB245 not = 1,2 or 3)'/ RB260 1 'face to face interview-PAPI' 2 'face to face interview-CAPI' 3 'CATI, telephone interview' 4 'self-administered by respondent' 5 'proxy interview'/ RB260_F 1 'filled' -1 'missing' -2 'na (RB250 not=11 or 13)'/ RB270_F 1 'filled' -1 'missing' -2 'na (RB260 not=5)'/ RX020 -1 'born between the end of income reference period and the data collection'. SAVE OUTFILE= !QUOTE(!CONCAT(!spss_path,'UDB_l',!i,'07R.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,'07R.sav')). !LET !firstfile=0. !ELSE ADD FILES FILE=* /FILE=!QUOTE(!CONCAT(!spss_path,'\UDB_l',!i,'07R.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,'07R.sav')). !DOEND. !ENDDEFINE. *----------------------------------------------------------------- End definition macro ---------------------------------------------------------------. *----------------------------------------------------------------- Invoke macro ---------------------------------------------------------------------------. !L2007_R.