topic Re: to find minimum of two date values? in SAS Procedures

to find minimum of two date values?

sassharp — Tue, 21 Feb 2012 15:47:15 GMT

I need to find minimum of two dates.

I know I can use min function.

q.what precautions do I need to follow?

Ex min(d1,d2)

q.d1,d2 should be in same format?

Here is the requirement.

proc sql;

create table l1

select

termdate format=datetime21.

from t1;

quit;

proc sql;

select min(today()-1,termdate) as testdate format=datetime21.

from l1,l2;

where l1.id=l2.id;

quit;

termdate output testdate

31DEC9999:00:00:00 20FEB2012

30APR2006:00:00:00 20FEB2012

Q) here there are no errors. But for two different termdate inputs I am getting the same output?

to find minimum of two date values?

Haikuo — Tue, 21 Feb 2012 15:49:53 GMT

As long as they are date (numeric), format does not matter.

Haikuo

to find minimum of two date values?

Hima — Tue, 21 Feb 2012 16:04:02 GMT

PROC SQL;

SELECT CASE WHEN DATE1<DATE2 THEN DATE1 ELSE DATE2 END AS MIN_DATE FORMAT MMDDYY10. FROM TEST;

QUIT;

to find minimum of two date values?

Haikuo — Tue, 21 Feb 2012 16:09:36 GMT

I think using min() as OP suggested is safer. '<' will capture missing values as the smaller date, which I suppose not OP's intention.

Kindly Regards,

Haikuo

to find minimum of two date values?

Haikuo — Tue, 21 Feb 2012 16:14:31 GMT

Comparing datetime. and date directly will be missleading, saying that I would like to retreat my original comments on the format part. Try the following:

proc sql;

select min(today()-1,datepart(termdate)) as testdate format=datetime21.

from l1,l2;

where l1.id=l2.id;

quit;

Regards,

Haikuo

Re: to find minimum of two date values?

art297 — Tue, 21 Feb 2012 16:28:50 GMT

Or, if the time is also important,

select min(datetime()-(24*60*60),termdate) as testdate format=datetime21.

otherwise,make sure that the format is consistent

Re: to find minimum of two date values?

Haikuo — Tue, 21 Feb 2012 16:32:42 GMT

Considerably the best approach so far, Art! if ')' was added would be perfect!

Kindly Regards,

Haikuo

Re: to find minimum of two date values?

art297 — Tue, 21 Feb 2012 16:35:52 GMT

Corrected it. Thanks for pointing out my typo.

Re: to find minimum of two date values?

Ksharp — Wed, 22 Feb 2012 06:57:36 GMT

Can you post some sample data.

Maybe you miss a group by clause.

Ksharp