DATA Step, Macro, Functions and more

transpose

Reply
Contributor
Posts: 42

transpose

Hi,

 

I want to transpose the following sort of data into panel data by using proc transpose. Although I can do it by creating separate files for each variable e.g for AR2001-AR2006 and then a separate one for TR2001-TR2006 But I wish to do it in one go only as creating separate files for each variable is very time-consuming. Can someone share their knowledge on this?

IDAR2001AR2002AR2003AR2004AR2005AR2006TR2001TR2002TR2003TR2004TR2005TR2006and so on
1             
2             
3             
and so on

 

 

 

           
Super User
Posts: 6,537

Re: transpose

It's not 100% clear how you are picturing the panel data.  Here's one possible result:

 

data want;

set have;

array arvals {2001:2006} ar2001-ar2006;

array trvals {2001:2006} tr2001-tr2006;

do year=2001 to 2006;

  ar = arvals{year};

  tr = trvals{year};

  output;

end;

keep id year ar tr;

run;

Ask a Question
Discussion stats
  • 1 reply
  • 106 views
  • 2 likes
  • 2 in conversation