topic comparing dates in different formats in SAS Programming

comparing dates in different formats

GreggB — Wed, 04 May 2022 13:33:16 GMT

Service___End_Date Frequency Percent 
09JUN21:00:00:00 5 0.48 
15AUG21:00:00:00 4 0.39 
19AUG21:00:00:00 1 0.10 
30AUG21:00:00:00 1 0.10 
01SEP21:00:00:00 1 0.10 
15SEP21:00:00:00 1 0.10 
12OCT21:00:00:00 1 0.10 
29NOV21:00:00:00 1 0.10

I want a statement that will delete the record if the Service___End_Date occured before today, regardless of when today is.

Re: comparing dates in different formats

PaigeMiller — Wed, 04 May 2022 14:30:39 GMT

if datepart(Service___End_Date)<today() then delete;

Please note that comparing dates is NOT (and is NEVER) a format issue. The above will work regardless of the format of variable Sevice___End_Date.

It is an issue that a date/time value cannot be directly compared to a date value. Date/time values are on a different scale than date values, just like Celsius is on a different scale than Fahrenheit, and you can't compare them without first doing the conversion to the other scale. That is why DATEPART is needed, to obtain a date value that can be compared to another date value TODAY(), and then they are both on the same scale. As stated, in this case, the format is irrelevant, date values can be compared to other date values.

Re: comparing dates in different formats

Quentin — Wed, 04 May 2022 13:41:29 GMT

Please show what code you have tried.

Is Service___End_Date stored in a SAS date-time variable (i.e. numeric value) or is it a character string?

If it's a character string, would recommend using the INPUT function to read it into a date-time variable, and then comparing the value to the current date-time (which is returned by the DATETIME function).