I have the following data
JOBN1 JOBNO DATE-RAN TIME-RAN Condition-Code JOB123 123456 22Jul2020 1000 0 JOB123 123356 22Jul2020 0000 0 JOB123 120056 22Jul2020 0100 0 JOB123A 121156 22Jul2020 1300 0 JOB123B 122356 22Jul2020 0100 0 JOB123B 125656 22Jul2020 1325 0 JOB123C 120956 22Jul2020 1300 0 JOB123D 121756 22Jul2020 2300 0 I am not sure what would be the best way to get the following output I just want the job (plus details) from the last run. So if a job name runs 10 times, what is the very last time it ran JOB123 123456 22Jul2020 1000 0 JOB123B 125656 22Jul2020 1325 0 JOB123C 120956 22Jul2020 1300 0 JOB123D 121756 22Jul2020 2300 0 I can put it in an Excel and possibly use LAST or MIN/MAX functions I can probably code REXX to do this Maybe even DFSORT/ICETOOL Just not sure what would be the easiest. I will have several million entries where I just need the last time a specific job ran. Thanks ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN