Help using Base SAS procedures

Retrieve the most recent date in a dataset

Reply
Occasional Contributor
Posts: 5

Retrieve the most recent date in a dataset

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

Super Contributor
Posts: 578

Re: Retrieve the most recent date in a dataset

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;

Occasional Contributor
Posts: 5

Re: Retrieve the most recent date in a dataset

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?

Super User
Posts: 3,257

Re: Retrieve the most recent date in a dataset

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;

Super Contributor
Posts: 578

Re: Retrieve the most recent date in a dataset

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;

Occasional Contributor
Posts: 5

Re: Retrieve the most recent date in a dataset

Perfect that worked!!!!

Thank you everyone!

Ask a Question
Discussion stats
  • 5 replies
  • 2321 views
  • 0 likes
  • 3 in conversation