Tables and axes > More about axes > col statement > Dealing with “Don’t knows”
 
Dealing with “Don’t knows”
Quick reference
To create an element on a col statement that counts respondents present in the base but not in any other element since then, type:
col number; ... ; element_text=rej
More information
To deal with Don’t Knows on a col statement, use the =rej keyword:
col 121;Base;Inner London;Outer London;England Outside London;
+Scotland and Wales='45';Don't Know/Not Answered=rej
In this example, the row entitled ‘Don’t Know/Not Answered’ includes all respondents for whom c121 is blank or contains any code other than ‘1/5’. rej checks back to the previous Base or, if there is no base, to the beginning of the table.
If an axis contains two col statements, the first containing the word Base and the second containing the keyword rej but no base, the line with rej will contain anyone not already included by either statement.
See also
col statement