Hi All

How to Customize SORT if my data is JAN,FEB,MAR,APR MAY......DEC .
If i am doing lowest sort data is displayed as below

APR
AUG
DEC
FEB
JAN
JUL
...
...
SEP

If i am doing HIGHEST sort data is displayed as below

SEP
OCT
NOV
MAY
MAR
JUN
JUL
JAN
FEB
DEC
AUG
APR

But I want to display as below

JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC

THANKS IN ADVANCE

There might be a better way to do this but how about creating a defined field, decoding JAN to 1, FEB to 2, MAR to 3, etc.

Then your defined field can be your primary BY field, with NOPRINT. Your months should then appear in order.

Cheers

Andrew W

Hi andrew

That i have done
thanks for reply

Sounds like your MONTH field is described as USAGE=A3 (alpha) instead of as an actual MONTH date field. If the field is three bytes long, then you can change your master file so that the USAGE is "MT" (Month Translate) and you will get exactly what you want without a DEFINE.

FIELD=MONFIELD, ALIAS=MF, USAGE=MT, ACTUAL=A3,$

See it this helps. You can do the following.

ACROSS FISCAL_MONTH AS ''
COLUMNS Oct AND Nov AND Dec AND Jan AND Feb AND Mar AND Apr AND May AND Jun AND Jul AND Aug AND Sep

The values of my FISCAL_MONTH are Jan, Feb, ...