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]

Contact: Bernhard Schimpl-Neimanns

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 and 2014


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

    panel_1213_v2.sas
    panel_1213_v2.sps
    panel_1213_v2.do