PROC REPORT ORDER OF ROWS

[Ronein]

HELLO

I am using proc report.

The problem is that in the output table (created from proc report) the order of the rows is not same order as in proc format.

I want to have same order or rows like in proc format:

'0'
'2--5'
6--7'
'8--10'
'11'
'12'

But the order of rows I get is:

'0'

'11'

'12'

'2--5'

'6--7'

'8--10'

Here is the code:

proc format;
value gkFMT
0='0'
2,3,4,5 ='2--5'
6,7 ='6--7'
8,9,10 ='8--10'
11='11'
12='12'
;
Run;

proc report data=aaa ;
column    groupk    MOD     ob_MLS ;
define groupk / group format=gkFMT.            order=formatted         'groupk' ;
define MOD / group 'Model' ;
define ob_MLS / analysis sum
format=comma10.
'Ob';
run;

[andreas_lds]

Please don't scream!

Have you tried using order=data instead of order=formatted?