Skip to content
In the picture there are the hands of two persons pointing at a graphic on a tablet PC.

Key working Tools of the FDZ

The following guidelines and working tools will help you to analyse the data of the FDZ via On-Site Use or Remote Data Access:

Overviews and working tools on classifications as well as upper earnings limits and marginal part-time income thresholds:

  • Overview on classifications (economic activities, occupations, education, nationality, districts, employment agencies) (Excel)
  • Upper earnings limits and marginal part-time income thresholds - Stata-dofile (zip)

Other:

Papers with dofiles on working with FDZ data

Following listed „FDZ Methodenreporte“ and similar publications provide dofiles which may be helpful for handling and preparation of the FDZ (in particular administrative) data. The FDZ does not guarantee for the correctness of the contents. We strongly advise users to check if the provided working tools are correct and can be applied to their research interests. Please consider that some working tools are created for particular datasets or versions of datasets. Hence they could not be applied to other datasets or versions without adaptions.

Data preparation of administrative data

Schmucker, Alexandra; vom Berge, Philipp (2023): Creating cross-sectional data and biographical variables with the Sample of Integrated Labour Market Biographies 1975-2021 * Programming examples for Stata. FDZ-Methodenreport, 03/2023 (en), Nürnberg
Further Information

Schmucker, Alexandra; vom Berge, Philipp (2021): Creating cross-sectional data and biographical variables with the Sample of Integrated Labour Market Biographies 1975-2019 * Programming examples for Stata. FDZ-Methodenreport, 05/2021 (en), Nürnberg 
Further Information

Stüber, Heiko; Dauth, Wolfgang; Eppelsheimer, Johann (2023): A guide to preparing the sample of integrated labour market biographies (SIAB, version 7519 v1) for scientific analysis. Journal for Labour Market Research, Volume 57, Article number: 7
Further Information

Jaenichen, Ursula (2018): Do we measure employment durations correctly? * The case of German administrative employment data. (FDZ-Methodenreport, 10/2018 (en)), Nürnberg
Further Information

Erhardt, Klaudia; Künster, Ralf (2014): Das Splitten von Episodendaten mit Stata * Prozeduren zum Splitten sehr umfangreicher und/oder tagesgenauer Episodendaten. FDZ-Methodenreport, 07/2014 (de), Nürnberg
Further Information

Data preparation PASS

Bethmann, Arne; Klawitter, Maren (2015): PASS Quick Start File. Spellinformationen im Querschnitt. FDZ-Methodenreport, 04/2015 (de), Nürnberg
Further Information

Bethmann, Arne; Fuchs, Benjamin; Wurdack, Anja (2013): User Guide „Panel Study Labour Market and Social Security” (PASS) Wave 6. FDZ-Datenreport, 07/2013 (en), Nürnberg.
Further Information

Data preparation IAB Establishment Panel

Hinz, Tina; Stegmaier, Jens (2018): Providing a consistent measure of further training for the IAB Establishment Panel. FDZ-Methodenreport, 02/2018 (en), Nürnberg 
Further Information

Müller, Steffen (2017): Capital stock approximation with the perpetual inventory method: An update. FDZ-Methodenreport, 05/2017 (en), Nürnberg
Further Information

Umkehrer, Matthias (2017): Combining the waves of the IAB Establishment Panel * a do-file for the basic data preparation of a panel data set in Stata. FDZ-Methodenreport, 12/2017 (en), Nürnberg 
Further Information

Umkehrer, Matthias (2017): Zusammenführen der Wellen des IAB-Betriebspanels * Ein Do-File für die grundlegende Aufbereitung eines Paneldatensatzes in Stata. FDZ-Methodenreport, 12/2017 (de), Nürnberg 
Further Information

Aggregate data

vom Berge, Philipp (2023): Population aggregates from administrative data samples – how good are they? Journal for Labour Market Research, Volume 57, Article number: 5
Further Information

Wage

Gunselmann, Isabelle (2014): Programmierbeispiele zur Umrechnung des Brutto- in ein Netto-Tagesentgelt für die administrativen Daten des FDZ. FDZ-Methodenreport, 01/2014 (de), Nürnberg
Further Information

Gartner, Hermann (2005): The imputation of wages above the contribution limit with the German IAB employment sample. FDZ-Methodenreport, 02/2005 (en), Nürnberg
Further Information

Classification of occupations

Dengler, Katharina; Matthes, Britta; Paulus, Wiebke (2014): Berufliche Tasks auf dem deutschen Arbeitsmarkt * Eine alternative Messung auf Basis einer Expertendatenbank. FDZ-Methodenreport, 12/2014 (de), Nürnberg
Further Information

Dengler, Katharina; Matthes, Britta; Paulus, Wiebke (2014): Occupational Tasks in the German Labour Market * An alternative measurement on the basis of an expert database. FDZ-Methodenreport, 12/2014 (en), Nürnberg
Further Information

Identification of maternity leaves / mothers

Müller, Dana; Filser, Andreas; Frodermann, Corinna (2022): Update: Identifying mothers in administrative data. FDZ-Methodenreport, 01/2022 (en), Nürnberg
Further Information

Schönberg, Uta (2008): Does the IABS reliably identify maternity leave taking? FDZ-Methodenreport, 03/2008 (en), Nürnberg
Further Information

Part-time

Fitzenberger, Bernd; Seidlitz, Arnim (2020): The 2011 break in the part-time indicator and the evolution of wage inequality in Germany. Journal for Labour Market Research 01/2020
Further Information

Further papers on data of the FDZ and data access

Following listed „FDZ Methodenreporte“ and similar publications describe the data and data access options offered by FDZ.

Person and establishment fixed effects

Lochner, Benjamin; Seth, Stefan; Wolter, Stefanie: AKM effects for German labour market data 1985-2021. FDZ-Methodenreport, 01/2023 (en), Nürnberg
Further Information (pdf)

Bellmann, Lisa; Lochner, Ben; Seth, Stefan; Wolter, Stefanie (2020): AKM effects for German labour market data. FDZ-Methodenreport, 01/2020 (en), Nürnberg
Further Information (pdf)

Card, David; Heining, Jörg; Kline, Patrick (2015): CHK Effects. FDZ-Methodenreport, 06/2015 (en), Nürnberg
Further Information (pdf)

Corrected working hours

vom Berge, Philipp; Umkehrer, Matthias; Wanger, Susanne (2023): A correction procedure for the working hours variable in the IAB employee history. Journal for Labour Market Research, Volume 57, Article number: 10
Further Information

Education

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, 09/2018 (en), Nürnberg
Further Information

Drews, Nils (2006): Qualitätsverbesserung der Bildungsvariable in der IAB-Beschäftigtenstichprobe 1975-2001. FDZ-Methodenreport, 05/2006 (de), Nürnberg
Further Information (pdf)

Fitzenberger, Bernd; Osikominu, Aderonke; Völter, Robert (2005): Imputation rules to improve the education variable in the IAB employment subsample. FDZ-Methodenreport, 03/2005 (en), Nürnberg
Further Information (pdf)

Wage

Drechsler, Jörg, Johannes Ludsteck & Andreas Moczall (2023): Imputation der rechtszensierten Tagesentgelte für die BeH. FDZ-Methodenreport 05/2023 (de), Nürnberg, 25 S.
Further Information

Classification of occupations

Paulus, Wiebke; Matthes, Britta (2013): Klassifikation der Berufe * Struktur, Codierung und Umsteigeschlüssel. FDZ-Methodenreport, 08/2013 (de), Nürnberg, 35 S.
Further Information (pdf)

Paulus, Wiebke; Matthes, Britta (2013): The German classification of occupations 2010 * structure, coding and conversion table. FDZ-Methodenreport, 08/2013 (en), Nürnberg
Further Information (pdf)

Identification of establishment extries and exits

Fackler, Daniel; Hank, Eva; Müller, Steffen; Stegmaier, Jens (2017): Identifying bankruptcies in German social security data. FDZ-Methodenreport, 10/2017 (en), Nürnberg 
Further Information (pdf)

Hethey, Tanja; Schmieder, Johannes F. (2010): Using worker flows in the analysis of establishment turnover * evidence from German administrative data. FDZ-Methodenreport, 06/2010 (en), Nürnberg
Further Information (pdf)

Time-consistent industry codes

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, 05/2011 (en), Nürnberg
Further Information

Operationalisation of unemployment

Kruppe, Thomas; Müller, Eva; Wichert, Laura; Wilke, Ralf A. (2007): On the definition of unemployment and its implementation in register data * the case of Germany. FDZ-Methodenreport, 03/2007 (en), Nürnberg
Further Information (pdf)

Part-time

Ludsteck, Johann; Thomsen, Ulrich (2016): Imputation of the working time information for the employment register data. FDZ-Methodenreport, 01/2016 (en), Nürnberg
Further Information (pdf)

Data access

Eberle, Johanna; Müller, Dana; Heining, Jörg (2017): A modern job submission application to access IAB's confidential administrative and survey research data. FDZ-Methodenreport, 01/2017 (en), Nürnberg
Further Information (pdf)

Heining, Jörg; Bender, Stefan (2012): Technische und organisatorische Maßnahmen für den Fernzugriff auf die Mikrodaten des Forschungsdatenzentrums der Bundesagentur für Arbeit. FDZ-Methodenreport, 08/2012 (de), Nürnberg
Further Information (pdf)

Heining, Jörg; Bender, Stefan (2012): Technical and organisational measures for remote access to the micro data of the Research Data Centre of the Federal Employment Agency. FDZ-Methodenreport, 08/2012 (en), Nürnberg
Further Information (pdf)

Data protection

Hochfellner, Daniela; Müller, Dana; Schmucker, Alexandra; Roß, Elisabeth (2012): Datenschutz am Forschungsdatenzentrum. FDZ-Methodenreport, 06/2012 (de), Nürnberg
Further Information (pdf)

Hochfellner, Daniela; Müller, Dana; Schmucker, Alexandra; Roß, Elisabeth (2012): Data protection at the Research Data Centre. FDZ-Methodenreport, 06/2012 (en), Nürnberg
Further Information (pdf)

Further working tools

You will find further working tools for each data set on the corresponding sites of the FDZ website.