Zur Missy-Homepage

Metadata for Official Statistics

Microcensus Scientific Use Files from 2012 onward as a Rotational Panel

In the microcensus, each sampling district remains in the sample for four years, and 25% of the sample is replaced each year. A new procedure for the subsample and time-consistent identifiers since the 2012 scientific use file allow to use this feature of a rotational panel. This offers further analysis possibilities.

The paper (available in German) describes how researchers can independently create panel files and what has to be taken into account. In addition, there are programs for SAS, SPSS and Stata for linking the cross-sectional data.

  • Herter-Eschweiler, R.; Schimpl-Neimanns, B., 2018: Möglichkeiten der Verknüpfung von Mikrozensus-Querschnitterhebungen ab 2012 zu Panels [.pdf]

SAS-, SPSS- and Stata-Program

Please note:

The syntax files should be downloaded and used with statistics programs. The browser view provides only an overview. Characters with an Umlaut and line breaks are sometimes displayed incorrectly.

Version 1 (longitudinal orientation):
For analysing gross changes and survival analysis
  • 2012, 2013, 2014 and 2015

  • panel_12131415_v1.sas
  • 2012, 2013 and 2014
  • panel_121314_v1.sas
  • 2012 and 2013
  • panel_1213_v1.sas
    Version 2 (cross-sectional orientation):
    For the analysis of net changes or cumulated data from consecutive years