作者yeu2 (咕噜咕噜～)
站内Statistics
标题[问题] [SAS] 关於data transpose
时间Tue Dec 16 00:29:34 2008
请问如果有一笔资料
subject class year score
A c1 year1 4
A c2 year2 2
A c1 year3 3
A c3 year3 2
我希望可以转置成如下：
subject class year1 year2 year3
A c1 4 . 3
A c2 . 2 .
A c3 . . 2
我是利用transpose 程序
proc transpose data=b1 out=transb(drop=_name_);
var score;
id year;
by subject class;
run;
当中因为class有相同的名称
所以我把class变成
subject class year score
A 1 year1 4
A 2 year2 2
A 3 year3 3
A 4 year3 2
可是output就会变成这样
subject class year1 year2 year3
A 1 4 . .
A 3 . . 3
A 2 . 2 .
A 4 . . 2
如何把相同名称的课程摆在同一列呢？
谢谢各位大大的帮忙，感激不尽orz
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 118.165.80.134
1F：推 kenshin528:proc sort ; by subjuct class;run; 12/16 00:38