Tag: cases in rows

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. […]

SPSS FILTER – Quick & Simple Tutorial

SPSS FILTER temporarily excludes a selection of cases from all data analyses.For excluding cases from data editing, use DO IF or IF instead. SPSS Filtering Basics Example 1 – Exclude Cases with Many Missing Values Example 2 – Filter on 2 Variables Example 3 – Filter without Filter Variable Tip – Commands with Built-In Filters Warning – Data Editing with […]