This tool automatically removes Don't Know categories from data that you select. Under the hood it sets the Value Attributes of the data to Exclude from analyses for all the don't know categories. This is also equivalent to right-clicking on all the Don't Know categories on a table and selecting Remove (in Q) or Delete (in Displayr).
Technical details
Phrases that are identified as Don't Know type responses are ones that contain one or more of:
- dk
- dont know
- don't know
- don t know
- unsure
- not sure
- do not know
- no idea
- not applicable
The matching of these is not case sensitive.
Additionally, where a label is, in its entirety, NA or na, it is treated as a Don't Know.
Method
This automation works slightly differently in Q and Displayr. Please see the relevant article below:
- Displayr: How to Remove Don't Know Categories
- Q: Automate > Browse Online Library > Modify Data > Remove Don't Know Categories