Hoping someone can help. I am using SAS Enterprise Guide 4.3 - connecting into Oracle to pull back data. The information I am returning is personid Status, Start Time, End Time and Last Date Timestamp. Here is the problem - for the Last Date Timestamp, I am trying to determine a way to only return the records for the most recent timestamp. Below is the code that is running, but it has been running for over 3 hours. select * from connection to oracle ( select abc.person_id ,abc.status ,abc.start_time ,abc.end_time ,tmp.last_ld_ts From [my table name] abc ,(select max(to_number(to_char(last_ld_ts, 'YYYYMMDD'))) as max_last_ld_ts from [my table name]) tmp where abc.person_id = 5897 and to_number(to_char(abc.last_ld_ts, 'YYYYMMDD')) = tmp.max_last_ld_ts ); disconnect from oracle;
... View more