topic Re: Selecting last entry in SAS Programming

Selecting last entry

Gil_ — Wed, 26 Sep 2018 22:29:42 GMT

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

Re: Selecting 1st entry

Gil_ — Wed, 26 Sep 2018 21:22:20 GMT

Sorry its last entry not 1st

Re: Selecting 1st entry

Astounding — Wed, 26 Sep 2018 21:31:44 GMT

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;

Re: Selecting last entry

Reeza — Wed, 26 Sep 2018 22:32:16 GMT

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&docsetVersion=9.4&locale=en

@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