Hello,
SPSS and I talk different language. However, I hope I will learn.
My challenge is control of workplace when the same person answers 2 or more workplaces. Workplaces A, B and C. or A, B and C and D etc.
In my analysis I need:
Workplace A AND/OR Workplace B = new variable AB. Workplace C AND/OR workplace D = new variable CD and E AND/OR F = new variabel, EF.
Therefore, I need to exclude the answers when someone has answer ex. A and D or B and F.
(Workplace A=1 | Workplace B= 1) Workplace AB=1.
(Workplace A = 1 | workplace B = 1 AND Workplace C=1 OR D =1 OR F =1) Workplace AB =0.
I have tried a lot of different way, with no success, they are still included.
In addition, if it is possible to do, I need transform one variable when the answers are mixed ex. A and E or B and C = new variable Mixed.
The goal is one new variable: Workplace
Transform AB, CD, EF and (if it is possible; a variable "mixed") to one new variable Workplace.
IF (Workplace AB= 1) Workplace =1.
IF (Workplace CD = 1) Workplace =2.
IF (Workplace EF= 1) Workplace =3.
IF (Workplace mixed=1) Workplace =4.
EXECUTE.
All advice is gratefully received.
Carina
------------------------------
Carina Ahlstedt
------------------------------
#SPSSStatistics