topic Re: Merging by ID but not summing the counts in SAS Procedures

Merging by ID but not summing the counts

ssulli11 — Wed, 05 Dec 2018 00:34:25 GMT

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!

Re: Merging by ID but not summing the counts

Tom — Wed, 05 Dec 2018 00:53:46 GMT

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;

Re: Merging by ID but not summing the counts

ssulli11 — Wed, 05 Dec 2018 01:13:48 GMT

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?

Re: Merging by ID but not summing the counts

Tom — Wed, 05 Dec 2018 01:27:41 GMT

Keep which version of the other variables?

Re: Merging by ID but not summing the counts

learsaas — Wed, 05 Dec 2018 03:12:20 GMT

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