Restructuring Data in SPSS – Overview

SPSS basic VARSTOCASES Example

SPSS offers several simple ways for restructuring data. VARSTOCASES -short for “variables to cases”- stacks variables on top of each other.

Its reverse is CASESTOVARS -short for “cases to variables”. It basically stacks groups of cases behind each other in new variables.

AGGREGATE adds summary statistics such as frequencies, sums and means to your data, optionally collapsing cases in the process.

Finally, FLIP basically transposes data by rotating the entire dataset by 90 degrees.

/

SPSS VARSTOCASES Tutorials

SPSS VARSTOCASES – What and Why?

SPSS VARSTOCASES is short for “variables to cases”. It restructures data by stacking variables on top of each other. This tutorial also shows a major pitfall in SPSS VARSTOCASES. Read More

SPSS VARSTOCASES With Labels Tool

Simple, menu based tool for running SPSS VARSTOCASES while retaining variable labels of input variables. Comes in very handy for creating nice charts and tables. Read More

SPSS AGGREGATE Tutorials

SPSS AGGREGATE Command

Aggregate is an SPSS command for creating variables holding statistics over cases. This tutorials briefly demonstrates the most common scenarios and points out some best practices. Read More

Disaggregate Data

Sometimes, one may start a project with aggregated data, weighted by a frequency variable. In some cases, though, disaggregating such data (creating n rows for a row with frequency n) may be desired. Read More