topic Re: Running a program once a month in SAS Enterprise Guide

Running a program once a month

tbatliner — Thu, 30 Oct 2008 07:22:34 GMT

Dear all,

how would I check e.g. "First Saturday in current Month" or "Last Sunday in current Month"? I checked [pre]intnx[/pre] but couldn't find the solution there. With something like[pre]
%if weekday(today()) = 7 and day(today()) lt 8 %then %do;
...
%end;
[/pre]
I could solve this Problem; but is there a "nicer" way?

Thanks in advance,
Thomas

Re: Running a program once a month

LinusH — Thu, 30 Oct 2008 09:18:38 GMT

I think that your solution is quite neat, although the NWKDOM function may give an alternative. And to use functions with macro programming, you have to use the %sysfunc macro function.

Regards,
Linus

Re: Running a program once a month

Patrick — Thu, 30 Oct 2008 12:22:11 GMT

Hi Linus
What is this "NWKDOM" function? I don't know it and can't find it in the SAS OnlineDoc.
Cheers, Patrick

Re: Running a program once a month

LinusH — Thu, 30 Oct 2008 12:27:26 GMT

It is an ETS function that has moved to Base SAS with 9.2. Sorry, should have mentioned it.

/Linus

Re: Running a program once a month

tbatliner — Thu, 30 Oct 2008 14:01:05 GMT

Hi Linus,

thanks for your quick reply. Never heard of this function and as we are not using ETS I will have to use my solution.

Thanks and br,
Thomas

Re: Running a program once a month

deleted_user — Thu, 30 Oct 2008 20:36:06 GMT

came across this a while ago:
http://support.sas.com/kb/24/655.html

it seems like some examples might be relevant for your needs.

Re: Running a program once a month

tbatliner — Tue, 04 Nov 2008 09:42:55 GMT

Great! Never heard of "week.2" etc.
This should solve my problem in an elegant way,

thanks,
Thomas

Re: Running a program once a month

tbatliner — Thu, 04 Nov 2010 14:49:41 GMT

Dear community,

exactly two years later I have a similar date-Problem: how to determine the last workday (Friday) on or before the 25th? 🐵

Let's assume I have a variable d25cm (25th of current month). I tried with
[PRE]
data _null_;
WDB25=intnx('week.6',&d25cm,(weekday(&d25cm) in (2,3,4,5,6))-1);
if today() = WDB25 then do;
/* more code */
end;
run;
[/PRE]

but that doesn't work as expected. Any idea will be of great help!

With best regards,
Thomas

Re: Running a program once a month

tbatliner — Thu, 04 Nov 2010 15:09:06 GMT

I think I just found an easy solution (didn't know about the 'weekday' interval):
[PRE]
WDB25=intnx('weekday',d25cm,0);
[/PRE]

Thomas