02-06-2014 12:59 PM
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
format Newest_Connect_Date mmddyy10.;
Newest_Connect_Date = max(Connect_Date);
I need the most recent connect dates.
Any help would be appreciated.
02-06-2014 01:44 PM
just apply the format you need...presuming that connect_date is a date and not a datetime..
create table z_connect_data as
max(connect_date) format=date9. as MaxDate
group by account_number;