Sorting values in Proc Format

Pritish — Tue, 11 Jun 2013 17:31:35 GMT

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

Re: Sorting values in Proc Format

esjackso — Tue, 11 Jun 2013 17:59:37 GMT

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.

topic Re: Sorting values in Proc Format in SAS Procedures

Sorting values in Proc Format

Re: Sorting values in Proc Format