标题: 如何算频率的频率? [打印本页] 作者: shiyiming 时间: 2009-12-30 11:29 标题: 如何算频率的频率? 有data如下:
data a;
input group $ x@@;
cards;
a 12 a 77
a 12 a 0
b 90 b 10
b 2 b 0
b 21 c 61
c 9 d 12
e 12 e 8
f 19 g 12
;
run;
要求一步(一个data step, or proc sql)之内算出group出现的频率(freq),及该频率出现的次数(count).
比如:
freq count
1 3 (如d,f,g)
2 2 (如c,e)
4 1 (如a)
5 1 (如b)作者: shiyiming 时间: 2009-12-30 11:45 标题: Re: 如何算频率的频率? What about this my friend?
[code:9o77n1g9]data a;
input group $ x@@;
cards;
a 12 a 77
a 12 a 0
b 90 b 10
b 2 b 0
b 21 c 61
c 9 d 12
e 12 e 8
f 19 g 12
;
run;
proc sql;
create table results as
select count as freq,
count(*) as count
from (select group,
count(*) as count
from a
group by group
)
group by count;
quit;
[/code:9o77n1g9]