topic Transpose Values by Unique ID in SAS Programming

Transpose Values by Unique ID

cobba — Tue, 07 Dec 2021 23:27:29 GMT

I have the following data. A table of events that can contain any number of codes.

data have;
    input id$ code$ @@;
    datalines;
    aa x1 aa x1 aa x2
    bb x1 bb y1 bb y1 bb z2 bb z4
    cc x1 cc x2 cc y1 cc x1 cc x1 cc q1
    dd z2 dd z2 dd z2 dd q1
    ;
run;

I want to transpose the data so the codes associated with each event is stored in the same row.

Re: Transpose Values by Unique ID

ballardw — Wed, 08 Dec 2021 09:09:11 GMT

This seems to work for your example:

proc transpose data=have out=want(drop=name)
  prefix=code;
  by id;
  var code;
run;

@cobba wrote:

I have the following data. A table of events that can contain any number of codes.
data have;
    input id$ code$ @@;
    datalines;
    aa x1 aa x1 aa x2
    bb x1 bb y1 bb y1 bb z2 bb z4
    cc x1 cc x2 cc y1 cc x1 cc x1 cc q1
    dd z2 dd z2 dd z2 dd q1
    ;
run;
I want to transpose the data so the codes associated with each event is stored in the same row.

Re: Transpose Values by Unique ID

cobba — Tue, 07 Dec 2021 23:59:34 GMT

I got it to work by moving the prefix up.

proc transpose data=have out=want (drop=name) prefix=code;
  by id;
  var code;
run;

Thanks.