SAS:PROC TABULATE 重新排列标题子组 [英] SAS: PROC TABULATE Rearrange Header Subgroups

问题描述

问题:如何控制 PROC TABULATE 输出中子组的顺序?

Question: How do I control the order of subgroups in the output of PROC TABULATE?

例如，假设我有这个输出，即 segment 中的 (A, B):

For instance, suppose I have this output, namely (A, B) within segment:

data example;
    input group $ segment $;
    datalines;
    1 A
    1 B
    2 A
    2 A
    3 B
    3 B
    ;
run;

proc tabulate data = example;
    class group segment;
    table group all, all = 'Total'*n segment*n;
run;

+-----------------------+------------+-------------------------+
+                       +            +         segment         +
+                       +            +------------+------------+
+                       +   Total    +     A      +     B      +
+                       +------------+------------+------------+
+                       +     N      +     N      +     N      +
+-----------------------+------------+------------+------------+
+    group              +            +            +            +
+-----------------------+            +            +            +
+    1                  +     2.00   +     1.00   +     1.00   +
+-----------------------+------------+------------+------------+
+    2                  +     2.00   +     2.00   +        .   +
+-----------------------+------------+------------+------------+
+    3                  +     2.00   +        .   +     2.00   +
+-----------------------+------------+------------+------------+
+    All                +     6.00   +     3.00   +     3.00   +
+-----------------------+------------+------------+------------+

我如何重新排列 segment 的子组以相反的顺序出现，(B, A)?

How would I reorder the subgroups of segment to appear in the opposite order, (B, A)?

+-----------------------+------------+-------------------------+
+                       +            +         segment         +
+                       +            +------------+------------+
+                       +   Total    +     B      +     A      +
+                       +------------+------------+------------+
+                       +     N      +     N      +     N      +
+-----------------------+------------+------------+------------+
+    group              +            +            +            +
+-----------------------+            +            +            +
+    1                  +     2.00   +     1.00   +     1.00   +
+-----------------------+------------+------------+------------+
+    2                  +     2.00   +        .   +     2.00   +
+-----------------------+------------+------------+------------+
+    3                  +     2.00   +     2.00   +        .   +
+-----------------------+------------+------------+------------+
+    All                +     6.00   +     3.00   +     3.00   +
+-----------------------+------------+------------+------------+

似乎可以选择使用 DESC 或 DESCENDING= 对子组进行排序，但这两种方法都不适合我.我的部分问题可能是我使用的术语.我不认为A"和B"在 SAS 词典中被称为子组.

It seems like there may be an option to order subgroups using DESC or DESCENDING=, but neither of those work for me. Part of my problem may be the terminology I'm using. I don't think "A" and "B" are called subgroups within the SAS lexicon.

推荐答案

如果你先对数据进行排序，然后再使用 order=data 你应该能够得到你需要的:

If you sort the data first and then user order=data you should be able to get what you need:

proc sort data=example;
 by group descending segment;
run;

proc tabulate data = example order=data;
    class group segment;
    table group all, all = 'Total'*n segment*n;
run;

这篇关于SAS:PROC TABULATE 重新排列标题子组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！