Restructuring Data in SPSS – Overview
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 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
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
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
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