SPSS: Data Editor: Working With Data

Split File

Use the split file command to divide the file into categories for reporting. When reports are generated, results will be given for each portion. Useful for categorical data like the gender, so the male and female descriptives are separate. Equivalent to "Data / Split File".

The data must be sorted to use the Split File command. The easiest way to do this for small sample sizes is to have the split file command do the sorting for you.

You have two options for splitting the file. The "Compare groups" option will present the data for male and female next to each other for each sub-report. The "Organize output by groups" will create one report with all information for males and another report for all information for females.

Use the "Analyze all cases, do not create groups" to turn off the file split.

Use Select case if you want to limit which cases are selected but only want one report.

Select Cases

Filter the data so that only certain cases are included. An example might be to include only those people over 18. Select cases will give one report for a subset of the data. Equivalent to "Data / Select Cases".

Choose the "If condition is satisfied" option and then click on the "If ...".

Let's say that I want all people whose birthdays are in the first six months of the year. Enter "birth <= 6" using the variable selection and keypad. Then click on "Continue".

After returning to the filter screen, click "OK".

When you get back to the main data editor screen, you will notice that there are certain rows that have slashes through the row number. Those cases are no longer selected and will not be used in any reporting.

Use Split file instead of select cases if you want multiple reports.

You can combine split file with select cases to filter the data and generate multiple reports.