How to delete participants who did not complete more than 60% of the survey questions?

[Denali]

Hi All,

I have a dataset with 200 participants who filled out 5 questions. How do I delete those participants who had missing response in any 3 out of 5 questions?

Thank you!

[PeterClemmensen]

It depends highly on the structure of your data. Please provide some sample data in usable form and your expected result.

[ballardw · Accepted solution]

If each respondent's data is a single observation then something similar to this should work. You did not provide the names of any variables in your data set so I am using the dummy names Var1 through Var5 to represent the five variables you are requiring.

Assume that if 4 or 5 are missing that you want to remove them as well. If ONLY exactly 3 variable then use = or EQ in place of GE (greater than or equal). CMISS will accept character or numeric variables. You did not say which type your variables might be and other solutions may require more knowledge of your data.

data want;
   set have;
   if cmiss(var1, var2, var3, var4, var5) ge 3 then delete.
run;

IF your data is not a single observation per respondent then you need to provide examples of what your data may actually look like.