Recode - Set Value of Don't Knows to NaN

From Q
Jump to navigation Jump to search

This tool sets the value of any Don't Know categories in Pick One, Pick One - Multi, Number, and Number - Multi questionsNominal/Ordinal, Nominal/Ordinal - Multi, Numeric, and Numeric - Multi variable sets to NaN.

You will be notified to check any recoded data that was identified as having two or more Don't Know style options.

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.


To use this tool in Q:

  1. Select Automate > Browse Online Library > Recode > Set Value of Don't Knows to NaN
  2. Choose whether you wish to add your own custom text to search for in addition to the standard Don't Know style responses listed above
  3. Choose which questions you wish to modify from the list presented

To use this tool in Displayr:

  1. Select a table whose rows contain the variable set you wish to modify, or select one or more variable sets under Data Sets.
  2. Select + Anything > Data > Variables > Modify > Recode > Set Value of Don't Knows to NaN
includeWeb('QScript Functions for Removing Dont Know Categories'); 

See also