SAS OnlineTutor HomeFAQ PageSuggested Learning PathsContents+Searchback||next

Computing Frequency Distributions
Producing Frequency Tables


Specifying Frequency Order

By default, PROC FREQ displays frequency distributions in the order of each variable's unformatted values. This is known as internal order.

     proc freq data=clinic.diabetes;
        tables height;
     run;

Height Frequency Percent Cumulative
Frequency
Cumulative
Percent
61 2 10.00 2 10.00
62 1 5.00 3 15.00
63 1 5.00 4 20.00
64 3 15.00 7 35.00
65 2 10.00 9 45.00
66 2 10.00 11 55.00
68 2 10.00 13 65.00
70 2 10.00 15 75.00
71 2 10.00 17 85.00
72 1 5.00 18 90.00
73 1 5.00 19 95.00
75 1 5.00 20 100.00


You might prefer to view the values in a different order. To control the way that PROC FREQ displays distributions, add the ORDER= option to the PROC FREQ statement and specify the method you prefer.


General form, ORDER= option:
ORDER=DATA|FORMATTED|FREQ|INTERNAL

where

  • DATA orders values by appearance in the data set
  • FORMATTED orders by formatted value
  • FREQ orders values by descending frequency count
  • INTERNAL orders by unformatted value (default).
Note: The ORDER= option does not apply to missing values, which are always ordered first.


Example: ORDER=DATA

ORDER=DATA arranges variable values in the order they first occur in the input data.


SAS Data Set Clinic.Diabetes
ID Sex Age Height Weight Pulse FastGluc PostGluc
2304 F 16 61 102 100 568 625
1128 M 43 71 218 76 156 208
4425 F 48 66 162 80 244 322
1387 F 57 64 142 70 177 206
9012 F 39 63 157 68 257 318
6312 M 52 72 240 77 362 413
5438 F 42 62 168 83 247 304
3788 M 38 73 234 71 486 544
9125 F 56 64 159 70 166 215
3438 M 15 66 140 67 492 547
1274 F 50 65 153 70 193 271
3347 M 53 70 193 78 271 313
2486 F 63 65 157 70 152 224
1129 F 48 61 137 69 267 319
9723 M 52 75 219 65 348 403
8653 M 49 68 185 79 259 311
4451 M 54 71 196 81 373 431
3279 M 40 70 213 82 447 504
4759 F 60 68 164 71 155 215
6488 F 59 64 154 75 362 409


     proc freq data=clinic.diabetes order=data;
        tables height;
     run;

Height

Frequency

Percent

Cumulative
Frequency

Cumulative
Percent

61

2

10.00

2

10.00

71

2

10.00

4

20.00

66

2

10.00

6

30.00

64

3

15.00

9

45.00

63

1

5.00

10

50.00

72

1

5.00

11

55.00

62

1

5.00

12

60.00

73

1

5.00

13

65.00

65

2

10.00

15

75.00

70

2

10.00

17

85.00

75

1

5.00

18

90.00

68

2

10.00

20

100.00



  back||next


Copyright © 2002 SAS Institute Inc., Cary, NC, USA. All rights reserved.

Terms of Use & Legal Information | Privacy Statement