Sorting values in Proc Format

[Pritish]

Hi,

Is there a way, I can sort formatted value created using Proc Format. So what I have right now is something like this:

Proc Format;

Value A

  0 - 100 = '0 to 100'

101-200 = '101 to 200'

;

run;

Proc Freq data = Dataset;

Tables VarA;

Format VarA A.;

run;

When I run Proc freq the way it outputs value is in this order:

0-100     102

101-200  205

Is there a way, I can reverse the order. So I have following output:

101-200  205

0-100     102

[esjackso]

Try sorting the dataset in descending order by varA (ie by descending varA;). Then run the freq with order = data option  (ie proc freq data= dataset order = data),

See if that helps.

EJ