topic Re: Retrieve the most recent date in a dataset in SAS Procedures

Retrieve the most recent date in a dataset

Breezy — Thu, 06 Feb 2014 17:59:05 GMT

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

Re: Retrieve the most recent date in a dataset

DBailey — Thu, 06 Feb 2014 18:15:47 GMT

proc sql;

create table z_connect_data as

select

account_number,

max(connect_date) as MaxDate

from

connect_data

group by account_number;

quit;

Re: Retrieve the most recent date in a dataset

Breezy — Thu, 06 Feb 2014 18:29:05 GMT

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?

Re: Retrieve the most recent date in a dataset

SASKiwi — Thu, 06 Feb 2014 18:43:58 GMT

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;

Re: Retrieve the most recent date in a dataset

DBailey — Thu, 06 Feb 2014 18:44:17 GMT

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

account_number,

max(connect_date) format=date9. as MaxDate

from

connect_data

group by account_number;

quit;

Re: Retrieve the most recent date in a dataset

Breezy — Thu, 06 Feb 2014 18:59:47 GMT

Perfect that worked!!!!

Thank you everyone!