I am trying to build a filter variable in SPSS that is conditional on specific selected responses - however I am a beginner in using using this function.
I created an expression:
((QID1 =1) AND (QID2 = 1) AND (QID3 = 1) OR (QID3 = 2))
which is not successful
Variable 1 must = 1
Variable 2 must = 1
Variable 3 must = 1 or 2
Welcome any assistance or alternative method.
Actually it looks like this worked fine - it added the variable at the end of column and crossed out case numbers not included
((QID1 =1) AND (QID2 = 1) AND ((QID3 = 1) OR (QID3 = 2)))
QID3 = 1 OR QID3 = 2 has to be evaluated first, and then the rest. Logical operators have the same precedence so there is no guarantee that OR is first evaluated before AND.
If we evaluate following with both filters; R1 is result of filter Marc White has provided. The second is mine
please see the screen shots.
I have included the SPSS file as well.
Hi Marc White , through the syntax function on SPSS you should be able to code this quite easily using the following code:
COMPUTE QUIDSTATUS1=0.
IF (QUID1 = 1) QUIDSTATUS1=1.
COMPUTE QUIDSTATUS2=0.
IF (QUID2 = 1) QUIDSTATUS2=1.
COMPUTE QUIDSTATUS3=0.
IF ((QUID3 = 1) OR (QUID3 = 2)) QUIDSTATUS3=1OR2.
EXECUTE.
This will produce 3 new variables:
QUIDSTATUS1 where QUID1 = 1.
QUIDSTATUS2 where QUID2 = 2.
QUIDSTATUS3 where QUID3 = 1 or 2.
Alternatively you could get all of these into 1 column through the following code:
COMPUTE QUIDSTATUS=0.
IF (QUID1 = 1) QUIDSTATUS=1.
IF (QUID2 = 1) QUIDSTATUS=1.
IF ((QUID3 = 1) OR (QUID3 = 2)) QUIDSTATUS=1OR2.
EXECUTE.
This will produce 1 column labelled QUIDSTATUS where QUID1 and QUID2 are combined into the value 1 and QUID3 is labelled 1or2.
I hope this helps, let me know if you have any problems. Syntax can be opened by getting to the end of any function and pressing paste rather than ok.
Matt
- Badges
- Science topic
- Similar topics
- Mathematical Sciences
- Statistics
- Statistical Software
- SPSS