How to Turn Off Missing Data Selection for Specific Values

Introduction

This article describes how to change value attributes of a variable or variable set that are currently set to missing data  (i.e., Missing Values are set to "Exclude from analyses"): 

And turn off the missing data selection so that the values are included in analyses: 

Requirements

• A data set containing a variable or variable set with a specific value set to missing data (i.e., Missing Values are set to "Exclude from analyses") in the Value Attributes settings. 

Method 1

1. Select your variable or variable set containing the missing data values from the Data Sets tree. 

2. In the object inspector click Properties > DATA VALUES > Missing Values 

3. In the Value Attributes dialog, change the Missing Values drop-downs to Exclude from analyses for each code you want to exclude.

4. Click OK. 

Method 2

1. Select your variable or variable set containing the missing data values from the Data Sets tree. 

2. From the toolbar menu, select Anything > Data > Variables > Modify > Recode > Turn Off Missing Data Selection for Specific Values. 

3. Enter the values that you want to turn off the missing data setting for. To enter multiple values, separate each value with a comma. 

4. Click OK. 

The value attribute setting will be changed to "Include in percentages (but not in averages): 

See Also

How to set Value Attributes for a Binary-Multi and Binary-Grid

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