SigmaAnalytics & Tech
B7SPSSBeginnerAbout 30 min to complete

Restructure: select, split, merge, long/wide

Every operation in this module answers one of those two questions. The first three are reversible and persistent; the last three change the file itself.

Slides · Dataset

About 30 minutes to complete

Enrol to open the slides and download the data.

By the end of it

  • Subset and split a file without the state leaking into later analyses
  • Merge two files, both ways, without losing anybody
  • Move a repeated-measures file between wide and long, in both directions
  • Aggregate up a level, deliberately

The dataset

Health education intervention, three time points — Sigma teaching dataset

A teaching dataset of 120 cases, generated from a fixed seed so every figure in the module reproduces exactly.

  • CodebookIncluded
  • Dataset (CSV)Included
  • SPSS syntaxIncluded