Selecting last entry

[Gil_]

I have a table lokks like this
Id. Datetime
A2 0NOV05:03:49:19
A2. 0NOV05:02:49:19
A3. 0NOV05:06:49:19
A3. 0NOV05:08:49:19
What i need is to pull the last entry obo

Like this
Id. Datetime
A2 0NOV05:03:49:19
A3. 0NOV05:08:49:19

[Gil_]

Sorry its last entry not 1st

[Astounding · Accepted solution]

Both are relatively easy:

data want;

set have;

by id;

* To get last entry;

if last.id;

* To get first entry;

if first.id;

run;

[Reeza]

You should consider reviewing the BY group processing chapter in the documentation. It includes some good information on how FIRST/LAST work and the available options.

https://documentation.sas.com/?docsetId=lrcon&docsetTarget=n138da4gme3zb7n1nifpfhqv7clq.htm&docsetVe...

---

@Gil_ wrote:

I have a table lokks like this
Id. Datetime
A2 0NOV05:03:49:19
A2. 0NOV05:02:49:19
A3. 0NOV05:06:49:19
A3. 0NOV05:08:49:19
What i need is to pull the last entry obo

Like this
Id. Datetime
A2 0NOV05:03:49:19
A3. 0NOV05:08:49:19

---