Combine two variables into new variable with labels

#1
Hi,
I got two variables that I want to combine into a new variable with labels.

As an example two variables and their values:
colorCode colorName
2953 black&blue
5432 green&red

New variable
colorWithLabel
2953 (label:black&blue)
5432 (label:green&red)

If I run the syntax "AUTORECODE colorName INTO colorWithLabel", the values is converted to labels. But how do I assign the new values in the colorWithLabel variable with the corresponding colorCode value so that the label "black&blue" is associated with value "2953" etc.?


Regards
Frank
 

staassis

Active Member
#2
To change a value in the existing variable do

Transform -----> Recode Into Same Variables

To change a label in the existing variable without changing the corresponding value, go to Variable View, click on Label and update.