Introduction
There are different ways of removing categories from tables and each has a different consequence. This article describes how to hide and remove categories from tables.
Requirements
A Displayr document with tables created from Nominal: Mutually exclusive categories, Nominal - Multi: Grid with unordered categories or Binary - Multi: Non-mutually exclusive categories variable sets.
Method
Removing categories and setting values as missing
Right-clicking on a category of a Nominal or Nominal - Multi table and selecting Delete simultaneously hides the category and recomputes the percentages in the table (i.e., if it is categorical data, the percentages are re-based).
You can undo these changes by pressing undo or by right-clicking on the table and selecting Reset > Table Categories.
When categories are mutually exclusive (i.e., from a Nominal or Nominal - Multi variable set) you can also select the variable set from the Data Sets tree and then click on the Values button in the object inspector on the right. to open the Value Attributes dialogue box. Here you can change the selections in the Missing Data column to Exclude from analyses to delete a category from the table. This is identical to using the Delete option described above.
Re-basing multiple response (Binary - Multi) variable sets
When using Delete on a table created from a Binary - Multi variable set, you will sometimes see the NET drop below 100%. This is because some respondents will not have selected any of the responses in the question. One solution to this is to create a filter based on the NET and apply it to the table. This will ensure that the NET will be 100%. You can do this by selecting the variable set in the Data Sets tree and then from the toolbar menu, select Anything > Calculation > Any of > Any of. This will create a new binary variable based on the NET. With the new variable selected, go to Properties in the object inspector and check Useable as a filter. You can then apply this filter to the existing table which will then be based to the NET.
Hiding categories
You can also right-click on a category in a table and select Hide to prevent it from being shown in the table. When you hide a category in this way, no change is made to the other values on the table. You can undo hiding by pressing undo, or, right-clicking and selecting Reset > Table Categories (which returns the variable set to its original state).
NEXT
How to Hide Rows and Columns with Small Sample Sizes in a Table
How to Hide Empty Rows and Columns in a Table
How to Hide Rows Below a Specified Value
How to Hide Rows or Columns Based on Sample Size Using R