This article describes how to go from a categorical table containing a 'Don't know' category:
To a table in which the 'Don't know' category is removed from the table and the remaining responses are rebased to the new total.
A data set containing one or more categorial variables which include a category labeled 'Don't know'.
1. You can select an individual table in your document, an entire page, a variable or an entire data set in your document. Any 'Don't know' categories within the selected object will be removed.
2. From the toolbar menu, select Anything > Data > Variables > Modify > Remove Categories > Remove Don't Know Categories.
3. If you've selected more than one variable (for example, a page with multiple tables or an entire data set), a notification will be displayed showing which variables were modified, which were the wrong type (not categorical) and which do not contain a 'Don't know' option/category. Click OK.
- To restore a 'Don't know' category, select the variable from the Data Sets tree and then from the object inspector on the right, click the Missing values button and change the 'Don't know' category to 'Include in analyses' in the Missing Values column.