I run monthly files and trying to create title something like --
"Files are current through December31, 2017".
I do not want to hard code in my program. I know I can use %sysfunc on the file creation day using data dictionary. Then how am I going to get last day of each month.
Any tips will be greatly appreciated.
Thank you!
BG
INTNX will give you the end of the month.
Use the difference of 0 months and the fourth parameter allows you to align the date to the end of the month.
The documentation has an example if you're having difficulty or post your code back here.
@Bula wrote:
I run monthly files and trying to create title something like --
"Files are current through December31, 2017".
I do not want to hard code in my program. I know I can use %sysfunc on the file creation day using data dictionary. Then how am I going to get last day of each month.
Any tips will be greatly appreciated.
Thank you!
BG
Here's the english version:
Note that you can use the TODAY() function to get todays date.
Post what you've tried and I'll be happy to help further.
No luck 😞
Please find the attachment. When I clicked on your documentation link, I simply get a blank page.
You need to get that fixed...not having access to the documentation doesn't make sense. Does your work block websites?
Or did you try some old versions, ie SAS 9.3?
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.