DATA Step, Macro, Functions and more

PROC REPORT ORDER OF ROWS

Reply
Frequent Contributor
Posts: 95

PROC REPORT ORDER OF ROWS

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;

 

 

Super Contributor
Posts: 498

Re: PROC REPORT ORDER OF ROWS

Please don't scream!

 

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

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