topic Re: Transpose a row in SAS Data Management

Transpose a row

R_Chung — Tue, 15 Aug 2017 10:39:51 GMT

Background: I have one row record.

and the expexted result is as follow:

Is there ant methods to perform it efficiently in SAS DI?

As I have tried using transpose transformation and it just allows me to transpose one column to one output column each time, i.e, I need to perform the transformation 2 times to achieve the above results.

Re: Transpose a row

RW9 — Tue, 15 Aug 2017 11:16:03 GMT

Post test data in the form of a datastep in a code window (its the {i} above post area). At a guess:

data have;
  x1="a"; x2="b"; x3="c"; x4="d";
run;
data want (keep=want:);
  set have;
  array vals{4} x:;
  do i=1 to 4 by 2;
    want1=vals{i};
    want2=vals{i+1};
    output;
  end;
run;

Re: Transpose a row

Ksharp — Tue, 15 Aug 2017 13:11:13 GMT

I would try SAS/IML.
Would you like IML code ?

Re: Transpose a row

R_Chung — Wed, 16 Aug 2017 01:47:15 GMT

Sorry I am using sas di tools not sas code

Re: Transpose a row

dharmana01 — Tue, 15 Aug 2017 14:42:17 GMT

data want (drop = i);
do i = 1 to 2;
input name $ @;
input name1 $ @;
output;
end;
cards;
a b c d
;
run;