I am pretty new to writing codes and I am hoping that someone can help. I feel that I am just missing something simple, but I can not get my code to work properly.
I am trying to pull data from an oracle table (Connecting through SAS). It contains Person ID, Status, Start Time, End Time and Last Date/time Updated. The problem i am having is that for each person/day the data is loaded 7 times, there could be 50+ records per day and the start time or end time could change each time the data is updated. I need to pull all the records based on the last day updated and return person ID, status, start time, end time and update date.
Below is a sample of the data - I have put a space between where the LAST_LD_TS (Last Date/Time Updated) changes days. I would like to return just the last set (Last Date Updated regardless of time of that day).