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

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

Denali — Thu, 01 Dec 2022 09:35:19 GMT

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!

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

PeterClemmensen — Thu, 01 Dec 2022 09:44:14 GMT

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

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

ballardw — Fri, 02 Dec 2022 15:41:16 GMT

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.