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

[Sofia2022]

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 

[PeterClemmensen]

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

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

[andreas_lds]

And what should happen if exactly 10 answers are correct?

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