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 combined together into a single category:
Requirements
A table containing multiple categories with two or more small values (percentages) that you want to combine.
Method
1. Select the table containing the categories that you want to combine.
2. From the toolbar menu, select Anything > Data > Variables > Modify > Combine Categories and select on of the following options:
- Combine Categories of Size 0.5% or Less
- Combine Categories of Size 1% or Less
- Combine Categories of Size 2% or Less
- Combine Categories of Size 3% or Less
- Combine Categories of Size 4% or Less
- Combine Categories of Size 5% or Less
- Scale (Custom)
Any categories with a percentage lower than the selected value will be combined into a single category.
3. Select the row label of the combined categories.
4. From the toolbar menu select Rename, or right-click and select Rename.
5. Enter a new label for the combined row (for example, "All others").
6. Click the Rename button.
Next
How to Add Top K Category Variables
How to Add Bottom K Category Variables
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
How to Exclude Don't Knows from Averages but Include in Percentages