Retrieve the most recent date in a dataset

[Breezy]

Hi there,

I have a data set with duplicate account numbers but unique connect dates, this is the code I wrote...but I keep on getting errors

Data Z_Connect_Data;

set Connect_Data;

format Newest_Connect_Date mmddyy10.;

Newest_Connect_Date = max(Connect_Date);

run;

I need the most recent connect dates.

Any help would be appreciated.

Thank you

[DBailey]

proc sql;

create table z_connect_data as

select

select

     account_number,

     max(connect_date) as MaxDate

from

     connect_data

group by account_number;

quit;

[Breezy]

Thanks DBailey,

That worked....kind of.

My result set has Account_Number and Max Date, however, the maxdate is not formated as a date but a number?

[SASKiwi]

proc sql;

create table z_connect_data as

select

     account_number,

     max(connect_date) as MaxDate format = mmddyy10.

from

     connect_data

group by account_number;

quit;

[DBailey]

just apply the format you need...presuming that connect_date is a date and not a datetime..

proc sql;

create table z_connect_data as

select

select

     account_number,

     max(connect_date) format=date9. as MaxDate

from

     connect_data

group by account_number;

quit;

[Breezy]

Perfect that worked!!!!

Thank you everyone!