IDEAS home Printed from https://ideas.repec.org/a/spr/jlabrs/v54y2020i1d10.1186_s12651-020-00275-9.html
   My bibliography  Save this article

Preparing the sample of integrated labour market biographies (SIAB) for scientific analysis: a guide

Author

Listed:
  • Wolfgang Dauth

    (University of Würzburg, IZA)

  • Johann Eppelsheimer

    (Institute for Employment Research (IAB))

Abstract

Preparing the Sample of Integrated Labour Market Biographies (SIAB) for scientific analysis is a complicated and error-prone task. This paper elaborates on the steps necessary to prepare the SIAB and provides examples of how the preparation can be done. Among other topics covered, we show how to generate and merge additional variables, impute right-censored wages, deal with parallel employment episodes, and clean the dataset. Finally, we present a case study on the individual long-term effects of job loss from plant closure to demonstrate how our prepared version of the SIAB can be used to carry out an empirical analysis. The supplementary material of this paper contains extensively commented Stata do-files to replicate our data preparation and the subsequent analysis.

Suggested Citation

  • Wolfgang Dauth & Johann Eppelsheimer, 2020. "Preparing the sample of integrated labour market biographies (SIAB) for scientific analysis: a guide," Journal for Labour Market Research, Springer;Institute for Employment Research/ Institut für Arbeitsmarkt- und Berufsforschung (IAB), vol. 54(1), pages 1-14, December.
    • Handle: RePEc:spr:jlabrs:v:54:y:2020:i:1:d:10.1186_s12651-020-00275-9
    DOI: 10.1186/s12651-020-00275-9
    as

    Download full text from publisher

    File URL: http://link.springer.com/10.1186/s12651-020-00275-9
    File Function: Abstract
    Download Restriction: no
    File URL: https://libkey.io/10.1186/s12651-020-00275-9?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    References listed on IDEAS

    as
    1. Thomsen, Ulrich & Ludsteck, Johannes & Schmucker, Alexandra, 2018. "Skilled or unskilled - Improving the information on qualification for employee data in the IAB Employee Biography," FDZ Methodenreport 201809_en, Institut für Arbeitsmarkt- und Berufsforschung (IAB), Nürnberg [Institute for Employment Research, Nuremberg, Germany].
    2. David Card & Jörg Heining & Patrick Kline, 2013. "Workplace Heterogeneity and the Rise of West German Wage Inequality," The Quarterly Journal of Economics, President and Fellows of Harvard College, vol. 128(3), pages 967-1015.
    3. Jacobson, Louis S & LaLonde, Robert J & Sullivan, Daniel G, 1993. "Earnings Losses of Displaced Workers," American Economic Review, American Economic Association, vol. 83(4), pages 685-709, September.
    4. Eberle, Johanna & Schmucker, Alexandra, 2017. "Creating cross-sectional data and biographical variables with the Sample of Integrated Labour Market Biographies 1975-2014 : Programming examples for Stata," FDZ Methodenreport 201706_en, Institut für Arbeitsmarkt- und Berufsforschung (IAB), Nürnberg [Institute for Employment Research, Nuremberg, Germany].
    5. repec:iab:iabfme:201706(en is not listed on IDEAS
    6. Kurt Schmidheiny & Sebastian Siegloch, 2019. "On Event Study Designs and Distributed-Lag Models: Equivalence, Generalization and Practical Implications," CESifo Working Paper Series 7481, CESifo.
    7. Riphahn, Regina T. & Schnitzlein, Daniel D., 2016. "Wage mobility in East and West Germany," Labour Economics, Elsevier, vol. 39(C), pages 11-34.
    8. Fackler, Daniel & Müller, Steffen & Stegmaier, Jens, 2017. "Explaining wage losses after job displacement: Employer size and lost firm rents," IWH Discussion Papers 32/2017, Halle Institute for Economic Research (IWH).
    9. Johannes F. Schmieder & Till von Wachter & Stefan Bender, 2012. "The Long-Term Effects of UI Extensions on Employment," American Economic Review, American Economic Association, vol. 102(3), pages 514-519, May.
    10. Tanja Hethey-Maier & Johannes F. Schmieder, 2013. "Does the Use of Worker Flows Improve the Analysis of Establishment Turnover? Evidence from German Administrative Data," Schmollers Jahrbuch : Journal of Applied Social Science Studies / Zeitschrift für Wirtschafts- und Sozialwissenschaften, Duncker & Humblot, Berlin, vol. 133(4), pages 477-510.
    11. Maarten Goos & Alan Manning & Anna Salomons, 2014. "Explaining Job Polarization: Routine-Biased Technological Change and Offshoring," American Economic Review, American Economic Association, vol. 104(8), pages 2509-2526, August.
    12. Wolfgang Dauth & Sebastian Findeisen & Jens Suedekum, 2014. "The Rise Of The East And The Far East: German Labor Markets And Trade Integration," Journal of the European Economic Association, European Economic Association, vol. 12(6), pages 1643-1675, December.
    13. repec:iab:iabfda:201603(en is not listed on IDEAS
    14. Kohlbrecher, Britta & Merkl, Christian & Nordmeier, Daniela, 2016. "Revisiting the matching function," Journal of Economic Dynamics and Control, Elsevier, vol. 69(C), pages 350-374.
    15. Gehrke, Britta & Weber, Enzo, 2018. "Identifying asymmetric effects of labor market reforms," European Economic Review, Elsevier, vol. 110(C), pages 18-40.
    16. Müller, Dana & Strauch, Katharina, 2017. "Identifying mothers in administrative data," FDZ Methodenreport 201713_en, Institut für Arbeitsmarkt- und Berufsforschung (IAB), Nürnberg [Institute for Employment Research, Nuremberg, Germany].
    17. Kurt Schmidheiny & Sebastian Siegloch, 2023. "On event studies and distributed‐lags in two‐way fixed effects models: Identification, equivalence, and generalization," Journal of Applied Econometrics, John Wiley & Sons, Ltd., vol. 38(5), pages 695-713, August.
    18. Rendall, Michelle & Weiss, Franziska J., 2016. "Employment polarization and the role of the apprenticeship system," European Economic Review, Elsevier, vol. 82(C), pages 166-186.
    19. Schmucker, Alexandra & Seth, Stefan & Ludsteck, Johannes & Eberle, Johanna & Ganzer, Andreas, 2016. "Establishment History Panel 1975-2014," FDZ Datenreport. Documentation on Labour Market Data 201603_en, Institut für Arbeitsmarkt- und Berufsforschung (IAB), Nürnberg [Institute for Employment Research, Nuremberg, Germany].
    20. Christian Dustmann & Johannes Ludsteck & Uta Schönberg, 2009. "Revisiting the German Wage Structure," The Quarterly Journal of Economics, President and Fellows of Harvard College, vol. 124(2), pages 843-881.
    21. Thomas Kruppe & Eva Müller & Laura Wichert & Ralf A. Wilke, 2008. "On the Definition of Unemployment and its Implementation in Regis-ter Data - The Case of Germany," Schmollers Jahrbuch : Journal of Applied Social Science Studies / Zeitschrift für Wirtschafts- und Sozialwissenschaften, Duncker & Humblot, Berlin, vol. 128(3), pages 461-488.
    22. repec:iab:iabfme:201810(en is not listed on IDEAS
    23. Ludsteck, Johann & Thomsen, Ulrich, 2016. "Imputation of the working time information for the employment register data," FDZ Methodenreport 201601_en, Institut für Arbeitsmarkt- und Berufsforschung (IAB), Nürnberg [Institute for Employment Research, Nuremberg, Germany].
    24. Antoni, Manfred & Schmucker, Alexandra & Seth, Stefan & Vom Berge, Philipp, 2019. "Sample of integrated labour market biographies (SIAB) 1975-2017," FDZ Datenreport. Documentation on Labour Market Data 201902_en, Institut für Arbeitsmarkt- und Berufsforschung (IAB), Nürnberg [Institute for Employment Research, Nuremberg, Germany].
    25. Jaenichen, Ursula, 2018. "Do we measure employment durations correctly? : The case of German administrative employment data," FDZ Methodenreport 201810_en, Institut für Arbeitsmarkt- und Berufsforschung (IAB), Nürnberg [Institute for Employment Research, Nuremberg, Germany].
    26. Eberle, Johanna & Jacobebbinghaus, Peter & Ludsteck, Johannes & Witter, Julia, 2011. "Generation of time-consistent industry codes in the face of classification changes : Simple heuristic based on the Establishment History Panel (BHP)," FDZ Methodenreport 201105_en, Institut für Arbeitsmarkt- und Berufsforschung (IAB), Nürnberg [Institute for Employment Research, Nuremberg, Germany].
    27. repec:iab:iabfme:201713(en is not listed on IDEAS
    28. repec:iab:iabfme:200502(en is not listed on IDEAS
    29. Bernd Fitzenberger & Aderonke Osikominu & Robert Völter, 2006. "Imputation Rules to Improve the Education Variable in the IAB Employment Subsample," Schmollers Jahrbuch : Journal of Applied Social Science Studies / Zeitschrift für Wirtschafts- und Sozialwissenschaften, Duncker & Humblot, Berlin, vol. 126(3), pages 405-436.
    30. Manuel Sanchez & Felix Wellschmied, 2020. "Modeling Life-Cycle Earnings Risk with Positive and Negative Shocks," Review of Economic Dynamics, Elsevier for the Society for Economic Dynamics, vol. 37, pages 103-126, July.
    31. Dirk Antonczyk & Thomas DeLeire & Bernd Fitzenberger, 2018. "Polarization and Rising Wage Inequality: Comparing the U.S. and Germany," Econometrics, MDPI, vol. 6(2), pages 1-33, April.
    32. repec:iab:iabfme:201105(en is not listed on IDEAS
    33. repec:iab:iabfda:201902(en is not listed on IDEAS
    34. Steven J. Davis & Till Von Wachter, 2011. "Recessions and the Costs of Job Loss," Brookings Papers on Economic Activity, Economic Studies Program, The Brookings Institution, vol. 42(2 (Fall)), pages 1-72.
    35. Christian Hutter & Joachim Möller & Marion Penninger, 2015. "Reducing the Need for Heuristic Rules - An Iterative Algorithm for Imputing the Education Variable in SIAB," Schmollers Jahrbuch : Journal of Applied Social Science Studies / Zeitschrift für Wirtschafts- und Sozialwissenschaften, Duncker & Humblot, Berlin, vol. 135(3), pages 355-388.
    36. Bernd Fitzenberger & Arnim Seidlitz, 2020. "The 2011 break in the part-time indicator and the evolution of wage inequality in Germany," Journal for Labour Market Research, Springer;Institute for Employment Research/ Institut für Arbeitsmarkt- und Berufsforschung (IAB), vol. 54(1), pages 1-14, December.
    37. repec:iab:iabfme:201601(en is not listed on IDEAS
    38. repec:iab:iabfme:201809(en is not listed on IDEAS
    Full references (including those not matched with items on IDEAS)

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Hannah Illing & Johannes Schmieder & Simon Trenkle, "undated". "The Gender Gap in Earnings Losses After Job Displacement," CRC TR 224 Discussion Paper Series crctr224_2022_381, University of Bonn and University of Mannheim, Germany.
    2. Dauth, Wolfgang & Eppelsheimer, Johann, 2020. "Preparing the sample of integrated labour market biographies (SIAB) for scientific analysis," Journal for Labour Market Research, Institut für Arbeitsmarkt- und Berufsforschung (IAB), Nürnberg [Institute for Employment Research, Nuremberg, Germany], vol. 54(1), pages 1-10.
    3. Dauth, Wolfgang & Eppelsheimer, Johann, 2020. "Preparing the sample of integrated labour market biographies (SIAB) for scientific analysis," Journal for Labour Market Research, Institut für Arbeitsmarkt- und Berufsforschung (IAB), Nürnberg [Institute for Employment Research, Nuremberg, Germany], vol. 54(1), pages .10(1-10).
    4. repec:iab:iabjlr:v:54:i:1:p:art.10 is not listed on IDEAS
    5. Winkler, Erwin, 2020. "Diverging paths: Labor reallocation, sorting, and wage inequality," VfS Annual Conference 2020 (Virtual Conference): Gender Economics 224535, Verein für Socialpolitik / German Economic Association.
    6. Boddin, Dominik & Kroeger, Thilo, 2021. "Structural change revisited: The rise of manufacturing jobs in the service sector," Discussion Papers 38/2021, Deutsche Bundesbank.
    7. Baumgarten, Daniel & Irlacher, Michael & Koch, Michael, 2020. "Offshoring and non-monotonic employment effects across industries in general equilibrium," European Economic Review, Elsevier, vol. 130(C).
    8. Blien, Uwe & Dauth, Wolfgang & Roth, Duncan H.W., 2021. "Occupational routine intensity and the costs of job loss: evidence from mass layoffs," Labour Economics, Elsevier, vol. 68(C).
    9. Fackler, Daniel & Müller, Steffen & Stegmaier, Jens, 2017. "Explaining wage losses after job displacement: Employer size and lost firm rents," IWH Discussion Papers 32/2017, Halle Institute for Economic Research (IWH).
    10. Konstantin Koerner, 2023. "The wage effects of offshoring to the East and West: evidence from the German labor market," Review of World Economics (Weltwirtschaftliches Archiv), Springer;Institut für Weltwirtschaft (Kiel Institute for the World Economy), vol. 159(2), pages 399-435, May.
    11. Janssen, Simon & Mohrenweiser, Jens, 2018. "The Shelf Life of Incumbent Workers during Accelerating Technological Change: Evidence from a Training Regulation Reform," IZA Discussion Papers 11312, Institute of Labor Economics (IZA).
    12. Carrillo-Tudela, Carlos & Launov, Andrey & Robin, Jean-Marc, 2021. "The fall in german unemployment: A flow analysis," European Economic Review, Elsevier, vol. 132(C).
    13. repec:iab:iabfda:202110(en is not listed on IDEAS
    14. Schmucker, Alexandra & Ganzer, Andreas & Stegmaier, Jens & Wolter, Stefanie, 2018. "Establishment History Panel 1975-2017," FDZ Datenreport. Documentation on Labour Market Data 201809_en, Institut für Arbeitsmarkt- und Berufsforschung (IAB), Nürnberg [Institute for Employment Research, Nuremberg, Germany].
    15. Koomen, Miriam & Backes-Gellner, Uschi, 2022. "Occupational tasks and wage inequality in West Germany: A decomposition analysis," Labour Economics, Elsevier, vol. 79(C).
    16. Neffke, Frank & Nedelkoska, Ljubica & Wiederhold, Simon, 2024. "Skill mismatch and the costs of job displacement," Research Policy, Elsevier, vol. 53(2).
    17. Peichl, Andreas & Popp, Martin, 2022. "Can the Labor Demand Curve Explain Job Polarization?," IAB-Discussion Paper 202221, Institut für Arbeitsmarkt- und Berufsforschung (IAB), Nürnberg [Institute for Employment Research, Nuremberg, Germany].
    18. Moritz Drechsel‐Grau & Andreas Peichl & Kai D. Schmid & Johannes F. Schmieder & Hannes Walz & Stefanie Wolter, 2022. "Inequality and income dynamics in Germany," Quantitative Economics, Econometric Society, vol. 13(4), pages 1593-1635, November.
    19. Bernd Fitzenberger & Arnim Seidlitz, 2020. "Die Lohnungleichheit von Vollzeitbeschäftigten in Deutschland: Rückblick und Überblick [Wage inequality among the full-time employed in Germany revisited: An overview]," AStA Wirtschafts- und Sozialstatistisches Archiv, Springer;Deutsche Statistische Gesellschaft - German Statistical Society, vol. 14(2), pages 125-143, July.
    20. Eliason, Marcus & Hensvik, Lena & Kramarz, Francis & Skans, Oskar Nordström, 2023. "Social connections and the sorting of workers to firms," Journal of Econometrics, Elsevier, vol. 233(2), pages 468-506.
    21. Andreas Gulyas & Krzysztof Pytka, 2019. "Understanding the Sources of Earnings Losses After Job Displacement: A Machine-Learning Approach," CRC TR 224 Discussion Paper Series crctr224_2019_131, University of Bonn and University of Mannheim, Germany.
    22. Eggenberger, Christian & Janssen, Simon & Backes-Gellner, Uschi, 2022. "The value of specific skills under shock: High risks and high returns," Labour Economics, Elsevier, vol. 78(C).

    More about this item

    Keywords

    IAB; SIAB; IEB; Data preparation; Stata; Event study;
    All these keywords.

    JEL classification:

    • C55 - Mathematical and Quantitative Methods - - Econometric Modeling - - - Large Data Sets: Modeling and Analysis
    • C81 - Mathematical and Quantitative Methods - - Data Collection and Data Estimation Methodology; Computer Programs - - - Methodology for Collecting, Estimating, and Organizing Microeconomic Data; Data Access
    • J65 - Labor and Demographic Economics - - Mobility, Unemployment, Vacancies, and Immigrant Workers - - - Unemployment Insurance; Severance Pay; Plant Closings

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:spr:jlabrs:v:54:y:2020:i:1:d:10.1186_s12651-020-00275-9. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Sonal Shukla or Springer Nature Abstracting and Indexing (email available below). General contact details of provider: http://www.springer.com .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.