topic Re: Proc transpose in SAS Procedures

Proc transpose

exj — Fri, 23 Aug 2013 12:07:06 GMT

Hello,

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

Re: Proc transpose

Tom — Fri, 23 Aug 2013 12:23:52 GMT

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.

Re: Proc transpose

Murray_Court — Fri, 23 Aug 2013 12:24:07 GMT

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;

Re: Proc transpose

data_null__ — Fri, 23 Aug 2013 12:52:32 GMT

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.

Re: Proc transpose

exj — Mon, 26 Aug 2013 09:49:25 GMT

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!