1. Forum
  2. Usenet
  3. COMP.SOFT-SYS.STAT.SPSS

  • Re: How to Combine Two or More Categorical Variables into One in SPSS

    From Matheka Matheka@21:1/5 to southernpsy on Wed Feb 16 03:08:33 2022
    On Friday, May 29, 2009 at 9:08:48 PM UTC+3, southernpsy wrote:
    I am an SPSS novice, and I found this group recently when I was trying
    to determine how to combine two categorical into one variable in SPSS.
    I did not find an answer online, but I did eventually figure out how
    to do it. I decided to post it here to the benefit of others.
    I had one variable for Sex (1: Male; 2: Female) and one variable for Self-Identified Gender Expression (1: Masculine; 2: Equally or Neither Masculine Nor Feminine; 3: Feminine). I wanted to be able to compare Masculine Males, et cetera in post hoc analyses.
    Here is a template of the syntax that worked for me:
    IF ((var1 = 1) & (var2 = 1)) newvar= 1.
    EXECUTE.
    IF ((var1 = 1) & (var2 = 2)) newvar= 2.
    EXECUTE.
    IF ((var1 = 1) & (var2 = 3)) newvar= 3.
    EXECUTE.
    IF ((var1 = 2) & (var2 = 1)) newvar= 4.
    EXECUTE.
    IF ((var1 = 2) & (var2 = 2)) newvar= 5.
    EXECUTE.
    IF ((var1 = 2) & (var2 = 3)) newvar= 6.
    EXECUTE.
    this was really helpful

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Rich Ulrich@21:1/5 to hmueni@gmail.com on Thu Feb 17 12:45:53 2022
    On Wed, 16 Feb 2022 03:08:33 -0800 (PST), Matheka Matheka
    <hmueni@gmail.com> wrote:

    On Friday, May 29, 2009 at 9:08:48 PM UTC+3, southernpsy wrote:
    I am an SPSS novice, and I found this group recently when I was trying
    to determine how to combine two categorical into one variable in SPSS.
    I did not find an answer online, but I did eventually figure out how
    to do it. I decided to post it here to the benefit of others.
    I had one variable for Sex (1: Male; 2: Female) and one variable for
    Self-Identified Gender Expression (1: Masculine; 2: Equally or Neither
    Masculine Nor Feminine; 3: Feminine). I wanted to be able to compare
    Masculine Males, et cetera in post hoc analyses.
    Here is a template of the syntax that worked for me:
    IF ((var1 = 1) & (var2 = 1)) newvar= 1.
    EXECUTE.
    IF ((var1 = 1) & (var2 = 2)) newvar= 2.
    EXECUTE.
    IF ((var1 = 1) & (var2 = 3)) newvar= 3.
    EXECUTE.
    IF ((var1 = 2) & (var2 = 1)) newvar= 4.
    EXECUTE.
    IF ((var1 = 2) & (var2 = 2)) newvar= 5.
    EXECUTE.
    IF ((var1 = 2) & (var2 = 3)) newvar= 6.
    EXECUTE.
    this was really helpful


    The original thread (2009) includes neater solutions -- easier to
    read and faster in running. I googled for it.
    * all those EXECUTEs are a waste.
    * DO IF/ ELSE
    * direct computation
    See

    https://groups.google.com/g/comp.soft-sys.stat.spss/c/fD_5jV3kkII

    --
    Rich Ulrich

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)