Proc transpose

[exj]

Hello,

I want to do the following transformation, but I don't know how to do it. Can anyone help me with this problem?

[Tom · Accepted solution]

proc transpose data=have out=want name=variable ;

  by id time ;

  var x1 x2 ;

run;

You might want to add a proc sort if you want the data in the order in your example.

[Murray_Court]

Hi, solution below, I saw no need to transpose.

data x1set;

set mydata;

drop x2;

run;

data x2set;

set mydata;

drop x1;

run;

data newdata;

set x1set x2set;

run;

[data_null__]

But it's not what the OP wants.  Plus you don't need to crete x1set and x2set.  But you do need to rename and create VARIABLE.

[exj]

Thank you all for quick reply, Tom's suggestion works fine with small example and I think it will do well with proc sort and larger data aswell. Thanks!