LibGuides: SPSS Tutorials: Working with Data

Part 1: Working with Variables

Most of the time, you'll need to make modifications to your variables before you can analyze your data. These types of modifications can include changing a variable's type from numeric to string (or vice versa), merging the categories of a nominal or ordinal variable, dichotomizing a continuous variable at a cut point, or computing a new summary variable from existing variables. This section will focus on transformations applied to individual variables, particularly recoding and computing new variables.

Computing Variables
The "Compute Variable" command allows you to create new variables from existing variables by applying formulas. This tutorial shows how the "Compute Variable" command can compute a variable using an equation, a built-in function, or conditional logic.
Mean Centering
Mean centering refers to a type of variable transformation wherein the average of a variable is subtracted from every observation of that variable. In SPSS, we can use the Aggregate procedure in conjunction with the Compute Variables procedure to mean-center.
Recoding (Transforming) Variables
Recoding a variable can be used to transform an existing variable into a different form based on certain criteria. This tutorial covers the "Recode into Different Variable" and "Recode into Same Variable" commands.
Automatic Recode
If you have a string variable and have used blanks to indicate missing values, you may notice that SPSS does not automatically recognize the blank observations as missing. To fix this, you'll need to use Automatic Recode. More broadly, Automatic Recode is also used to quickly convert a string categorical variable into a numeric categorical variable.
Rank Cases
In its simplest form, a rank transform converts a set of data values by ordering them from smallest to largest, and then assigning a rank to each value. In SPSS, the Rank Cases procedure can be used to compute the rank transform of a variable.

Part 2: Data Management

Managing a dataset often includes tasks such as sorting data, subsetting data into separate samples, merging multiple sources of data, aggregating of data based on some key indicator, or restructuring a dataset. These types of data management tasks are sometimes called data cleaning, data munging, or data wrangling. This section covers these types of "cleaning" tasks.

Sorting Data
Sorting a dataset rearranges the rows with respect to one or more variables. Sorting makes it convenient for reading the data; additionally, several SPSS procedures require the data to be sorted in a certain way before the procedure can run. This tutorial discusses how to sort data using the drop-down menus in SPSS.
Splitting Data
In SPSS, the "Split File" command can be used to organize statistical results into groups for comparison. Split File is used when you want to run statistical analyses with respect to different groups, but don't necessarily want to separate your data into two different files. This tutorial shows you how to use the Split File command in SPSS and what situations it is useful in.
Weighting Cases
Sometimes, you don't have raw data available to you -- you may only have a frequency table indicating the types of responses and how many times they occurred. Alternatively, you may be working with a dataset that contains a weighting variable. This tutorial shows how to use the Weighting Cases command in SPSS to handle both of these situations.
Partitioning Data
(Coming soon) The Select Cases procedure is used when you want to create a new dataset by extracting cases from an existing dataset. Unlike the Split File option, Select Cases affects the data itself, rather than the output. This tutorial covers several applications of Select Cases.

Library Locations at the Kent Campus

Regional Campus Libraries

SPSS Tutorials: Working with Data

Sample Data Files

Part 1: Working with Variables

Part 2: Data Management

Street Address

Mailing Address

Contact Us

Quick Links

Information