topic How to select max date in SAS Programming

How to select max date

bijayadhikar — Fri, 23 Dec 2022 00:29:00 GMT

HI,

I am looking to create a new column with max date. That mean my new column 'max_date should have 27jul2012 for all the caseid?

data have;
input caseid $ myDate date9.;
format myDate date9.;
datalines;
34 27jul2010
35 27jul2011
37 27jul2012

;
run;

Thanks in advance.

SK_11 — Fri, 23 Dec 2022 00:41:38 GMT

Try this:

Proc sql;
Create table want as 
Select *, max(myDate) as maxDate format date9.
from have
;Quit;

Output:

PaigeMiller — Fri, 23 Dec 2022 00:43:30 GMT

Proc sql;
Create table want as select *, max(mydate) as max_date format=date. from have;
Quit;

SK_11 — Fri, 23 Dec 2022 00:43:31 GMT

Output:

bijayadhikar — Fri, 23 Dec 2022 01:02:20 GMT

Sorry for inconvenience.
I found a solution. just ignore.
Bijay