Introduction
This article describes how to go from a table displaying multiple categories including several with small (5% of less) percentages:
To a table displaying the small categories merged together into a single category:
Requirements
A table containing multiple categories with two or more small values (percentages) that you want to merge together.
Method
1. Select the table containing the categories that you want to merge.
2. From the toolbar menu, select Anything > Data > Variables > Modify > Merge Categories and select on of the following options:
- Merge Categories of Size 0.5 or Less
- Merge Categories of Size 1 or Less
- Merge Categories of Size 2 or Less
- Merge Categories of Size 3 or Less
- Merge Categories of Size 4 or Less
- Merge Categories of Size 5 or Less
Any categories with a percentage lower than the selected value will be combined into a single category.
3. Select the row label of the merged categories.
4. From the toolbar menu select Rename.
5. Enter a new label for the merged row (for example, "All others").
6. Click the Rename button.
See Also
How to Add Top K Category NETs
How to Add Bottom K Category NETs
How to Recode Values (Capping) in Numeric Variables
How to Recode Low Values (Capping) in Numeric Variables
How to Remove Don't Know Categories
How to Remove the 'Don't Know' Category from a Question
Comments
0 comments
Article is closed for comments.