Merging by ID but not summing the counts

[ssulli11]

Good evening!

I am looking to merge by ID, but I do not want to sum each occurrence.  Instead-- no matter how many "1's" are present I only want to indicate it once.   I'm finding it difficult to explain so hopefully the below example is helpful.

Have:

ID	Visit ID	Fibro	DPN	Seiz	RLS	OD	OPABUSE	Chonic	MHD
5	15651	0	0	1	0	0	1	1	0
5	15670	0	0	0	0	0	0	1	1
5	16082	0	0	0	0	0	0	1	1
5	17082	0	0	0	0	0	0	1	1
5	18069	0	0	0	0	0	1	1	1
5	18071	0	0	0	0	0	1	1	1
5	19025	1	0	0	0	0	0	1	1
5	19126	0	0	0	0	0	0	1	1

Want:

ID	Visit ID	Fibro	DPN	Seiz	RLS	OD	OPABUSE	Chronic	MHD
5		1	0	1	0	0	1	1	1

As always, I'm extremely grateful to the community!!

Thanks!

[Tom · Accepted solution]

Your question doesn't match the subject line.  You do not appear to be doing any merging.

If your variables are coded 0 and 1 then you appear to want the max value.

proc summary nway data=have ;
  class id;
  var Fibro DPN Seiz RLS OD OPABUSE Chonic MHD ;
  output out=want max= ;
run;

[ssulli11]

Thank you for your quick reply!

Yup, I definitely was thinking through this all wrong.  

I actually have many more variables in my actual data set.  Is there an easy way to use the code provided and keep all the other variables?

[Tom]

Keep which version of the other variables?

[learsaas]

proc means data=have noprint nway;
	class id;
	output out=want(drop=_type_ _freq_) max=;
run;