DATA Step, Macro, Functions and more

Proc freq

Reply
Super Contributor
Posts: 647

Proc freq

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
Super Contributor
Super Contributor
Posts: 3,174

Re: Proc freq

Did you consider the ORDER=FREQ parameter on the PROC FREQ statement?

Scott Barry
SBBWorks, Inc.
Ask a Question
Discussion stats
  • 1 reply
  • 109 views
  • 0 likes
  • 2 in conversation