作者wendy9506017 (wendy)
看板Statistics
標題[程式] sas欄位累加的問題 謝謝
時間Tue Dec 10 16:30:59 2013
------------------------------------------------------------------------
[軟體程式類別]:
sas
[程式問題]:
sas欄位累加的問題
[軟體熟悉度]:
低(1~3個月)
[問題敘述]:
各位高手您好，我是sas新手還請多多指教，謝謝
問敘述如下：
id pqi pai01 pqi02 pqi03
a1 1 1 . .
a1 1 1 . .
a1 1 1 . .
a1 2 . 1 .
a2 3 . . 1
a2 3 . . 1
id 是我的個案代碼
pqi 是個案住院的代碼共14種
pqi01 是因為代碼1而住院
pqi02 是因為代碼2而住院
ss1 是因代碼一住院幾次
我想要知道 每個id他的pqi01 pqi02 pqi03的次數
舉例來說，想知道a1他的資料呈現如下：
id ss1 ss2 ss3
a1 3 1 0
[程式範例]:
我所想出來的方程式如下：
proc sql;
create table b as
select pqi,id,sum(pqi01) as ss1 ,sum(pqi02) as ss2, sum(pqi03) as
ss3,sum(pqi05) as ss5,sum(pqi07) as ss7 ,sum(pqi08) as ss8, sum(pqi09) as ss9,sum(pqi10)
as ss10, sum(pqi11) as ss11 ,sum(pqi12) as ss12, sum(pqi13) as ss13,sum(pqi14) as
ss14, sum(pqi15) as ss15 ,sum(pqi16) as ss16, sum(pqi17) as ss17
from test3;
group by id;
order by id;
quit;
sas的系統出現錯誤如下：
40 group by id,dkey;
-----
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
41 order by id,dkey;
-----
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
謝謝各位高手 謝謝
-----------------------------------------------------------------------------
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.112.4.208
1F：推 imaltar:from test3 和group by id 後的分號拿掉 12/10 17:25
2F：→ wendy9506017:非常感謝!!!太厲害了，初次使用不太會用SQL 大感恩! 12/10 20:52