How to Recode High Values (Capping) in Numeric Variables

Sometimes you may want to cap Numeric variable to a certain number. This can be useful if you have high outliers in your data due to typos and other input errors. You can recode these high outliers to a value you set. This article describes how to take a numeric question with high values:

And recode the values so that the high values are capped at a selected value: 

Requirements

• A data set containing one or more Numeric variables with high values that you want to cap. 

Method

1. In the Data Sources pane, select the Numeric variables with high values you want to cap.

2. Click the icon > Data > Variables > Modify > Recode > Recode Low Values (Capping) in Numeric Variable(s). 

4. Enter the value to use as the cap (I used 100 in the example above). All values higher than the value entered will be recoded to that value and click OK.

Next

How to Create Top K Category Variable(s) (Top K Boxes)

How to Create Bottom K Category Variable(s) (Bottom K Boxes)

How to Recode Low Values (Capping) in Numeric Variables

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

How to Combine Categories with Small Percentages

How to Remove Don't Know Categories

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