Help using Base SAS procedures

Sorting values in Proc Format

Reply
Contributor
Posts: 65

Sorting values in Proc Format

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

Super Contributor
Posts: 334

Re: Sorting values in Proc Format

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

See if that helps.

EJ

Ask a Question
Discussion stats
  • 1 reply
  • 172 views
  • 0 likes
  • 2 in conversation