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"):
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):
Next
Why Don't My Percentages Add Up to 100%
How to Remove Don't Know Categories
How to Exclude Don't Knows from Averages but Include in Percentages
How to Set Value Attributes for a Binary-Multi and Binary-Grid
How to Set High or Low Values to Missing in Numeric Variables
Watch our Understanding Variable Sets video