topic Re: difference between dates in SAS Programming

difference between dates

gzr2mz39 — Tue, 01 Jul 2014 23:52:11 GMT

Typically cupa_dt is greater than start_dt. However, when start_dt is greater than cupa_dt I need to switch around start_dt and cupa_dt to get the correct difference between the two dates. Is there any way to accomplish this without creating a flag (ie cc_check)?

cupa_dt=dhms(TDT,0,0,TTM);

start_dt=dhms(CSDAT,0,0,CSTIM);

cc_check=0;

if (start_dt>cupa_dt and cupa_dt ne .) then cc_check=1;

if(cc_check=0) then do;
cc_diff=round(((cupa_dt-start_dt)/86400),0.01);
end;

if(cc_check=1) then do;
cc_diff=round(((start_dt-cupa_dt)/86400),0.01);
end;

Thank you.

Re: difference between dates

stat_sas — Wed, 02 Jul 2014 00:05:18 GMT

Just add abs function

cc_diff=round(((abs(cupa_dt-start_dt))/86400),0.01);

Re: difference between dates

Peter_C — Wed, 02 Jul 2014 22:50:08 GMT

although you have one solution, here is another

difference = range( date1, date2 ) ;

Here is some code to demo the result .

data ;

do date1 = today() - 3 to today()+2, . ;

do date2 = today() - 3 to today()+2, . ;

diff= range( date1,date2) ;

output ;

end; end;

stop;

format date: date. ;

run ;