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

[nwang5]

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!

ID	cesd1	cesd2	cesd3	cesd4	cesd5
1	.	0	.	1	2	keep
2	.	.	.	.	5	delete
3	1	.	.	.	.	delete
4	.	1	.	2	.	keep
5	0	2	1	2	4	keep

[Tom · Accepted solution]

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]

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