• Print |
• E-mail  |
• Bookmark

With the addition of the summary object in SAS 8, the order of pages in
PROC TABULATE output changed between SAS 6.12 and SAS 8. When ALL
appears first in a concatenated page dimension, the order of the pages
changes when compared with output from SAS 6.12.

The following example illustrates the behavior.

   proc tabulate data=sashelp.class;
    class sex age name;
    var height;
    table sex*(all age), name all, height;
    table (all sex)*(all age), name all, height;
   run;

The sort sequence for the first TABLE statement is

   sex .. name .. age

The sort sequence for the second TABLE statement is

   name .. age .. sex

A possible workaround is to combine the two TABLE statements into one as
follows.

   table sex*(all age) (all sex)*(all age), name all, height;


 A Technical Support hot fix for Release 8.2 (TS2M0) for this
issue is available at:

http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#011373

Operating System and Release Information

A fix for Release 8.2 (TS2M0) for this issue is available at: