Hi James,

I confess that I don't really understand the spec for what you're trying to achieve; I added the 'complete_date = .' because it gave the right answer in your test case. You need to define exactly what you're trying to achieve, and then the required code will be obvious to you. It'll be more helpful for you to do this yourself than for me to do it for you.

A thought - do you want later suspensions to be compared to the due date *as adjusted for earlier suspensions*?? My code isn't currently doing that. If so, you'll need to maintain a running 'adjusted due_date', rather than a running 'total suspension', as my code is doing, and use that in the if statement.

Good luck,

Chris. -------------------------------------------------------- Elvis SAS Log Analyser - http://www.oview.co.uk/elvis --------------------------------------------------------

jamesgreen55@yahoo.ca wrote: > Hi Chris; (And thanks also to Jiann-Shiun Huang & Monal); > > Thanks for your help, somehow I knew I was overcomplicating this a > couple of questions tho... > > If I remove the statement "or complete_date = ." the code seems to > ignore the last Suspension in sample G. The date 03/11/2006 that your > sample shows is correct but lets say that the complete date is not > missing, the code changes the result to 02/20/2006 which means it is > not counting the last record of the case_num. > > I have tried moving things around with no success, it seems to not > process the "tot_susp = tot_susp + (susp_end - susp_start+ 1); " > statement when it is the last.case_num. > > Any ideas? > James