转置数据

把如下的数据形式

id	2001	2002	2003	2004	2005	2006
1
2
3
4
5
6

转换成类似

id	year	var
1	2001
1	2002
1	2003
1	2004
1	2005
1	2006
2	2001
2	2002
2	2003
2	2004
2	2005
2	2006
3	2001
3	2002
3	2003
3	2004
3	2005
3	2006

1. data a ;
   
2.     do id=1 to 5;
   
3.         array year[*] year1-year6;
   
4.         output;
   
5.     end;
   
6. run;
   
7. proc transpose data=a out=b(rename=(_name_=year col1=var));
   
8.     var year:;
   
9.     by id;
   
10. run;

复制代码

hope this wil help you

proc transpose data