How to transfer multiple rows to single row per id_record?

[Tom]

PROC TRANSPOSE will work.  You might need to run it twice however.

proc transpose data=have out=tall;
  by id event;
  var q1-q24;
run;
proc transpose data=tall out=want(drop=_name_);
  by id;
  id event _name_;
  var col1;
run;

Or you could leave the data as it is and just PRINT it that way using PROC REPORT.

proc report data=have;
   column id event,(q1-q4);
   define id / group;
   define event / across;
run;

[bhr-q]

Thank you for your answer, it was helpful.

[Kurt_Bremser]

I'd go one step further and make your initial dataset longer:

proc transpose data=have out=long name=quarter;
by record_id event notsorted;
var q:;
run;

proc report data=long;
column record_id event,quarter,col1;
define record_id / group;
define event / "" across;
define quarter / "" across;
define col1 / "" analysis;
run;

[bhr-q]

Thank you for your answer, it was helpful