topic Re: Output records to dataset based on timestamp and id variable in SAS Enterprise Guide

Output records to dataset based on timestamp and id variable

Sean_OConnor — Wed, 13 Feb 2019 16:34:54 GMT

Folks,

I have a dataset of transactions for people and I need to identify which ones are the latest. I have a timestamp variable which we can call time_stamp and I have an ID variable which we call ID.

Timestamp is numeric with larger values meaning its more recent to the system.

So I did to run some code that outputs the latest value for an individual when the timestamp is the largest for that id.

Could anyone supply and ideas please?

Re: Output records to dataset based on timestamp and id variable

Reeza — Wed, 13 Feb 2019 16:39:09 GMT

Sort ascending or descending and use FIRST or LAST respectively to get the first or last record for each ID.

proc sort data=have;
by ID time_stamp;
run;

data want;
set have;
by id time_stamp;
if last.id;
run;

Re: Output records to dataset based on timestamp and id variable

Reeza — Wed, 13 Feb 2019 16:39:25 GMT

Or use the MAX() function in SQL or PROC MEANS.