topic proc tabulate sorting one class descending and the other ascending in SAS Programming

proc tabulate sorting one class descending and the other ascending

csetzkorn — Thu, 15 Feb 2018 12:49:12 GMT

It is possible to sort all classes descending:

PROC TABULATE DATA=AnalysisData;
   CLASS Y X /descending;
   TABLE Y, X * N;
RUN;

Is it also possible to sort one class descending and the other ascending?

Re: proc tabulate sorting one class descending and the other ascending

Cynthia_sas — Thu, 15 Feb 2018 13:52:30 GMT

Hi, your message titles asks for one thing (one class variable descending and the other ascending) and your message itself asks for something different (all classes descending). Which do you want? And do you have any data to post? What is all your code, including any ODS statements.
cynthia

Re: proc tabulate sorting one class descending and the other ascending

csetzkorn — Thu, 15 Feb 2018 14:40:54 GMT

sorry I do not think so - if you read it again (-: I provided an example to show you that I did my homework, which shows sorting all classes but my requirement is to sort them asc and desc

Re: proc tabulate sorting one class descending and the other ascending

ballardw — Thu, 15 Feb 2018 15:44:21 GMT

@csetzkorn wrote:

It is possible to sort all classes descending:
PROC TABULATE DATA=AnalysisData;
   CLASS Y X /descending;
   TABLE Y, X * N;
RUN;
Is it also possible to sort one class descending and the other ascending?

Yes but you would use multiple class statements.

Class y /descending;

class x /ascending;

And other orders could be used with the ORDER= option. Again a separate class statement would be used for different values of the option.

class z/ order=freq;

Re: proc tabulate sorting one class descending and the other ascending

Cynthia_sas — Thu, 15 Feb 2018 16:13:01 GMT

Hi, sorry, somehow I missed the sentence under the slide.
You only need to use 2 CLASS statements, as @ballardw shows.
cynthia

Re: proc tabulate sorting one class descending and the other ascending

csetzkorn — Thu, 15 Feb 2018 16:30:26 GMT

Amazing did not know you can have separate class statements!

Re: proc tabulate sorting one class descending and the other ascending

ballardw — Thu, 15 Feb 2018 17:34:45 GMT

@csetzkorn wrote:
Amazing did not know you can have separate class statements!

The you likely will find that you can also have multiple table, classlev and var statements helpful as well.