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

During the data cleaning process, you may find outliers in your Numeric data. You can cap these low/high outliers or treat those values as missing data automatically for the variables you select. This article describes how to recode a numeric variable containing high or low outlier values: 

To one where those outliers are excluded from reporting and analyses: 

Requirements

• Numeric variable(s) containing high or low outlier values that you want to recode as missing values. 

Method

1. From the Data Sources tree, select your Numeric variable(s), or select the data set name to do this for all numeric variables in the data set. 

2. From the toolbar, go to Anything > Data > Variables > Modify > Recode > and then select one of the following depending on whether you want to set high or low values as missing: 

• Set High Values to Missing in Numeric Variable(s).
• Set Low Values to Missing in Numeric Variable(s).

3. Enter the value that you want to use as the cutoff, similar to the high values cut-off dialog below:

Next

How to Rebase Multiple Response Data in Variable(s) to NET

How to Create Top Category Variable(s) (Top 2 Box, Top 3 Box, Top K Box)

How to Create Bottom Category Variable(s) (Bottom 2 Box, Bottom 3 Box, Bottom K Box)

How to Recode High Values (Capping) in Numeric Variables

How to Recode Low Values (Capping) in Numeric Variables

How to Remove Don't Know Categories