我有6个年龄变量(agek1
..agek6
(,需要创建一个新变量,该变量包含所有这6个变量中最低年龄的值。因此,这个新变量agejk
应该只包含最小孩子的年龄。
年龄变量不按年龄排序,因为有时最年轻的年龄写在agek1
中,有时写在其他年龄变量中。年龄变量agek2
。。agek6
也包含缺失(999(,因为有些人只有一个孩子。
我在SPSS语法中尝试过不同的解决方案,但没有一个真正有效。以下是我在agek1
:中写下最年轻年龄时尝试的解决方案之一
Do iF (AgeK1 LT AgeK2) AND (AgeK3= 999) OR (AgeK4= 999) OR (AgeK5= 999) OR (AgeK6= 999) .
Recode Agejk (Else= copy) INTO AgeK1.
End if.
我也试过IF
-函数:
IF AgeK1 LT AgeK2 AND AgeK1 LT AgeK3 AND AgeK1 LT AgeK4 AND AgeK1 LT AgeK5 AND AgeK1 LT AgeK6
Agejk EQ AgeK1.
IF AgeK2 LT AgeK1 AND AgeK2 LT AgeK3 AND AgeK2 LT AgeK4 AND AgeK2 LT AgeK5 AND AgeK2 LT AgeK6
Agejk EQ AgeK2.
IF AgeK3 LT AgeK1 AND AgeK3 LT AgeK2 AND AgeK3 LT AgeK4 AND AgeK3 LT AgeK5 AND AgeK3 LT AgeK6
Agejk EQ AgeK3.
非常感谢你的帮助!
您需要的是min
函数:
compute Agejk = min(agek1 to agek6).
请注意,如果数据集中的年龄变量不连续,则需要以这种方式将其变白:
compute Agejk = min(agek1, agek2, agek3, agek4, agek5, agek6).