Thank you! I forgot to ask the second part of the question. This is a longitudinal dataset that the same participants assessed across three time points. I attached the arrangement of the data that I used (SAV file). I really appreciate if you could provide a suggestion to remove individuals from the data set who have %75 or above missing data across three time points?       ... View more

Sorry. It worked!  I checked the results viewer section instead of the library. The percentage of missing values are available in the library. Thank you so much!   ... View more

Thank you. This code gave me whether the participant responded each question. However, I need to calculate how much percent missing values each participant have across three time points. And I need to exclude the participants who have %75 or above missing values across three waves. Is there something that I am missing?   data FINAL; set summary_stats; percent_missing=100*nmiss/sum(n,nmiss); run;   ... View more

I have 11 items that measured across three time points. I need to calculate missing percentages for each individual and remove individuals who have %75 of missing values. I used the following syntax but it gave me the item level missingness. I need to calculate missing percentages for these variables for each individual. Thanks! generate counts of N/NMISS; proc means data=FINAL stackods n nmiss NWAY; class ID; var EXP1_T1 EXP2_T1 EXP3_T1 EXP4_T1 EXP5_T1 INT1_T1 INT2_T1 INT3_T1R UTL1_T1 UTL2_T1 UTL3_T1 EXP1_T2 EXP2_T2 EXP3_T2 EXP4_T2 EXP5_T2 INT1_T2 INT2_T2 INT3_T2R UTL1_T2 UTL2_T2 UTL3_T2 EXP1_T3 EXP2_T3 EXP3_T3 EXP4_T3 EXP5_T3 INT1_T3 INT2_T3 INT3_T3R UTL1_T3 UTL2_T3 UTL3_T3; ods output summary=summary_stats; run; ... View more