求助频数排序问题

求助各位一个问题：

例如我有如下数据集：

data a;
input class1 $ class2 $ count @@;
cards;
A A 3
A a 1
A b 2
B B 7
B c 1
B d 2
B e 4
;
run;

class1是大分类，class2是class1的子分类，count是他们的计数。

我想这样分类：首先按照大分类的合计来排，那么B的四条观测排最上面，A的排最下面（当然分类不止两个）；然后B的小分类再继续排。。。

如果直接用proc sort，那么B的最后一条观测都会超过A。。。

换句话说：我就是想按照class1的合计观测来决定位置，然后再整个区块移动，不知有无办法？谢谢。

data a;
input class1 $ class2 $ count @@;
cards;
A A 3
A a 1
A b 2
B B 7
B c 1
B d 2
B e 4
;

proc means data=a order=freq nway noprint;
        class class1 class2;
        freq count;
        output out=hell(drop=_type_ rename=(_freq_=count));
run;
proc print data=hell;

1. proc sql;
   
2. create table b as
   
3.    select class1,sum(count)as number
   
4.     from a
   
5.          group by  class1;
   
6. quit;
   
7. data quan;
   
8. merge a b;
   
9. by class1;
   
10. run;
    
11. proc sort data=quan ;
    
12. by descending number;
    
13. run;

复制代码

最后去除number一列就行了

龙潭丰乐 发表于 2013-10-4 12:24
最后去除number一列就行了

很正统的处理方法，当大分类的count相同时，有可能会发生混乱，总之非常感谢！！

邓贵大 发表于 2013-10-2 22:38
data a;
input class1 $ class2 $ count @@;
cards;

Hi Deng,

I have meet some problem when use this part of code.

The dataset you can find in attachment are not correctly sorted by proc means.

Maybe I use wrong option or keep wrong observation.

The result show that :

The second observation by Class 1 (the first col) value 117 didn't list in the first place.

So ,please tell me.. Thank you :)

The code I use as this:

1. proc means data=out.a order=freq nway noprint;
   
2.         class AEBODSYS AEDECOD;
   
3.         freq count8;
   
4.         output out=b;
   
5. run;

复制代码

10/11 19:12

Maybe I find the problem.

When use proc means, the class class1 both include only class1's sum count and include class1's all sub-count.

So, N(class1) 96 + N(class2 sum) 91 > I(class1) 117 + I(class2 sum) 64

Tigflanker 发表于 2013-10-11 18:59
Hi Deng,

I have meet some problem when use this part of code.

Well, you data flawed, because the # of preferred terms do not add up to the total # given in the body class. In this case, you have to include two frequency variables in the data and PROC SORT it.

邓贵大 发表于 2013-10-11 20:32
Well, you data flawed, because the # of preferred terms do not add up to the total # given in the  ...

Thank you Deng, I will try this way.

1. 为什么不可以这样?结果和二楼一样
   
2. proc sort data=a;by descending class1 descending count;run;

复制代码

竟然不能回帖