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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.