Re: [程式] 用SAS處理120萬筆資料取眾數
假設一下有多個id
data hosp;input id $ hosp_id $;
cards;
1 A
1 A
1 A
1 B
1 B
1 A
1 B
1 A
1 B
1 A
2 A
2 C
2 C
2 A
2 C
2 B
2 A
2 C
3 G
3 G
3 A
3 B
;
所以id=1 到醫院A有6次最多
id=2 到醫院C 4次最多
id=3 到醫院G 2次最多
proc sql;
create table out as
select a.*,b.max_count,b.hosp_id as most_hosp_id
from hosp a left join (select *
from (select *,count(*) as max_count
from hosp
group by id,hosp_id)
group by id
having max_count=max(max_count)) b
on a.id=b.id;
quit;
out就是最後要的data
參考看看
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 118.169.230.34
推
04/24 20:17, , 1F
04/24 20:17, 1F
→
04/24 20:18, , 2F
04/24 20:18, 2F
→
04/24 20:19, , 3F
04/24 20:19, 3F
→
04/24 20:19, , 4F
04/24 20:19, 4F
推
04/24 22:10, , 5F
04/24 22:10, 5F
推
04/24 22:35, , 6F
04/24 22:35, 6F
→
04/24 22:47, , 7F
04/24 22:47, 7F
推
04/24 22:56, , 8F
04/24 22:56, 8F
推
04/24 23:58, , 9F
04/24 23:58, 9F
推
04/25 08:21, , 10F
04/25 08:21, 10F
→
04/25 08:21, , 11F
04/25 08:21, 11F
推
04/26 00:06, , 12F
04/26 00:06, 12F
討論串 (同標題文章)
完整討論串 (本文為第 2 之 2 篇)：