topic Re: Stop SAS when error in SAS Programming

Stop SAS when error

Brandon16 — Tue, 23 Jan 2018 11:17:34 GMT

Hi,

I have 1500 lines off SAS code which can take up to 2 hours to run, how do I add a stop execution upon finding an error?

Thanks in advance

Re: Stop SAS when error

ChrisBrooks — Tue, 23 Jan 2018 11:34:16 GMT

To be honest 1,500 lines of code isn't really the problem (I've seen much bigger programs) it's the quantity of data and how it's being processed which is causing the long run time.

You could set the errorcheck option to STRICT as documented here -> http://documentation.sas.com/?docsetId=lesysoptsref&docsetTarget=n074sx2hkq8dzpn1ptoydcmzfspt.htm&docsetVersion=9.4&locale=en

or use the errorabend option but that will terminate the whole session leaving you no wiser as to what went wrong....

Re: Stop SAS when error

RW9 — Tue, 23 Jan 2018 11:51:35 GMT

Ensure the 1500 lines of code has been: modularised, validated, and stress tested. Then an unexpected error will not happen. Modularising the code will allow you to block the whole process up into smaller chunks, allowing for conditionally checking at various points.

The question really is what does your documentation on the process say - you do have all the documentation e.g. functional design, testing, data structures etc.

Re: Stop SAS when error

Brandon16 — Tue, 23 Jan 2018 11:55:54 GMT

Each month code is added by a range a different users and therefore that's why i want to include this ch eck.

Still unsure how I do this.

Re: Stop SAS when error

RW9 — Tue, 23 Jan 2018 12:00:43 GMT

Even more reason for modularistion and documentation. Each new block should be documented and validated before being moved into the production process.

Re: Stop SAS when error

Ksharp — Tue, 23 Jan 2018 12:23:25 GMT

Try these two options.

options errorabend nosyntaxcheck;

Re: Stop SAS when error

Brandon16 — Tue, 23 Jan 2018 12:33:53 GMT

Do I add this at the start of my code and execute the whole program?

Re: Stop SAS when error

Ksharp — Tue, 23 Jan 2018 13:12:07 GMT

Yes. Or add into autoexec.sas

Re: Stop SAS when error

Quentin — Tue, 23 Jan 2018 13:48:41 GMT

@Ksharp, what is the benefit of adding nosyntaxcheck? I think errorabend would be enough. As I understand it, nosyntaxcheck is used to tell SAS to keep executing code after an error, rather than entering syntax check mode.