topic Unique identifier with multiple timestamps in SAS Programming

Unique identifier with multiple timestamps

vnreddy — Wed, 24 Jun 2020 10:03:19 GMT

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

Re: Unique identifier with multiple timestamps

Kurt_Bremser — Wed, 24 Jun 2020 10:18:41 GMT

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;

Re: Unique identifier with multiple timestamps

vnreddy — Wed, 24 Jun 2020 15:47:52 GMT

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