BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Jade_SAS
Pyrite | Level 9

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

1 ACCEPTED SOLUTION

Accepted Solutions
SuryaKiran
Meteorite | Level 14

%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.

 

 

Thanks,
Suryakiran

View solution in original post

3 REPLIES 3
novinosrin
Tourmaline | Level 20
%let LYT=%sysfunc(intnx(year,%sysfunc(today()),-1,s), date9. );

%PUT &LYT;
SuryaKiran
Meteorite | Level 14

%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.

 

 

Thanks,
Suryakiran
Jade_SAS
Pyrite | Level 9

Thank you!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 2057 views
  • 0 likes
  • 3 in conversation