PROC REPORT ORDER OF ROWS

Ronein — Wed, 28 Feb 2018 06:56:06 GMT

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;

Re: PROC REPORT ORDER OF ROWS

andreas_lds — Wed, 28 Feb 2018 08:13:03 GMT

Please don't scream!

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

topic PROC REPORT ORDER OF ROWS in SAS Programming

PROC REPORT ORDER OF ROWS

Re: PROC REPORT ORDER OF ROWS