如何统计人头和事件

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

id	kind	grade	event
101_10000	b	1	GLOBULINS DECREASED
101_10000	b	1	HYPERTRIGLYCERIDAEMIA
101_10000	b	1	LEUKOCYTOSIS
101_11100	b	1	BLOOD CREATINE PHOSPHOKINASE INCREASED
101_11100	b	3	GLOBULINS DECREASED
101_11100	b	1	HYPERTRIGLYCERIDAEMIA
101_11100	b	1	HYPOPHOSPHATAEMIA
101_11100	b	1	HYPOAESTHESIA ORAL
101_11100	b	4	PROTEIN TOTAL DECREASED
101_11100	b	1	XANTHELASMA
101_13700	a	1	ALANINE AMINOTRANSFERASE INCREASED
101_13700	a	1	ALANINE AMINOTRANSFERASE INCREASED
101_13700	a	3	ANAEMIA
101_13700	a	1	ASPARTATE AMINOTRANSFERASE INCREASED
101_13700	a	1	ASPARTATE AMINOTRANSFERASE INCREASED
101_13700	a	4	BLOOD CHOLESTEROL INCREASED
101_13700	a	1	MUSCLE SPASMS
101_13700	a	1	OEDEMA PERIPHERAL
101_13700	a	1	OEDEMA PERIPHERAL
101_13700	a	1	PAIN IN EXTREMITY
101_13700	a	1	FOLLICULITIS
101_13700	a	2	FOLLICULITIS
101_13700	a	1	FOLLICULITIS
101_13700	a	1	GAMMA-GLUTAMYLTRANSFERASE INCREASED
101_13700	a	1	GLYCOSYLATED HAEMOGLOBIN INCREASED
101_13700	a	1	HYPERCHOLESTEROLAEMIA
101_13700	a	1	HYPERGLYCAEMIA

是这样的，现在需要统计按四个grade的两组kind的id人头数和event事件数

kind	grade	人数	事件数
a	1
a	2
a	3
a	4
b	1
b	2
b	3
b	4

不过有条最关键的规则就是：不论人头数还是事件数，只计算最高等级的，也就是说像‘101_11100’这个人经历过grade4这个等级，那么久不再计入grade1~grade3这三个等级，虽然“101_11100”这个人也经历过前面的三个等级！

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：peripheral Increased Increase transfer decrease 如何 统计

proc sql;
create table maxgrade as
select * from test
group by id, kind
having grade=max(grade);

create table count as
select kind, grade, count(distinct id) as num_id, count(distinct event) as num_event
from maxgrade
group by 1,2
order by 1,2;

create table allclass as
select * from
(select distinct kind from test),(select distinct grade from test)
order by kind, grade;
quit;

data wanted;
merge count allclass;
by kind grade;
if num_id=. then num_id=0;
if num_event=. then num_event=0;
run;