SPSS Statistics

Expand all | Collapse all

Syntax for new variable where the value of variables 1 and 2 are within 3 units from variable 3

  • 1.  Syntax for new variable where the value of variables 1 and 2 are within 3 units from variable 3

    Posted Wed April 14, 2021 12:10 AM
    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
    ------------------------------


  • 2.  RE: Syntax for new variable where the value of variables 1 and 2 are within 3 units from variable 3

    Posted Wed April 14, 2021 08:46 AM
    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
    ------------------------------



  • 3.  RE: Syntax for new variable where the value of variables 1 and 2 are within 3 units from variable 3

    Posted Wed April 14, 2021 11:36 AM
    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
    ------------------------------