[程式] SAS加總
------------------------------------------------------------------------
[軟體程式類別]:
SAS
[程式問題]:
資訊處理
[軟體熟悉度]:
新手(不到1個月)
[問題敘述]:
我要將同ID的人,QTY的數量做加總
[程式範例]:
ID QTY
1 00006.0 ID QTY
1 00006.0-->我做出來是 1 3
1 00004.0 2 2
2 00001.0
2 00003.0
我打的程式是
PROC SORT DATA=A;
BY ID QTY;
proc means data=A noprint;
BY id;
output out=C sum=sum_QTY;
RUN;
我想要的結果是:
ID QTY
1 16
2 4
該怎麼打指令呢?
謝謝^^
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 118.167.54.108
推
01/25 23:08, , 1F
01/25 23:08, 1F
推
01/25 23:44, , 2F
01/25 23:44, 2F
推
01/26 00:30, , 3F
01/26 00:30, 3F
→
01/26 21:33, , 4F
01/26 21:33, 4F
→
01/26 21:33, , 5F
01/26 21:33, 5F
→
01/26 21:34, , 6F
01/26 21:34, 6F
→
01/26 21:47, , 7F
01/26 21:47, 7F
推
01/26 22:22, , 8F
01/26 22:22, 8F
→
01/26 23:03, , 9F
01/26 23:03, 9F
→
01/26 23:37, , 10F
01/26 23:37, 10F
→
01/26 23:55, , 11F
01/26 23:55, 11F
討論串 (同標題文章)