Help using Base SAS procedures

Proc transpose

Accepted Solution Solved
Reply
Contributor exj
Contributor
Posts: 20
Accepted Solution

Proc transpose

Hello,

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

transpose.jpg


Accepted Solutions
Solution
‎08-23-2013 08:23 AM
Super User
Super User
Posts: 7,050

Re: Proc transpose

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.

View solution in original post


All Replies
Solution
‎08-23-2013 08:23 AM
Super User
Super User
Posts: 7,050

Re: Proc transpose

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.

Contributor
Posts: 45

Re: Proc transpose

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;

Respected Advisor
Posts: 3,799

Re: Proc transpose

Posted in reply to Murray_Court

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.

Contributor exj
Contributor
Posts: 20

Re: Proc transpose

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!

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 261 views
  • 3 likes
  • 4 in conversation