I don't know if my question should be in this or beginner section, but anyway:
how could I recode some of the variable values, while keeping other old values?
My variable is numeric categorical, and I want to recode A variable values "5" to subcategories depending on variable B (also numeric categorical) - but if A has any other value than 5, I want to keep this value.
I.e. when A=5 (Party) and B= 3 (Green) --> A_NEW=100 (Party Green). Or: when A=3 --> A_NEW=3 (oldlabel). So whenever A has value 5 the new variable should combine with the equivalent value of B-variable (and Label to be Label A+label B, or just Label A). Whenever A has other than 5 as value, the newvariable would keep this old value.
I don't want to recode the old variable directly, in case of mistakes (although this would be the easiest - could I just copypaste all the cases in current order under new variable or is there a danger of Messing up data?)
As i have lots of different categories (200 in variable A and 50 in variable B), this would take forever by the Basic "compute" + "if" function I know...