topic transpose in SAS Programming

transpose

Amalik — Fri, 02 Feb 2018 02:40:31 GMT

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?

AR2001

AR2002

AR2003

AR2004

AR2005

AR2006

TR2001

TR2002

TR2003

TR2004

TR2005

TR2006

and so on

Re: transpose

Astounding — Fri, 02 Feb 2018 03:01:48 GMT

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;