topic How to select observations who answered more than once for a question in different waves? in SAS Programming

How to select observations who answered more than once for a question in different waves?

nwang5 — Thu, 23 Mar 2023 03:44:29 GMT

Hi All,

I hope this message finds you well. I was wondering if there is any way to select participants who answered the cesd question more than once. Thanks!

Tom — Thu, 23 Mar 2023 03:46:37 GMT

Assuming the variables are numeric you can use the N() function to see how many non-missing values there are.

data want;
  set have;
  if n(of cesd1-cesd5)<2 then delete;
run;

nwang5 — Thu, 23 Mar 2023 03:59:18 GMT

Thanks for your quick response! You are so nice. Thank you very much!