Unique identifier with multiple timestamps

[vnreddy]

Hi,

I have data something like below. single ID has multiple Dt_Submissions. I want to keep the latest Dt_Submitted.

Can someone please help me with this.

Thanks

vnreddy

[Kurt_Bremser · Accepted solution]

Do NOT post data in pictures. Use a self-contained data step that creates the dataset as you want it, so we can recreate your dataset for testing with a simple copy/paste and submit.

Sort by id and dt_submitted, then run

data want;
by id;
if last.id;
run;

[vnreddy]

Sure i will follow the instructions. Thanks for the solution.