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;
Please don't scream!
Have you tried using order=data instead of order=formatted?
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.