How to Recode a Variable Using Category Midpoints

This article describes how to recode a categorical variable in which the value attributes are coded with standard numeric coding (i.e., 1, 2, 3, etc.):

To a variable with the value attributes are recoded using the midpoints of the categorical ranges: 

Requirements

• A categorical variable with numeric ranges which represent each category (i.e., 18 to 24, or 25-29), but is coded with standard numeric codes/values (i.e., 1, 2, 3, etc.). 

Method

1. Select the categorical variable in the Data Sources tree, and click + > Numeric Transformations > Category Midpoints.
2. Click the Values button from the object inspector to review and confirm the assigned midpoint values. 

You can also recode the variable into a new Numeric variable using this process: How to Create Numeric Variable(s) from Code/Category Midpoints.

Next

How to Recode Net Promoter Score (NPS) Variable(s)

How to Create Numeric Variable(s) from Code/Category Midpoints

How to Exclude Don't Knows from Averages but Include in Percentages

How to Recode into Existing or New Variables

How to Set High or Low Values to Missing in Numeric Variables