GESIS Leibniz Institute for the Social Sciences: Go to homepage

Programme for the International
Assessment of Adult Competencies

Stata- and SAS-Macros

The OECD provides macros for calculations in both Stata and SAS available. Furthermore there is a set of Excel functions provided by Educational Testing Service (ETS) and the International Association for the Evaluation of Educational Achievement (IEA). In order to access these functions please download the Excel add-in called "LSA_Stats.xla (51 kB)" and the related documentation (76 kB).


Stata calculations

Stata-commands: Potential Analysis:

Stata module to run estimations with weighted replicate samples and plausible values. For additional information please see here.

PIAACTOOLS Stata module to obtain correct estimates of basic statistics and facilitate regression analysis with PIAAC data. For more information please see here and consult the user manual.


Basic statistics like average, median, percentile and standard deviation


Regressions (e.g., logit, probit, poisson etc.)

  • PV as dependent variable: pvdep()
  • PV as independent variable: pvindep1(), pvindep2(), pvindep3()


Frequencies on competency levels.


SAS calculations


For additional information please consult the user manual.