How to Turn Off Missing Data Selection for Specific Values

Sometimes you may want to change your outputs to show percentages against the total sample. This article describes how go from variable sets that currently have missing data (i.e., Missing Values are set to "Exclude from analyses"):

Screenshot 2024-04-23 144630.png

to one that includes the missing data selection in analyses:

Requirements

Familiarity with the Structure and Value Attributes of Variable Sets.
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.

Please note this requires the Data Stories module or a Displayr license.

Method 1 - Include in all analyses and statistics

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

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

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

4. Click OK.

Method 2 - Include in Percentages exclude from Averages

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

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

3. Enter the original values (numeric or NaN) 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):

Screenshot 2024-04-23 145835.png