Why not load the data into a DB and use SQL or similar language? If you have SAS - Max Min - functions
If you can load to EXCEL - use its functions Not all functions on the mainframe can do everything. You should look at what makes sense. And if the tool you are comfortable in using, does not have the function, I would say to find one that does. Hope that helps Lizette -----Original Message----- From: IBM Mainframe Discussion List <[email protected]> On Behalf Of Ron Thomas Sent: Friday, September 25, 2020 9:55 AM To: [email protected] Subject: DFSort to pull the latest record date Hello We are using DFSORT utility to extract the latest record for a store/item/po and below is the sample file item_nbr| Store_nbr|Po_nbr|item_date|mode| 000000604|9137|1100276393|2017-12-26|00007|DSD | 000000604|9137|1100278550|2018-01-09|00006|DSD | Here we need to pull the 2'nd record to the Output as this is the latest date . Could someone please let me know how to achieve the same Regards Ron T ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
