topic Re: Comparing SAS Dates in SAS Programming

Comparing SAS Dates

CEG — Wed, 19 Apr 2017 17:40:08 GMT

Hello,

I'd like to compare dates by using TODAY and TODAY -1 to see when my incoming date (TODAY) becomes a new month.

Any suggestions?

Thanks,

CEG

Re: Comparing SAS Dates

novinosrin — Wed, 19 Apr 2017 17:46:51 GMT

Do you mean like:

if month(today()) ne month(today()-1);

if month(today()) gt month(today()-1);

Re: Comparing SAS Dates

PaigeMiller — Wed, 19 Apr 2017 17:48:02 GMT

@CEG wrote:

Hello,

I'd like to compare dates by using TODAY and TODAY -1 to see when my incoming date (TODAY) becomes a new month.

Any suggestions?

Thanks,

CEG

You don't need to compare TODAY and TODAY-1 to see when a new month starts. You can just see if the day of the month is equal to 1. Which, in code, looks like:

if day(today)=1 then ... ;

Re: Comparing SAS Dates

CEG — Wed, 19 Apr 2017 18:01:16 GMT

Thanks. I didn't know that.

Re: Comparing SAS Dates

CEG — Wed, 19 Apr 2017 18:02:01 GMT

Thanks.