作者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