topic Re: Always auto run macro after submitting a sas code in SAS Programming

Always auto run macro after submitting a sas code

hellind — Thu, 24 May 2012 02:25:55 GMT

I have a macro %ERR that checks for error and play a sound. I want this macro to run it every time when I execute a code. Instead of manually running %ERR, is there anywhere to setup in Preferences so that it automatically runs?

There is a similar feature in Tools > Options > Preferences > Results for HTML Output which is very useful.

Re: Always auto run macro after submitting a sas code

Tom — Thu, 24 May 2012 03:23:20 GMT

Not sure what you mean. Are you running programs interactively from the SAS Display Manager? Then you can issue any commands you want and even define keys to execute the commands for you. You can even add icons to run the commands. For example you could define the F8 key to be the command sequence submit followed by the gsub command to submit the call to your %ERR macro. You can also define command macros that instead of generating SAS program statements can be used to generate Display Manager commands like submit or gsub.

Re: Always auto run macro after submitting a sas code

Ksharp — Thu, 24 May 2012 03:44:30 GMT

Yes. SAS offer a system option to solve such problem. You can populate the statements of the macro into this option . and these statements will execute after the code running.

TERMSTMT= System Option

Specifies the SAS statements to execute when SAS terminates.

Valid in: configuration file, SAS invocation

Category: Environment control: Initialization and operation

PROC OPTIONS GROUP= EXECMODES

Syntax

TERMSTMT=’statement(s)’

Syntax Description

’statement(s)’

is one or more SAS statements.

Maximum length: 2,048 characters

Operating Environment Information: In some operating system environments there is

a limit to the size of the value for TERMSTMT=. To circumvent this limitation, you can

use the %INCLUDE statement.

Details

TERMSTMT= is fully supported in batch mode. In interactive modes, TERMSTMT= is

executed only when you submit the ENDSAS statement from an editor window to

terminate the SAS session. Terminating SAS by any other means in interactive mode

results in TERMSTMT= not being executed.

An alternate method for specifying TERMSTMT= is to put a %INCLUDE statement

at the end of a batch file or to submit a %INCLUDE statement before terminating the

SAS session in interactive mode.

Comparisons

TERMSTMT= specifies the SAS statements to be executed at SAS termination, and

INITSTMT= specifies the SAS statements to be executed at SAS initialization.

Ksharp

Re: Always auto run macro after submitting a sas code

ballardw — Thu, 24 May 2012 14:19:48 GMT

Here's a warped approach. Redefine your macro as

%macro Run;

run;

%mend;

Then any proc or data step you want end with %run; instead of a simple run; statement.

If the issue is getting tired of typing the macro into the code then create an editor macro to insert the statement.

Tom's approach is probably better though.

Re: Always auto run macro after submitting a sas code

CBADavid — Thu, 24 May 2012 22:16:38 GMT

I would like to see your error checking code if you're prepared to share? I've long been trying to write something which determines whether an error occurs and can decide whether to submit further statements or not.

Re: Always auto run macro after submitting a sas code

ChrisNZ — Thu, 24 May 2012 23:26:30 GMT

Maybe this would help you cancel further statements in case of errors David:

http://support.sas.com/kb/24/825.html

Re: Always auto run macro after submitting a sas code

hellind — Fri, 25 May 2012 06:15:52 GMT

TERMSTMT= is fully supported in batch mode. In interactive modes, TERMSTMT= is executed only when you submit the ENDSAS statement from an editor window to terminate the SAS session. Terminating SAS by any other means in interactive mode results in TERMSTMT= not being executed.

I am using SAS Display Manager. I want it to play a loud sound when it hits a error. TERMSTMT can be used in SAS invocation which is good. But it seems it only executes when SAS terminates. (ENDSAS will close SAS session which I do not want)

I am exploring all the solutions suggested in this thread. Thanks.

Re: Always auto run macro after submitting a sas code

hellind — Fri, 25 May 2012 06:19:10 GMT

I am still exploring. I am not running a batch jobs. I am using SAS Display Manager interactive. Sometimes, I am tired to trying to read the long logs, I want it to play a loud sound.

Error Checking Macro will be based on this paper, but instead of emailing me, it will play a sound.

http://www.nesug.org/proceedings/nesug05/ap/ap9.pdf

Re: Always auto run macro after submitting a sas code

kishore415 — Fri, 12 Oct 2012 05:00:27 GMT

Hi..Hellind

Did you find any solution for this.? Am searching for same kind of solution..

Thanks,

Kishore Vengala

Re: Always auto run macro after submitting a sas code

data_null__ — Fri, 12 Oct 2012 13:46:50 GMT

You can do that with SAS Enterprise Guide. See: Tool>Options>SAS Programs.