topic Re: Date calculation in SAS Programming

Date calculation

Jedrzej — Thu, 07 Sep 2017 10:12:22 GMT

Hello,

I want to build a macro which shows me current date in datetime format and a date -1 month.

%let date1 = %sysfunc(datetime(),DATETIME16.);

%let date_prev=%sysfunc(intnx(month,"%sysfunc(putn("&date1"d,DATETIME16.))"d,-1,s),DATETIME16.);

%put &date_prev.;

Date1 gives me good results but in date_prev i have 31DEC59:23:53:55.

How I should change this macro to have date_prev = 07AUG2017time ?

Re: Date calculation

PeterClemmensen — Thu, 07 Sep 2017 10:26:24 GMT

Why not do it in a data step like this?

data _null_;
	date1 = datetime();
	date_prev = intnx('dtmonth', date1, -1, 's');
	format date1 date_prev datetime16.;
	put date1= date_prev=;
run;

Re: Date calculation

RW9 — Thu, 07 Sep 2017 10:37:57 GMT

Its been asked many times here. The question is why would you need to? You can always get yesterdays date by doing intnx('year',today,-1); so why bother going through all the effort of calculating it, then storing it as text - macro is always text - then trying to use that text in your code. Its madness.