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?
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.