topic Re: How to get max date from entries in SAS Procedures

How to get max date from entries

BETO — Sun, 26 Jul 2015 06:25:03 GMT

hi I haveatablewhere I want to get max date for example

have

id. Date type. comp

a. 07/15/15 A1. Yes

b 07/16/15. A2. No

a 07/18/15. A2. Yes

c 07/15/15. A3. No

what I want is to pull the max date which is he last time it was service

out put

a.07/18/15 A2. yes

b 07/16/15. A2 No

c 07/15/15. A3. No

thanks

Jagadishkatam — Sun, 26 Jul 2015 07:06:10 GMT

Please try

proc sort data=have;

by id date;

run;

data want;

set have;

by id date;

if last.id;

run;

Thanks,

Jag

Jagadishkatam — Sun, 26 Jul 2015 07:19:37 GMT

Also try the sql method

proc sql;

create table want as select a.* from have as a, (select max(date) as date, id from have group by id) as b

where a.id=b.id and a.date=b.date ;

quit;

Thanks,

Jag