topic Re: Max date value in SAS Programming

Max date value

Siddhartha — Wed, 15 Oct 2014 15:29:37 GMT

Hi,

I am having the columns as AS_OF_DT and dw_Load_time as date columns and the format is numeric.

I need to take the latest of these date values.

AS_OF_DT DW_LOad_time

19601 19614.462789

19589 19614.462789

19235 19603.345679

19590 19405.213453

19560 19349.298756

19340 18777.132456

19430 18796.654378

I need to refer these in the codes as macro variables.

Could any one help me on how to go on this.

Regards,

Sid

Re: Max date value

stat_sas — Wed, 15 Oct 2014 15:36:47 GMT

proc sql noprint;
select max(AS_OF_DT), max(DW_LOad_time) into :max_date, :max_time from have;
quit;

%put &max_date &max_time;

Re: Max date value

Siddhartha — Wed, 15 Oct 2014 16:38:34 GMT

I was unable to get the values in correct format i.e., DW_Load_time should come as datetime format.

Regards,

Sid

Re: Max date value

CTorres — Wed, 15 Oct 2014 17:39:28 GMT

First you need to convert dates into datetimes multiplying by 86400:

data have;
input AS_OF_DT DW_LOad_time;
format AS_OF_DT DW_LOad_time datetime.;
as_of_dt=as_of_dt*86400;
dw_load_time=dw_load_time*86400;
cards;
19601 19614.462789
19589 19614.462789
19235 19603.345679
19590 19405.213453
19560 19349.298756
19340 18777.132456
19430 18796.654378
;
run;

proc sql noprint;
select max(AS_OF_DT) as max_DT format datetime., max(DW_LOad_time) as Max_DW_Load_time format datetime. into :max_date, :max_time from have;
quit;
%put &max_date &max_time;

CTorres

Re: Max date value

stat_sas — Wed, 15 Oct 2014 19:11:05 GMT

As suggested by CTorres, to get DW_Load_time as datetime format first convert DW_Load_time into seconds then apply datetime format.

Re: Max date value

Reeza — Wed, 15 Oct 2014 20:14:58 GMT

Assuming your load time is actually a date and your data provided is incorrect:

proc sql noprint;

select max(put(AS_OF_DT, date9.)), max(put(DW_LOad_time, datetime21.)) into :max_date, :max_time from have;

quit;

%put &max_date &max_time;

Assuming your load time is actually a date and you need to convert it to datetime

proc sql noprint;

select max(put(AS_OF_DT, date9.)), max(put(dhms(DW_LOad_time,0,0,0), datetime21.)) into :max_date, :max_time from have;

quit;

%put &max_date &max_time;