How to merge multiple observations into one row

LarissaW — Tue, 13 Jun 2023 03:22:23 GMT

This is my current dataset

I want a dataset like below

Re: How to merge multiple observations into one row

Tom — Tue, 13 Jun 2023 03:41:42 GMT

What is the RULE that allows that transformation?

Is it:

Take the maximum value?

proc summary data=have;
  by pid;
  var _numeric_;
  output out=want max= ;
run;

Or perhaps:

Take the total value?

proc summary data=have;
  by pid;
  var _numeric_;
  output out=want sum= ;
run;