Thank you very much for the suggestion, and please accept my apologies for not being clear enough in the original post!
What I want to achieve is the following.
The values in the new variable, var4, should be either 0 or 1 based on the following conditions:
1. The value of var1 (scale 1 to 10) should be equal to or greater than 6
2. The value of var2 (scale 1 to 10 ) should either be equal to or 1,2 or 3 numbers less than or greater than the value of var1
3. The value of var3 (scale 1 to 10 ) should either be equal to or 1,2 or 3 numbers less han or greater than the value of var1
All cases that meet alle three conditions gets value 1, else value 0 in the new var4.
All the best,
Lars
------------------------------
Lars Olsen
------------------------------
Original Message:
Sent: Wed April 14, 2021 08:45 AM
From: Rick Marcantonio
Subject: Syntax for new variable where the value of variables 1 and 2 are within 3 units from variable 3
If I understood correctly, I think this should do it.
data list free /v1 to v3.
begin data.
1 10 5
6 5 8
7 8 5
6 2 6
6 3 9
end data.
compute v4= (v1 ge 6) & (abs(v2-v1) le 3) & (abs(v3-v1) le 3).
list.
------------------------------
Rick Marcantonio
Quality Assurance
IBM
Original Message:
Sent: Tue April 13, 2021 01:11 PM
From: Lars Olsen
Subject: Syntax for new variable where the value of variables 1 and 2 are within 3 units from variable 3
Hello
I have three scale variables with values ranging from 1-10 (whole numbers only).
I would like to create a new variable based on the following conditions:
1. The value of variable 1 should be 6 or higher,
2. The value of variable 2 and variable3 should be maximum three numbers higher than or lower than the value of variable 1.
Any help would be greatly appreciated!
Lars Olsen
------------------------------
Lars Olsen
------------------------------
#SPSSStatistics