* Encoding: windows-1252. * ==================================================================================================. * EU-SILC Cross 2005 - release 2021-04 / DOI: https://doi.org/10.2907/EUSILC2004-2019V.2 * 1st update * * When publishing statistics derived from the EU-SILC UDB, please state as source: * "EU-SILC UDB - version of 2021-04" * * SPSS Command Syntax File * 2005_cross_eu_silc_p_ver_2021_04.sps * * (c) GESIS 2021-11-18 * * 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-2005 DIFFERENCES BETWEEN DATA COLLECTED.doc * * ==================================================================================================. * * EU-SILC - cross - Personal data 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_c*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 (2021): 2005_cross_eu_silc_p_ver_2021_04.sps, 1st update. * 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 !C2005_P (). *-------------------------------------------------------- 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-2016\); * 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 CY CZ DE DK EE EL ES FI FR HU IE IS IT LT LU LV NL NO PL PT SE SI SK UK'. !DO !j !IN (!CC) !IF (!j="EL") !THEN !LET !i="gr" !ELSE !LET !i=!j !IFEND. GET DATA /TYPE=TXT /FILE=!QUOTE(!CONCAT(!csv_path,!j,'\2005\UDB_c',!i,'05P.csv')) /ENCODING='Locale' /DELCASE=LINE /DELIMITERS=',' /ARRANGEMENT=DELIMITED /FIRSTCASE=2 /IMPORTCASE=ALL /VARIABLES= PB010 F4.0 PB020 A2 PB030 F5.0 PB040 COMMA8.0 PB040_F F1.0 PB060 COMMA8.0 PB060_F F1.0 PB100 F1.0 PB100_F F1.0 PB110 F4.0 PB110_F F1.0 PB120 F2.0 PB120_F F1.0 PB130 F1.0 PB130_F F1.0 PB140 F4.0 PB140_F F1.0 PB150 F1.0 PB150_F F1.0 PB160 F5.0 PB160_F F2.0 PB170 F5.0 PB170_F F2.0 PB180 F5.0 PB180_F F2.0 PB190 F1.0 PB190_F F1.0 PB200 F1.0 PB200_F F1.0 PB210 A3 PB210_F F1.0 PB220A A3 PB220A_F F1.0 PE010 F1.0 PE010_F F1.0 PE020 F1.0 PE020_F F2.0 PE030 F4.0 PE030_F F1.0 PE040 F1.0 PE040_F F1.0 PL030 F1.0 PL030_F F1.0 PL035 F1.0 PL035_F F1.0 PL015 F1.0 PL015_F F2.0 PL020 F1.0 PL020_F F2.0 PL025 F1.0 PL025_F F2.0 PL040 F1.0 PL040_F F2.0 PL050 F2.0 PL050_F F2.0 PL060 F2.0 PL060_F F2.0 PL070 F2.0 PL070_F F1.0 PL072 F2.0 PL072_F F1.0 PL080 F2.0 PL080_F F1.0 PL085 F2.0 PL085_F F1.0 PL087 F2.0 PL087_F F1.0 PL090 F2.0 PL090_F F1.0 PL100 F2.0 PL100_F F2.0 PL110 A5 PL110_F F2.0 PL120 F1.0 PL120_F F2.0 PL130 F2.0 PL130_F F2.0 PL140 F1.0 PL140_F F2.0 PL150 F1.0 PL150_F F2.0 PL160 F1.0 PL160_F F2.0 PL170 F1.0 PL170_F F2.0 PL180 F2.0 PL180_F F2.0 PL190 F2.0 PL190_F F2.0 PL200 F2.0 PL200_F F2.0 PL210A F1.0 PL210A_F F1.0 PL210B F1.0 PL210B_F F1.0 PL210C F1.0 PL210C_F F1.0 PL210D F1.0 PL210D_F F1.0 PL210E F1.0 PL210E_F F1.0 PL210F F1.0 PL210F_F F1.0 PL210G F1.0 PL210G_F F1.0 PL210H F1.0 PL210H_F F1.0 PL210I F1.0 PL210I_F F1.0 PL210J F1.0 PL210J_F F1.0 PL210K F1.0 PL210K_F F1.0 PL210L F1.0 PL210L_F F1.0 PH010 F1.0 PH010_F F1.0 PH020 F1.0 PH020_F F1.0 PH030 F1.0 PH030_F F1.0 PH040 F1.0 PH040_F F1.0 PH050 F1.0 PH050_F F2.0 PH060 F1.0 PH060_F F1.0 PH070 F1.0 PH070_F F2.0 PY010N COMMA8.0 PY010N_F F2.0 PY010N_I COMMA9.0 PY020N COMMA4.2 PY020N_F F2.0 PY020N_I COMMA9.0 PY035N COMMA7.0 PY035N_F F1.0 PY035N_I COMMA9.0 PY050N COMMA8.0 PY050N_F F2.0 PY050N_I COMMA9.0 PY070N COMMA7.0 PY070N_F F2.0 PY070N_I COMMA9.0 PY080N COMMA4.0 PY080N_F F1.0 PY080N_I COMMA9.0 PY090N COMMA7.0 PY090N_F F2.0 PY090N_I COMMA9.0 PY100N COMMA8.0 PY100N_F F2.0 PY100N_I COMMA9.0 PY110N COMMA8.0 PY110N_F F2.0 PY110N_I COMMA9.0 PY120N COMMA7.0 PY120N_F F2.0 PY120N_I COMMA9.0 PY130N COMMA8.0 PY130N_F F2.0 PY130N_I COMMA9.0 PY140N COMMA7.0 PY140N_F F2.0 PY140N_I COMMA9.0 PY010G COMMA8.0 PY010G_F F1.0 PY010G_I COMMA9.0 PY020G COMMA4.2 PY020G_F F2.0 PY020G_I COMMA9.0 PY035G COMMA7.0 PY035G_F F1.0 PY035G_I COMMA9.0 PY050G COMMA8.0 PY050G_F F1.0 PY050G_I COMMA9.0 PY070G COMMA7.0 PY070G_F F1.0 PY070G_I COMMA9.0 PY080G COMMA4.0 PY080G_F F1.0 PY080G_I COMMA9.0 PY090G COMMA7.0 PY090G_F F1.0 PY090G_I COMMA9.0 PY100G COMMA8.0 PY100G_F F1.0 PY100G_I COMMA9.0 PY110G COMMA8.0 PY110G_F F1.0 PY110G_I COMMA9.0 PY120G COMMA7.0 PY120G_F F1.0 PY120G_I COMMA9.0 PY130G COMMA8.0 PY130G_F F1.0 PY130G_I COMMA9.0 PY140G COMMA7.0 PY140G_F F1.0 PY140G_I COMMA9.0 PY200G COMMA7.0 PY200G_F F2.0 PY200G_I COMMA9.0 PM005 Comma8.0 PM005_F F2.0 PM010 F1.0 PM010_F F2.0 PM020 F4.0 PM020_F F2.0 PM030 F4.0 PM030_F F2.0 PM035 F1.0 PM035_F F2.0 PM040 F1.0 PM040_F F2.0 PM050 F1.0 PM050_F F2.0 PM060 F1.0 PM060_F F2.0 PM070 F2.0 PM070_F F2.0 PM080 F1.0 PM080_F F2.0 PM090 F2.0 PM090_F F2.0 PM100 F1.0 PM100_F F1.0 PX030 F3.0 PX040 F1.0 PX020 F2.0 PX050 F1.0 PX010 COMMA9.0. Variable labels PB010 'Year of the Survey'/ PB020 'Country'/ PB030 'Personal ID'/ PB040 'Personal cross-sectional weight'/ PB040_F 'Flag'/ PB060 'Personal cross-sectional weight for selected respondent'/ PB060_F 'Flag'/ PB100 'Quarter of the personal interview'/ PB100_F 'Flag'/ PB110 'Year of the personal interview'/ PB110_F 'Flag'/ PB120 'Minutes to complete the personal interview'/ PB120_F 'Flag'/ PB130 'Quarter of birth'/ PB130_F 'Flag'/ PB140 'Year of birth'/ PB140_F 'Flag'/ PB150 'Sex'/ PB150_F 'Flag'/ PB160 'Father ID'/ PB160_F 'Flag'/ PB170 'Mother ID'/ PB170_F 'Flag'/ PB180 'Spouse/partner ID'/ PB180_F 'Flag'/ PB190 'Marital status'/ PB190_F 'Flag'/ PB200 'Consensual union'/ PB200_F 'Flag'/ PB210 'Country of birth'/ PB210_F 'Flag'/ PB220A 'Citizenship 1'/ PB220A_F 'Flag'/ PE010 'Current education activity'/ PE010_F 'Flag'/ PE020 'ISCED level currently attended'/ PE020_F 'Flag'/ PE030 'Year when highest level of education was attained'/ PE030_F 'Flag' / PE040 'Highest ISCED level attained'/ PE040_F 'Flag'/ PL030 'Self-defined current economic status'/ PL030_F 'Flag'/ PL035 'Worked at least one hour during the previous week'/ PL035_F 'Flag'/ PL015 'Person has ever worked'/ PL015_F 'Flag'/ PL020 'Actively looking for a job'/ PL020_F 'Flag'/ PL025 'Available for work'/ PL025_F 'Flag'/ PL040 'Status in employment'/ PL040_F 'Flag'/ PL050 'Occupation (ISCO-88 (Com))'/ PL050_F 'Flag'/ PL060 'Number of hours usually worked per week in main job'/ PL060_F 'Flag'/ PL070 'Number of months spent at full-time work'/ PL070_F 'Flag'/ PL072 'Number of months spent at part-time work'/ PL072_F 'Flag'/ PL080 'Number of months spent in unemployment'/ PL080_F 'Flag'/ PL085 'Number of months spent in retirement'/ PL085_F 'Flag'/ PL087 'Number of months spent studying'/ PL087_F 'Flag'/ PL090 'Number of months spent inactively'/ PL090_F 'Flag'/ PL100 'Total number of hours usually worked in second, third...jobs'/ PL100_F 'Flag'/ PL110 'NACE (Rev.1.1)' PL110_F 'Flag'/ PL120 'Reason for working less than 30 hours'/ PL120_F 'Flag' / PL130 'Number of persons working at the local unit'/ PL130_F 'Flag' / PL140 'Type of contract'/ PL140_F 'Flag' / Pl150 'Managerial Position'/ PL150_F 'Flag' / PL160 'Change of job since last year'/ PL160_F 'Flag' / PL170 'Reason for change'/ PL170_F 'Flag'/ PL180 'Most recent change in the individuals activity status'/ Pl180_F 'Flag' / PL190 'When began regular first job'/ PL190_F 'Flag' / PL200 'Number of years spent in paid work'/ PL200_F 'Flag' / PL210a 'Main activity on January'/ PL210a_F 'Flag'/ PL210B 'Main activity on February'/ PL210B_F 'Flag' / PL210C 'Main activity on March'/ PL210c_F 'Flag'/ PL210D 'Main activity on april'/ PL210D_F 'Flag'/ PL210E 'Main activity on May'/ Pl210E_F 'Flag' / PL210F 'Main activity on June'/ PL210f_F 'Flag' / PL210g 'Main activity on July'/ PL210g_F 'Flag' / PL210h 'Main activity on August'/ PL210h_F 'Flag'/ PL210I 'Main activity on September'/ PL210I_F 'Flag'/ PL210J 'Main activity on October'/ PL210J_F 'Flag'/ PL210K 'Main activity on November/' PL210K_F 'Flag'/ PL210L 'Main activity on December'/ PL210L_F 'Flag' / PH010 'General health'/ PH010_F 'Flag'/ PH020 'Suffer from a chronic(long-standing) illness or condition'/ PH020_F 'Flag'/ PH030 ' Limitation in activities because of health problems'/ PH030_F 'Flag' / PH040 'Unmet need for medical examination or treatment'/ PH040_F 'Flag'/ PH050 'Main reason for unmet need for medical examination or treatment'/ PH050_F 'Flag'/ PH060 'Unmet need for dental examination or treatment'/ PH060_F 'Flag'/ PH070 'Main reason for unmet need for dental examination or treatment'/ PH070_F 'Flag'/ PY010N 'Employee cash or near cash income(net)'/ PY010N_F 'Flag'/ PY010N_I 'Imputation factor'/ PY020N 'Non-Cash employee income(net)'/ PY020N_F 'Flag'/ PY020N_I 'Imputation Factor'/ PY035N 'Contributions to individual private pension plans(net)'/ PY035N_F 'Flag' / PY035N_I 'Imputation Factor'/ PY050N ' Cash benefits or losses from self-employment(net)'/ PY050N_F 'Flag'/ PY050N_I 'Imputation Factor'/ PY070N 'Value of goods produced by own-consumption (net)'/ PY070n_F 'Flag'/ PY070n_I 'Imputation factor'/ PY080N 'Pension from individual private plans(net)'/ PY080N_F 'Flag'/ PY080N_I 'Imputation factor'/ PY090N 'Unemployment benefits(net)'/ PY090N_F 'Flag'/ PY090N_I 'Imputation Factor'/ PY100N 'Old-age benefits(net)'/ PY100N_F 'Flag'/ PY100N_I 'Imputation Factor'/ PY110N 'Survivors Benefits (net)'/ PY110N_F 'Flag'/ PY110N_I 'Imputation Factor'/ PY120N 'Sickness Benefits(net)'/ PY120N_F 'Flag'/ PY120N_I 'Imputation Factor'/ PY130N 'Disability Benefits(net)'/ PY130N_F 'Flag'/ PY130N_I 'Imputation Factor'/ PY140N 'Education-related allowances'/ PY140N_F 'FlAG'/ PY140N_I 'Imputation factor'/ PY010G 'Employee Cash or near cash income(gross)'/ PY010G_F 'Flag'/ PY010G_I 'Imputation Factor'/ PY020G 'Non-Cash employee income(gross)'/ PY020G_F 'Flag'/ PY020G_I 'Imputation Factor'/ PY035G 'Contributions to individual private pension plans(gross)'/ PY035G_F 'Flag'/ PY035G_I 'Imputation Factor'/ PY050G 'Cash benefits or losses from self-employment (gross)'/ PY050G_F 'Flag'/ PY050G_I 'Imputation Factor'/ PY070G 'Value of goods produced by own-consumption(gross)'/ PY070G_F 'Flag'/ PY070G_I 'Imputation Factor'/ PY080G 'Pension from individual private plans(gross)'/ PY080G_F 'Flag'/ PY080G_I 'Imputation Factor'/ PY090G 'Unemployment benefits (gross)'/ PY090G_F 'Flag'/ PY090G_I 'Imputation Factor'/ PY100G 'Old-age benefits(gross)'/ PY100G_F 'Flag'/ PY100G_I 'Imputation Factor'/ PY110G 'Survivor benefit'/ PY110G_F 'Flag'/ PY110G_I 'Imputation Factor'/ PY120G 'Sickness Benefits(gross)'/ PY120G_F 'Flag'/ PY120G_I 'Imputation Factor'/ PY130G 'Disability benefits(gross)'/ PY130G_F 'Flag'/ PY130G_I 'Imputation Factor'/ PY140G 'Education-related allowances(gross)'/ PY140G_F 'Flag'/ PY140G_I 'Imputation factor'/ PY200G 'Gross mopnthly earnings for employees(gross)'/ PY200G_F 'Flag'/ PY200G_I 'Imputation Factor'/ PM005 'Personal intergenerational cross-sectional weight'/ PM005_F 'Flag'/ PM010 'Main family composition'/ PM010_F 'Flag'/ PM020 'Year of birth of father'/ PM020_F 'Flag'/ PM030 'Year of birth of mother'/ PM030_F 'Flag'/ PM035 'Main Number of siblings'/ PM035_F 'Flag'/ PM040 'Highest ISCED level of education attained by father'/ PM040_F 'Flag'/ PM050 'Highest ISCED level of education attained by mother'/ PM050_F 'Flag'/ PM060 'Main activity status of father'/ PM060_F 'Flag'/ PM070 'Main occupation of father'/ PM070_F 'Flag'/ PM080 'Main activity status of mother'/ PM080_F 'Flag'/ PM090 'Main occupation of mother'/ PM090_F 'Flag'/ PM100 'Financial problems in household when young teenager (DE,EL,PT:information not provided)'/ PM100_F 'Flag'/ PX030 'Household ID'/ PX040 'Respondent status'/ PX020 'Age at the end of the income reference period'/ PX050 'Activity status'/ PX010 'Exchange rate'. SAVE OUTFILE= !QUOTE(!CONCAT(!spss_path,'UDB_c',!j,'05P.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,'05P.sav')). !LET !firstfile=0. !ELSE ADD FILES FILE=* /FILE=!QUOTE(!CONCAT(!spss_path,'UDB_c',!i,'05P.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,'05P.sav')). !DOEND. !ENDDEFINE. *----------------------------------------------------------------- End definition macro ---------------------------------------------------------------. *----------------------------------------------------------------- Invoke macro ---------------------------------------------------------------------------. !C2005_P.