DATA Step, Macro, Functions and more

HOW TO EXTRACT LATEST DATE

Accepted Solution Solved
Reply
Contributor
Posts: 70
Accepted Solution

HOW TO EXTRACT LATEST DATE

Dear Expert,

 

I want to extract the  latest date from the date time stamp values.

here is the sample code.

 

data HAVE;

input ID$ dt;

informat dt datetime.;

format dt datetime.;

cards;

 A  21MAY2018:09:27:00

A  21MAY2018:09:29:00

B  21MAY2018:09:30:01

B  21MAY2018:09:35:00

C  21MAY2018:09:40:00

C  21MAY2018:09:40:01

C  21MAY2018:09:40:10

C  21MAY2018:09:41:10

run;

PROC SQL;

CREATE TABLE WANT AS

SELECT ID,DT

 FROM

HAVE

GROUP BY ID

 HAVING MAX(ID)

ORDER BY ID,DT;

QUIT;

EXPECTED OUTPUT

FINAL RESULT

A 21MAY2018:09:29:00

B 21MAY2018:09:35:00

C 21MAY2018:09:41:10

 


Accepted Solutions
Solution
a month ago
PROC Star
Posts: 1,791

Re: HOW TO EXTRACT LATEST DATE

data HAVE;

input ID$ dt;

informat dt datetime.;

format dt datetime.;

cards;
 A  21MAY2018:09:27:00
A  21MAY2018:09:29:00
B  21MAY2018:09:30:01
B  21MAY2018:09:35:00
C  21MAY2018:09:40:00
C  21MAY2018:09:40:01
C  21MAY2018:09:40:10
C  21MAY2018:09:41:10
;
run;

proc sql;
create table want as
select id,max(dt) as dt format=datetime.
from have
group by id;
quit;

View solution in original post


All Replies
Super User
Posts: 10,217

Re: HOW TO EXTRACT LATEST DATE

proc sql;
create table want as
select id, dt
from have
group by id
having dt = max(dt);
quit;
---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Solution
a month ago
PROC Star
Posts: 1,791

Re: HOW TO EXTRACT LATEST DATE

data HAVE;

input ID$ dt;

informat dt datetime.;

format dt datetime.;

cards;
 A  21MAY2018:09:27:00
A  21MAY2018:09:29:00
B  21MAY2018:09:30:01
B  21MAY2018:09:35:00
C  21MAY2018:09:40:00
C  21MAY2018:09:40:01
C  21MAY2018:09:40:10
C  21MAY2018:09:41:10
;
run;

proc sql;
create table want as
select id,max(dt) as dt format=datetime.
from have
group by id;
quit;
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 56 views
  • 0 likes
  • 3 in conversation