Sort on Centuary!!!!

ykishore · Active User Joined: 12 Aug 2005 Posts: 53 Location: USA

Hi

Here is my requirement!!

i've a file which has DATE column.but it doesnt have centuary part!!! here i want to sort the date on ascending order!!!!

for eg:

Input:
---------
0512
0510
9501
9201
9911

if i sort the above date col on ascending order, i do get the output as below!!!

output:
----------------
0501
0510
0512
9201
9501
9911

but when we consider year wise result may be wrong...so i want the output as below.

output:
--------
9201
9501
9911
0501
0510
0512

so can you guys provide me the JCL for the same!!! i know that we can do this by adding centuary part to the year.but is there anyother ways do it!!!!

radhakrishnan82 · Posted: Tue Sep 20, 2005 3:06 pm Post subject:

kishore,

Use this condition in sort

Frank Yaeger · Posted: Fri Sep 23, 2005 2:54 am Post subject:

Actually, since the input has yymm dates, the correct DFSORT statements would be: