Summarize the table based on the primary Key id

[Ganeshk]

Hi,

I have the table as below:

ID	A	B	C	D	E	F
27	saf					dsdf
27
27		ddf		cdf	dfd

In the above table ID is the primary Key. I need to obtain summary based upon ID and obtained like below table:

ID	A	B	C	D	E	F
27	saf	ddf		cdf	dfd	dsdf

Please let me know your thought

Regards,

GK

[novinosrin · Accepted solution]

data want;
update have(obs=0) have;
by id;
run;