* Encoding: windows-1252. ***************************************************************************************. * SPSS Command Syntax File * * Release 23.0.0.2 * * Transforms the EU-SILC CSV-data (as released by Eurostat) into an SPSS-Systemfile * * EU-SILC - Cross 2014-2 * Personal register file: * UDB_c14R_ver 2014-2 from 01-08-16.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: * C-2014 DIFFERENCES BETWEEN DATA COLLECTED.doc * * * (c) GESIS 2016-09-14 * GESIS - Leibniz Institute for the Social Sciences * German Microdata Lab * Heike Wirth; Anika Herter * * 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 ***************************************************************************************. set decimal dot. * When using SPSS earlier than V16 you might not use "set unicode" . set unicode no. * - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - . * The following command should contain the complete path and name of the raw data file; Change CSV_FILENAME to your filename . file handle csv_data / name ="CSV_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 . * - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - . GET DATA /TYPE=TXT /FILE=csv_data /ENCODING='Locale' /DELCASE=LINE /DELIMITERS="," /ARRANGEMENT=DELIMITED /FIRSTCASE=2 /IMPORTCASE=ALL /VARIABLES= RB010 F4.0 RB020 A2 RB030 F4.0 RB031 F4.0 RB031_F F2.0 RB050 comma8.0 RB050_F F1.0 RB070 F1.0 RB070_F F1.0 RB080 F4.0 RB080_F F1.0 RB090 F1.0 RB090_F F1.0 RB200 F1.0 RB200_F F1.0 RB210 F1.0 RB210_F F1.0 RB220 F4.0 RB220_F F2.0 RB230 F4.0 RB230_F F2.0 RB240 F4.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 F4.0 RB270_F F2.0 RL010 F2.0 RL010_F F2.0 RL020 F2.0 RL020_F F2.0 RL030 F2.0 RL030_F F2.0 RL040 F1.0 RL040_F F2.0 RL050 F1.0 RL050_F F2.0 RL060 F2.0 RL060_F F2.0 RL070 comma8.0 RL070_F F2.0 RX010 F2.0 RX020 F2.0 RX030 F2.0 RX040 comma12.0 RX050 F1.0 RX060 F1.0 RX070 F3.0. VARIABLE LABELS RB010 ‘Year of the survey’ / RB020 ‘country string’ / RB030 ‘Personal ID’ / RB031 ‘Year of Immigration’ / RB031_F ‘Flag’ / RB070 ‘Quarter of Birth (suppressed by DE,IE,NL,SI,UK)’ / RB070_F ‘Flag’ / RB080 ‘Year of birth’ / RB080_F ‘Flag’ / RB090 ‘Sex’ / RB090_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 ‘SpousePartner 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’ / RB050 ‘Personal cross-sectional weight’ / RB050_F ‘Flag’ / RL010 ‘Education at pre-school:hours of education during an usual week’ / RL010_F ‘Flag’ / RL020 ‘Education at compulsory school:hours of education during an usual week’ / RL020_F ‘Flag’ / RL030 ‘Childcare at centre-based services:hours of child care during an usual week’ / RL030_F ‘Flag’ / RL040 ‘Childcare at day-care centre:hours of child care during an usual week’ / RL040_F ‘Flag’ / RL050 ‘Child care by a professional child-miner:hours of child care during an usual week’ / RL050_F ‘Flag’ / RL060 ‘Child care by grand-parents;other hhld members;relatives etc: hours during an usual week’ / RL060_F ‘Flag’ / RL070 ‘Children cross-sectional weight for child care’ / RL070_F ‘Flag’ / RX030 ‘Household ID’ / RX040 ‘Work intensity’ / RX050 ‘Low work intensity status’/ RX060 ‘Severely materially deprived household’/ RX070 ‘At risk of poverty or social exclusion’/ . VALUE LABELS RB031 2014 "2014-2010" 2009 "2009-2005" 2004 "2004-2000" 1999 "1999-1995" 1994 "1994-1999" 1989 "1989-1885" 1984 "1984-1980" 1979 "1979-1975" 1974 "1974-1970" 1969 "1969-1965" 1964 "1964-1960" 1959 "1959-1955" 1954 "1954-1950" 1949 "1949-1945" 1944 "1944-1940" 1939 "1939-1935" 1934 "<=1934" / RB031_F 1 "filled" -1 "missing" -2 "not applicable (no immigration for the person)" / RB070 1 "January, February, March" 2 "April, May, June" 3 "July, August, September" 4 "October, November, December" / RB070_F 1 "filled" -1 "missing" / RB080 1933 "1933 or before" 1934 "PT: 1934 or before" / RB080_F 1 "filled" -1 "missing" / RB090 1 "Male" 2 "Female" / RB090_F 1 "filled" -1 "missing" / RB200 1 "currently living in the household" 2 "temporarily absent" / RB200_F 1 "filled" -1 "missing" -2 "not applicable (RB110 not = 1, 2, 3 or 4)" / RB210 1 "at work" 2 "unemployed" 3 "in retirement or early retirement" 4 "other inactive person" / RB210_F 1 "filled" -1 "missing" -2 "not applicable (RB110 not = 1, 2, 3 or 4)" / RB220_F 1 "filled" -1 "missing" -2 "not applicable (father is not a household member) or (RB110 not = 1, 2, 3 or 4)" / RB230_F 1 "filled" -1 "missing" -2 "not applicable (mother is not a household member) or (RB110 not = 1, 2, 3 or 4)" / RB240_F 1 "filled" -1 "missing" -2 "not applicable (spouse or 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 "not applicable (RB110 not = 1, 2, 3 or 4)" / RB250 11 "information only completed from interview (information or interview completed)" 12 "information only completed from registers(information or interview completed) " 13 "information completed from both: interview and registers(information or interview completed) " 14 "information completed from full-record imputation (information or interview completed)" 21 "individual unable to respond and 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 "Individual not contacted because temporarily away and no proxy possible " 32 "Individual not contacted 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 "Computer assisted web interviewing-CAWI" 6 "Face to face interview-PAPI with proxy" 7 "Face to face interview-CAPI with proxy" 8 "CATI, telephone interview with proxy" 9 "Self-administered by respondent with proxy" 10 "Computer assisted web interviewing-CAWI with proxy" / RB260_F 1 "filled" -1 "missing" -2 "na (RB250 not=11 or 13)" / RB270_F 1 "filled" -1 "missing" -2 "na (RB260 not=5)" / RX010 80 "80 or over" / RX020 80 "80 or over" / RB050_F 1 "filled" -2 "Not applicable (RB110 not equal to 1, 2, 3 or 4)" -7 "Not applicable RB010 not equal last year" / RL010_F 1 "filled" -1 "missing" -2 "na (person not admitted to pre-school because of her age)" / RL020_F 1 "filled" -1 "missing" -2 "na (person is not admitted to compulsory school)" / RL030_F 1 "filled" -1 "missing" -2 "na (person is neither at pre-school nor at school or is more than twelve years old" / RL040_F 1 "filled" -1 "missing" -2 "na (person is more than twelve years old)" / RL050_F 1 "filled" -1 "missing" -2 "na (person is more than twelve years old)" / RL060_F 1 "filled" -1 "missing" -2 "na (person is more than twelve years old)" / RL070_F 1 "filled" -2 "na (persons aged more than 12 years old at the date of interview)" / RX050 0 "no low work intensity" 1 "low work intensity" 2 "not applicable" / RX060 0 "not severely deprived" 1 "severely deprived" / RX070 000 "not ARP or not severely materially deprived or no low work intensity" 001 "not ARP or not severely materially deprived or low work intensity" 010 "not ARP or severely materially deprived or no low work intensity" 011 "not ARP or severely materially deprived or low work intensity" 100 "ARP or not severely materially deprived or no low work intensity" 101 "ARP or not severely materially deprived or low work intensity" 110 "ARP or severely materially deprived or no low work intensity" 111 "ARP or severely materially deprived or low work intensity" /. SAVE OUTFILE="spss_reference" /COMPRESSED.