I need to list the year in month order, not alphabetical order. Here is what I have but it does not order correctly. Any suggestions?

DEFINE FILE METRIC_DATA_HOURS
MO/A12=DECODE MONTH
(January January
February February
March March
April April
May May
June June
July July
August August
September September
October October
November November
December December );
END
TABLE FILE METRIC_DATA_HOURS
PRINT
DST.MO
BY MO
ON TABLE PCHOLD FORMAT XML
END


Thanks,
Denise

This message has been edited. Last edited by: DMA,

Hi Densie,

can you remove BY MO statement from the TABLE file METRIC_DATA_HOURS, because you are using BY MO it is sorting with alphabetical order.

try that once. It should work...

Regards,
Anmol

Anmol,

I have removed the BY MO statement and it still sorts alphabetically.

Thanks,
Denise

DEFINE FILE METRIC_DATA_HOURS
MO_SORT/A2=DECODE MONTH (
'January'   '01'
'February'  '02
'March'     '03'
'April'     '04'
'May'       '05'
'June'      '06' 
'July'      '07'
'August'    '08'
'September' '09'
'October'   '10'
'November'  '11'
'December'  '12' );
END
TABLE FILE METRIC_DATA_HOURS
SUM
  DST.MONTH
BY MO_SORT
ON TABLE PCHOLD FORMAT XML
END
 

Tom,

Thanks so much for your input, works perfectly.

Denise