DATA Step, Macro, Functions and more

proc freq

Reply
Super Contributor
Posts: 673

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;


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
Ask a Question
Discussion stats
  • 0 replies
  • 93 views
  • 0 likes
  • 1 in conversation