How to Change the Label of a Category of a Question

From Market Research
Jump to: navigation, search

The following table, from SPSS, shows a quite common problem, where numbers appear instead of descriptions for some of the categories in the table. The key challenge that this usually presents is working out what the numbers really mean; there is usually no way of working this out directly from the data (i.e., you need to ask whoever created the data file). Once this is known it is usually quite straightforward to fix the problem.

BadLabelSPSSFrequency.PNG

SPSS In the Variable View find the variable that corresponds to the question you are looking at, click on its Values, press the ... button, enter the value without a label into the Value field, enter the label in the Label field, press Add and press OK.
Q Right-click on the category and select Rename.
R levels(variableName)[index] = 'New label' where index is the position of the category in the table (e.g., if it is in the fourth row of the table, a 4 is the index).
DataCracker Click on the category and select Data Manipulation > Rows/Columns > Rename.


See also

Personal tools
Namespaces

Variants
Actions
Navigation
Categories
Toolbox