PSPP for Beginners

Sorting Data

Sometimes it is useful to sort the cases into groups. For example, a teacher might want to sort class grades from the highest to the lowest to identify the top and bottom students in a class. PSPP has several ways to accomplish this goal.

The Data menu has a Sort Cases command.

The sort cases command is in the Data drop down menu.

The Sort Cases dialog box has a list of variables on the left and a blank Sort by field on the right.

A blank sort cases dialog box is shown.

Choose the variables that you want to use by moving them to the Sort by field. The order is important, with the first field being the most important. For this example let's sort the data file by Sex and then by Last name. The Sort Order Ascending option will organize the cases from lowest to highest. The Descending option is from highest to lowest. Click the okay button when you are finished.

The sort cases dialog box with the Sex and Last name fields entered.

The data fields are now grouped into males (first two rows) and females.

The data file that has been sorted into males and females (first) and next into Last name.

Index | Next - Sorting by columns

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License that allows sharing, adapting, and remixing.