I will try this now. I assumed i would have to have it sorted by FileNo as i wanted to keep the last CreateDate for each FileNo. I will post the outcome, although i am sure it will now work if it was a simple error as advised. Thanks
... View more
I am trying to run the following code to keep only the last 'CreateDate' for each 'FileNo' however it is returning a blank dataset with the headers only. date Dates_1; set Dates; If Last.createdate then output; by FileNo; Run; Any assistance would be appreciated?? Thanks
... View more