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?
@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;
@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;
@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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.