topic Re: Extracting month from a file creation data using %sysfunc function in SAS Enterprise Guide

Extracting month from a file creation data using %sysfunc function

Bula — Wed, 07 Feb 2018 23:17:49 GMT

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!

Re: Extracting month from a file creation data using %sysfunc function

Reeza — Wed, 07 Feb 2018 23:21:24 GMT

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

Re: Extracting month from a file creation data using %sysfunc function

Bula — Wed, 07 Feb 2018 23:26:35 GMT

Thank you Reeza! I will try tomorrow to figure it out.

Re: Extracting month from a file creation data using %sysfunc function

Bula — Thu, 08 Feb 2018 22:26:45 GMT

Hi Reza,

I spent a bit time on refreshing INTNX function. My Base SAS documentation is showing foreign language. I do not know why. If you please could send me code that would ve very helpful.
Thanks Reza

Re: Extracting month from a file creation data using %sysfunc function

Reeza — Thu, 08 Feb 2018 22:31:20 GMT

Here's the english version:

http://documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=p10v3sa3i4kfxfn1sovhi5xzxh8n.htm&docsetVersion=9.4&locale=zh-CN

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.

Re: Extracting month from a file creation data using %sysfunc function

Bula — Thu, 08 Feb 2018 22:38:46 GMT

Re: Extracting month from a file creation data using %sysfunc function

Bula — Thu, 08 Feb 2018 22:43:18 GMT

No luck 😞

Please find the attachment. When I clicked on your documentation link, I simply get a blank page.

Re: Extracting month from a file creation data using %sysfunc function

Reeza — Thu, 08 Feb 2018 23:04:41 GMT

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?