BookmarkSubscribeRSS Feed
SASPhile
Quartz | Level 8
proc freq by default displays crosstab in ascending order as shown below. Is it possible to have the crosstab display in descending order? I need to have the tabs display 5 to 1 . Thanks!

proc freq data=star ;
tables A1_1*A1_2 / nopercent nocol norow;
run;.


The FREQ Procedure

Table of A1_1 by A1_2

A1_1(A1_1) A1_2(A1_2)

Frequency 2 3 4 5 Total
______________________________________________________
2 13 17 0 0 30
______________________________________________________
3 21 190 13 0 224
_____________________________________________________
4 6 80 54 11 151
______________________________________________________
5 0 52 54 122 228
______________________________________________________
Total 40 339 121 133 633

Frequency Missing = 5
1 REPLY 1
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
Did you consider the ORDER=FREQ parameter on the PROC FREQ statement?

Scott Barry
SBBWorks, Inc.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 972 views
  • 0 likes
  • 2 in conversation