topic Re: Transpose a datasets in SAS Programming

Transpose a datasets

di_niu0 — Tue, 30 Nov 2021 18:23:45 GMT

Hi All,

How to transpose table 1 into table 2? Thanks!

TABLE 1

Client StartDate EndDate OrderID1 OrderID2 OrderID3

1 01JAN 31JAN 1 . .

1 01FEB 29FEB 1 2 .

2 01MAR 31MAR 1 2 3

TABLE 2

Client StartDate EndDate OrderID

1 01JAN 31JAN 1

1 01FEB 29FEB 1

1 01FEB 29FEB 2

2 01MAR 31MAR 1

2 01MAR 31MAR 2

2 01MAR 31MAR 3

Kurt_Bremser — Tue, 30 Nov 2021 18:53:56 GMT

proc transpose
  data=have
  out=want (
    drop=_name_
    rename=(col1=orderid)
  )
;
by client startdate enddate;
var orderid:;
run;

di_niu0 — Tue, 30 Nov 2021 19:11:14 GMT

Thanks!!