topic automating macros w/ if & then statements in SAS Programming

automating macros w/ if & then statements

_LB — Mon, 03 Oct 2011 17:41:46 GMT

Hello folks!

A small question concerning the automation of macro's-

SO let's say I have %a & %b that I want to run under certain circumstances-

Lets say that if the day of the month is between 1 and 7 I want %a to run otherwise I want %b to run;

Thank you all again.

Lawrence

automating macros w/ if & then statements

art297 — Mon, 03 Oct 2011 17:54:24 GMT

One way would be with a third macro. Something like the following should work:

%macro driver;

%if %sysfunc(day(%sysfunc(today()))) le 7 %then %do;

%end;

%else %do;

%end;

%mend driver;

%driver

automating macros w/ if & then statements

_LB — Mon, 03 Oct 2011 23:47:36 GMT

Thanks Art.

That helps. I was close but was missing an element or two.

automating macros w/ if & then statements

_LB — Fri, 07 Oct 2011 20:20:48 GMT

Art,

Question-

If i want to simply end the program if it does not fall on a specific day, how does that go?

Thanks.

Lawrence

automating macros w/ if & then statements

art297 — Fri, 07 Oct 2011 20:25:33 GMT

I think that would depend on precisely what you want to happen next. If you just want to stop a currently running data step you could always just route the code to a stop statement. e.g.,

http://support.sas.com/documentation/cdl/en/imlug/59656/HTML/default/viewer.htm#programstatements_sect16.htm

automating macros w/ if & then statements

_LB — Fri, 07 Oct 2011 20:32:40 GMT

Hi Art-

Thanks for the link, however, It is part of a larger macro so that I just want to "kill" the program if it doesn't fall on a specific day, plus actually I have a few programs bundled as well so I don't want to recode everything again. Is this feasible?

Thanks again.

Lawrence

%macro driver;

%if %sysfunc(day(%sysfunc(today()))) le 7 %then %do;

%end;

%else %do;

"KILL PROGRAM" ?

%end;

%mend driver;

%driver

automating macros w/ if & then statements

art297 — Fri, 07 Oct 2011 20:59:36 GMT

You have numerous options depending on just what you want to terminate, e.g., abend, abort and systask. Take a look at the following thread: http://www.mathkb.com/Uwe/Forum.aspx/sas/41557/Re-Kill-the-sas-program-if-it-runs-too-long

automating macros w/ if & then statements

_LB — Fri, 07 Oct 2011 21:13:29 GMT

Ah yes-the good ole %abort function. Thanks & Have a great weekend!