Page 1 of 1

Sorting using DFSORT

Posted: Fri May 11, 2012 9:25 am
by siv_san
I have a requirement to sort the data which is in decimal and take a maximum value in that.

Example:

3045.45666
3.45655
324.554547
3334.4455
3333.44578
3214.224574
4578.1124578

Now, how do I sort this? I have tried different ways using DFSORT but didn't get the expected result. Any help would be appreciated

Posted: Fri May 11, 2012 10:47 am
by NicC
why not try posting in the DFSort part of the forum? What ways have you tried? Have you tried SFF for example?

Posted: Fri May 11, 2012 10:42 pm
by Frank Yaeger
San,

You haven't given a clear enough explanation of your requirement for anyone to help you.

You show values with different numbers of decimal places ranging from 4 to 7. These must be "normalized" to be sorted. But you haven't told us the minimum or maximum number of decimal places your values can have (is it min=4 and max=7 or something else?).

You also haven't told us the maximum length of your values (the maximum length you show is 12 - is that the actual max?).

You don't need to SORT to get the maximum value. Do you need to SORT anyway (to get the values in sorted order)? What exactly do you want your output to look like?

You need to do a better job of explaining your requirement before anyone can help you.

Posted: Tue May 15, 2012 8:58 am
by siv_san
Hi Frank,

Thanks for your response and I am sorry as my explanation is not very clear.

The max length of my value is 12 and the no of decimal values which I want is 4. My requirement is I want to take the max. no from the list of values which I mentioned above.
Hope it is clear now!!!