topic Error handling in Macro facility in SAS Programming

Error handling in Macro facility

MJyothi — Tue, 24 May 2011 07:53:48 GMT

Hi All,

This may be a tricky question, however i hope there will be a solution for the same.

I have created one automated macro with error traping, like if there is an error in macro in any of the steps macro will through an error and stops execution. Now i want to execute my macro from the error only after modification.

For example i got the error in 3rd step of macro, i will change it and execute it again, then the macro should execute from 3rd step only not from step1 which reduces the execution time.

In long process executions it will help us a lot.

Any thoughts ?

Re: Error handling in Macro facility

sbb — Tue, 24 May 2011 14:44:57 GMT

You will need to setup some external detection, either with a SAS file or an external file that gets written to as you progress through the macro execution. You would then need to add appropriate SAS code to detect any prior progress and as needed suppress some SAS MACRO code logic execution. The topic would be "restartability".

Scott Barry
SBBWorks, Inc.

Re: Error handling in Macro facility

PatrickG — Thu, 02 Jun 2011 14:41:59 GMT

Do you typically see errors every time you run your program or are you just trying to debug it?

Re: Error handling in Macro facility

ArtC — Sun, 05 Jun 2011 05:58:41 GMT

Take a look at the %ABORT statement. Depending on the level of termination that you want to achieve, it may be helpful. It also allows you to 'pass back' a return code which you may be able to use to determine your restart point.