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?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.