topic Re: SAS macro for 1 year from today in SAS Data Management

SAS macro for 1 year from today

Jade_SAS — Fri, 15 Jun 2018 15:52:24 GMT

Hi All,

How I can use SAS macro for one year from today?

I used the Macro below and got the wrong date as 01Jan2017, is there anything I did wrong? Thank you!

%let LYT=%sysfunc(intnx(year,%sysfunc(today()),-1),date9.);

%PUT &LYT;

Jade

novinosrin — Fri, 15 Jun 2018 15:57:10 GMT

%let LYT=%sysfunc(intnx(year,%sysfunc(today()),-1,s), date9. );

%PUT &LYT;

SuryaKiran — Fri, 15 Jun 2018 16:24:29 GMT

%let LYT=%sysfunc(intnx(year,%sysfunc(today()),-1,s), date9. );

%PUT &LYT;

If you miss the aurguent "SAMEDAY" or "S" or "SAME" then by default it will give you 1st day of the year.

Jade_SAS — Fri, 15 Jun 2018 18:05:11 GMT

Thank you!