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:
REPEST	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.
piaacdes	Basic statistics like average, median, percentile and standard deviation
piaacreg	Regressions (e.g., logit, probit, poisson etc.) PV as dependent variable: pvdep() PV as independent variable: pvindep1(), pvindep2(), pvindep3()
piaactab	Frequencies on competency levels.

SAS calculations

Installation: https://www.oecd.org/skills/piaac/data/collapsecontents/PIAAC_Tool%202.0%20web.zip

For additional information please consult the user manual.