* Encoding: windows-1252. * ==================================================================================================. * EU-SILC cross 2016 - release 2021-09 / DOI: https://doi.org/10.2907/EUSILC2004-2020V.1. * * When publishing statistics derived from the EU-SILC UDB, please state as source: * "EU-SILC UDB - version of 2021-09" * * SPSS Command Syntax File * 2016_cross_eu_silc_r_ver_2021_09.sps * * (c) 2022-03-08 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-2016 DIFFERENCES BETWEEN DATA COLLECTED.doc * * ==================================================================================================. * * EU-SILC - cross - 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): 2016_cross_eu_silc_r_ver_2021_09.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 !C2016_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\Crossectional 2004-2017\); * 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 !CC= 'AT BE BG CH CY CZ DE DK EE EL ES FI FR HR HU IE IS IT LT LU LV MT NL NO PL PT RO RS SE SI SK UK'. * Malta erroneously included a variable; Data of Malta will be converted first and then combined with all data. * No loop necessary. GET DATA /TYPE=TXT /FILE=!QUOTE(!CONCAT(!csv_path,'MT\2016\UDB_cMT16R.csv')) /ENCODING='Locale' /DELCASE=LINE /DELIMITERS="," /ARRANGEMENT=DELIMITED /FIRSTCASE=2 /IMPORTCASE=ALL /VARIABLES= RB010 F4.0 RB020 A2 RB030 F9.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 RB080_BC F1.0 RB090 F1.0 RB090_F F1.0 RB200 F1.0 RB200_F F1.0 RB210 F1.0 RB210_F F1.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 RL010 F2.0 RL010_F F2.0 RL020 F2.0 RL020_F F2.0 RL030 F2.0 RL030_F F2.0 RL040 F2.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 RC010 F1.0 RC010_F F2.0 RC020 F1.0 RC020_F F2.0 RC030 F1.0 RC030_F F2.0 RC070 F1.0 RC070_F F2.0 RC080 F1.0 RC080_F F2.0 RC090 F1.0 RC090_F F2.0 RX010 F2.0 RX020 F2.0 RX030 F7.0 RX040 COMMA12.0 RX050 F1.0 RX060 F1.0 RX070 F3.0. DELETE VARIABLES RB080_BC. SAVE OUTFILE= !QUOTE(!CONCAT(!spss_path,'UDB_cMT16R.sav')). * All countries except MT. !LET !CC2= 'AT BE BG CH CY CZ DE DK EE EL ES FI FR HR HU IE IS IT LT LU LV NL NO PL PT RO RS SE SI SK UK'. !DO !i !IN (!CC2) GET DATA /TYPE=TXT /FILE=!QUOTE(!CONCAT(!csv_path,!i,'\2016\UDB_c',!i,'16R.csv')) /ENCODING='Locale' /DELCASE=LINE /DELIMITERS="," /ARRANGEMENT=DELIMITED /FIRSTCASE=2 /IMPORTCASE=ALL /VARIABLES= RB010 F4.0 RB020 A2 RB030 F9.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 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 RL010 F2.0 RL010_F F2.0 RL020 F2.0 RL020_F F2.0 RL030 F2.0 RL030_F F2.0 RL040 F2.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 RC010 F1.0 RC010_F F2.0 RC020 F1.0 RC020_F F2.0 RC030 F1.0 RC030_F F2.0 RC070 F1.0 RC070_F F2.0 RC080 F1.0 RC080_F F2.0 RC090 F1.0 RC090_F F2.0 RX010 F2.0 RX020 F2.0 RX030 F7.0 RX040 COMMA12.0 RX050 F1.0 RX060 F1.0 RX070 F3.0. VARIABLE LABELS RB010 'Year of the survey' / RB020 'Country alphanumeric' / RB030 'Personal ID' / RB031 'Year of immigration - grouped in 5 year classes (DE, IS, MT, SI: missing)' / RB031_F 'Flag' / RB050 'Personal cross-sectional weight' / RB050_F 'Flag' / RB070 'Quarter of birth (DE, IE, MT, NL, SI, UK: missing)' / RB070_F 'Flag' / RB080 'Year of birth (DE: Age group pertubation; MT: 5 yr groups)' / RB080_F 'Flag' / RB090 'Sex (DE: in same sex HH: recoded gender)' / 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 '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' / 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: No. h of child care during usual week' / RL050_F 'Flag' / RL060 'Child care by grnd-prnts; oth. hhld mmbrs; rltvs etc: No. of h/usual week' / RL060_F 'Flag' / RL070 'Children cross-sectional weight for child care' / RL070_F 'Flag' / RX010 'Age at the date of the interview (DE: age group pertubation, MT: missing)' / RX020 'Age at the end of the income reference period (DE: age group pertubatn, MT: mis)' / RX030 'Household ID' / RX040 'Work intensity' / RX050 'Low work intensity status' / RX060 'Severely materially deprived household' / RX070 'At risk of poverty or social exclusion' RC010 'Payment for the cost of formal childcare services' / RC010_F 'Flag' / RC020 'Proportion of the cost of formal childcare services paid' / RC020_F 'Flag' / RC030 'Who pays/contributes to the cost of formal childcare services' / RC030_F 'Flag' / RC070 'Payment for tuition fees' / RC070_F 'Flag' / RC080 'Part of the tuition fees paid' / RC080_F 'Flag' / RC090 'Who pays/ contributes to the tuition fees' / RC090_F 'Flag' / . VALUE LABELS RB031 2016 "2016 - 2012" 2011 "2011 - 2007" 2006 "2006 - 2002" 2001 "2001 - 1997" 1996 "1996 - 1992" 1991 "1991 - 1987" 1986 "1986 - 1982" 1981 "1981 - 1977" 1976 "1976 - 1972" 1971 "1971 - 1967" 1966 "1966 - 1962" 1961 "1961 - 1957" 1956 "1956 - 1952" 1951 "1951 - 1947" 1946 "1946 - 1942" 1941 "1941 - 1937" 1936 "<=1935" / RB031_F 1 "Filled" -1 "Missing" -2 "Not applicable (no immigration for the person)" / RB050_F 1 "Filled" -2 "Not applicable (RB110 not equal to 1, 2, 3 or 4)" -7 "Not applicable RB010 not equal last year" / RB070 1 "January, February, March" 2 "April, May, June" 3 "July, August, September" 4 "October, November, December" / RB070_F 1 "Filled" -1 "Missing" / RB080 1935 "1935 or before" 1936 "PT: 1936 and before" 1940 "MT: 1936-1940" 1942 "DE: 1942 and before" 1945 "MT: 1941-1945" 1950 "MT: 1946-1950" 1955 "MT: 1951-1955" 1960 "MT: 1956-1960" 1965 "MT: 1961-1965" 1970 "MT: 1966-1970" 1975 "MT: 1971-1975" 1980 "MT: 1976-1980" 1985 "MT: 1981-1985" 1990 "MT: 1986-1990" 1995 "MT: 1991-1995" 2000 "MT: 1996-2000" 2005 "MT: 2001-2005" 2010 "MT: 2006-2010" 2016 "MT: 2011-2016" / 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 "Not available (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 "Not applicable (RB250 not=11 or 13)" / RB270_F 1 "Filled" -1 "Missing" -2 "Not applicable (RB260 not=5)" / RL010_F 1 "Filled" -1 "Missing" -2 "Not applicable (person not admitted to pre-school because of her age)" / RL020_F 1 "Filled" -1 "Missing" -2 "Not applicable (person is not admitted to compulsory school)" / RL030_F 1 "Filled" -1 "Missing" -2 "Not applicable (person is neither at pre-school nor at school or is more than twelve years old" / RL040_F 1 "Filled" -1 "Missing" -2 "Not applicable (person is more than twelve years old)" / RL050_F 1 "Filled" -1 "Missing" -2 "Not available (person is more than twelve years old)" / RL060_F 1 "Filled" -1 "Missing" -2 "Not applicable (person is more than twelve years old)" / RL070_F 1 "Filled" -2 "Not applicable (persons aged more than 12 years old at the date of interview)" / RX010 74 "DE: 74 and over" 80 "80 and over" / RX020 73 "DE: 73 and over" 80 "80 and over" / 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/not severely materially deprived/no low work intensity" 001 "Not ARP/not severely materially deprived/low work intensity" 010 "Not ARP/severely materially deprived/no low work intensity" 011 "Not ARP/severely materially deprived/low work intensity" 100 "ARP/not severely materially deprived/no low work intensity" 101 "ARP/not severely materially deprived/low work intensity" 110 "ARP/severely materially deprived/no low work intensity" 111 "ARP/severely materially deprived/low work intensity" / RC010 1 "Yes" 2 "No" / RC010_F 1 "Filled" -1 "Missing" -4 "No formal childcare for this child (RL030<1 AND RL040<1) OR not current household member (RB110 not in (1,2,3,4))" -5 "Not applicable (person is more than 12 years old)" -7 "Not applicable (RB010 not 2016)" / RC020 1 "Full price (full cost)" 2 "Reduced price (subsidised by government, employer, private person, etc.)" 9 "Do not know" / RC020_F 1 "Filled" -1 "Missing" -2 "Not applicable (RC010 = 2)" -4 "No formal childcare for this child (RL030<1 AND RL040<1) OR not current household member (RB110 not in (1,2,3,4))" -5 "Not applicable (person is more than 12 years old)" -7 "Not applicable (RB010 not 2016)" / RC030 1 "Government or local authorities" 2 "Employer" 3 "Other institutions (e.g. church, non-profit organisations)" 4 "Private persons who are not household members" 5 "Other" 9 "Do not know" / RC030_F 1 "Filled" -1 "Missing" -2 "Not applicable (RC020 = 1 OR RC020=9)" -4 "No formal childcare for this child (RL030<1 AND RL040<1) OR not current household member (RB110 not in (1,2,3,4))" -5 "Not applicable (person is more than 12 years old)" -7 "Not applicable RB010 is unequal 2016" / RC070 1 "Yes" 2 "No" / RC070_F 1 "Filled" -1 "Missing" -4 "Person does not follow formal education OR not current household member (RB110 not in (1,2,3,4))" -7 "Not applicable RB010 is unequal 2016" / RC080 1 "Full price (full cost)" 2 "Reduced price (subsidised by government, employer, private person, etc.)" 9 "Do not know" / RC080_F 1 "Filled" -1 "Missing" -2 "Not applicable (RC070=2)" -4 "Person does not follow formal education OR not current household member (RB110 not in (1,2,3,4))" -7 "Not applicable RB010 is unequal 2016" / RC090 1 "Government or local authorities" 2 "Employer" 3 "Other institutions (e.g. church, non-profit organisations)" 4 "Private persons who are not household members" 5 "Other" 9 "Do not know" / RC090_F 1 "Filled" -1 "Missing" -2 "Not applicable (RC080=1 OR RC080=9) OR not current household member (RB110 not in (1,2,3,4))" -4 "Person does not follow formal education" -7 "Not applicable RB010 is unequal 2016". SAVE OUTFILE= !QUOTE(!CONCAT(!spss_path,'UDB_c',!i,'16R.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_c',!i,'16R.sav')). !LET !firstfile=0. !ELSE ADD FILES FILE=* /FILE=!QUOTE(!CONCAT(!spss_path,'UDB_c',!i,'16R.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_c',!i,'16R.sav')). !DOEND. !ENDDEFINE. *----------------------------------------------------------------- End definition macro ---------------------------------------------------------------. *----------------------------------------------------------------- Invoke macro ---------------------------------------------------------------------------. !C2016_R.