In a survey I carried out, I asked people a multiple response question about impact.
The first 3 answers were types of impact; the 4th was "no impact".
I set these questions up as 4 dummy variables, with values of 0 or 1.
I have about 75 such questions about impact.
Some respondents said that there might be a type 1, 2, or 3 impact AND no impact. We want to find these people and change their "no impact" answer from 1 to 0.
I can do this on a question by question basis using Recode into same variables and an IF statement (do the recode if (impact1=1 OR impact2=1 OR impact3=1)).
But I want to do it using syntax, because I have so many to do...
Or perhaps by filtering out cases based on and IF statement?
Any clever ideas anyone?