SPSS tutorials website header logo

SPSS tutorials


SPSS SPLIT FILE – A Quick Tutorial

SPLIT FILE is a command for having separate output for subsets of cases. It does not literally split your file into smaller files. Subsets are defined by the values on one or more split variables. After running SPLIT FILE, output is reported for each split group separately until you run SPLIT FILE OFF.

SPSS Split File Output Example of output split by education_type

SPSS Split File - Basic Use

Similarly to FILTER and WEIGHT, SPLIT FILE has three main commands.

  1. SPLIT FILE BY [...]. switches it on or changes the variable(s) defining the groups of cases.
  2. SHOW SPLIT FILE. tells you which variable(s) define groups of cases.
  3. SPLIT FILE OFF. switches SPLIT FILE off.
SPSS Split File On Status bar reports split file

SPSS Split File - Notes

SPSS Split File Example

We had our employees fill out a tiny questionnaire, the data of which are in employees.sav. We'd now like to explore these data separately for respondents with different education types. The syntax below gives and example of doing so by SPLIT FILE. It presumes you already have the data open.

SPSS Split File Syntax

*1. Sort cases before we can use split file.

sort cases by education_type.

*2. Split file and organize output as separate tables.

split file separate by education_type.

*3. Quick check.

show split file.

*4. Have a look at monthly_income.

descriptives monthly_income.

*5. Switch split file off.

split file off.

Previous tutorial: SPSS SELECT IF – Simple Tutorial

Next tutorial: SPSS WEIGHT Command

Let me know what you think!

*Required field. Your comment will show up after approval from a moderator.

This tutorial has 1 comment!