topic Re: Generating a variable that indicate that person has missing data for more than two variables in SAS Procedures

Generating a variable that indicate that person has missing data for more than two variables

Sofia2022 — Mon, 08 Aug 2022 07:00:26 GMT

Hi all,

Students where requested to complete a survey but some students didn't answer all the questions (Question1 to Question12). The survey consist of 12 questions. I want to create a variable to flag ( variable name: complete) students that didn't answer three or more questions from the survey.

The questions that are not answered are coded as missing "."

The variable names for the questions are question1 = item1, question2= item2, question3= item3 etc.

For example,

if a student answered more than 10 questions then complete=1
If a student answered only 5 questions then complete = 0
If a student answered only 11 questions then complete = 1
If a student answered only 9 questions then complete = 0

Appreciate your assistance in writing up the sas code. Through array?

Thanks,

Sofia

Re: Generating a variable that indicate that person has missing data for more than two variables

PeterClemmensen — Mon, 08 Aug 2022 07:30:14 GMT

Obviously, this is untested, since I can't see your data

data want;
   set have;
   complete = (n(of item:) > 9);
run;

Re: Generating a variable that indicate that person has missing data for more than two variables

andreas_lds — Mon, 08 Aug 2022 09:25:46 GMT

And what should happen if exactly 10 answers are correct?

Posting data in usable form helps us to provide tested code.