Qualtrics性别多选问题转SPSS单变量方法咨询

Got it, let's sort out this SPSS problem fast—since you accidentally set the gender question as multiple-choice in Qualtrics, you’ve ended up with three separate binary variables (each marking Male/Female/Other as 1 when selected) instead of a single categorical variable. Here are two simple, reliable ways to merge them into one variable where 1=Male, 2=Female, 3=Other:

Method 1: Use Compute Variable (Quick for clean data) #

• First, do a quick check of your dataset to confirm no respondents picked more than one gender option (since this was supposed to be a single-choice question). If there are any multi-selection cases, you’ll need to clean those first—either recode them as missing or follow up with those participants if your study allows.
• Navigate to Transform > Compute Variable in the SPSS menu.
• In the "Target Variable" field, name your new combined variable (e.g., gender_single).
• Paste this logic into the "Numeric Expression" box:

  IF(Male=1,1, IF(Female=1,2, IF(Other=1,3, $SYSMIS)))
  

  Make sure to replace Male, Female, Other with the exact variable names from your dataset.
• Hit OK—this will create a new variable where each case gets the correct gender code, and cases with no selection (or conflicting multi-selections) will be assigned a system missing value.

Method 2: Use Recode into Different Variables (Visual, easy to verify) #

• Go to Transform > Recode into Different Variables.
• Drag all three gender variables (Male, Female, Other) into the "Input Variables -> Output Variables" panel.
• For each input variable, map its selected value to the corresponding gender code:
  • Select Male, click Old and New Values:
    • Set Old Value to 1, New Value to 1
    • Click Add, then Continue
  • Select Female, click Old and New Values:
    • Set Old Value to 1, New Value to 2
    • Click Add, then Continue
  • Select Other, click Old and New Values:
    • Set Old Value to 1, New Value to 3
    • Click Add, then Continue
• Under the "Output Variable" section, name the new variable gender_single and click Change.
• Check the box for Treat blank values as user-missing to handle cases where no gender was selected.
• Click OK—SPSS will merge the three variables into one, with the codes you specified.

Pro Tips #

• Always save a backup of your original dataset before making any variable changes—you never want to lose your raw Qualtrics export!
• If you find multi-selection cases, think about your study’s goals before deciding how to handle them: marking them as missing is a safe default, but you could also categorize them separately if that makes sense for your analysis.

内容的提问来源于stack exchange，提问作者Kronenburger