topic Re: Stop the SAS code execution based on error in SAS Programming

Stop the SAS code execution based on error

ganeshsas764 — Thu, 12 Nov 2020 16:09:45 GMT

Hi Team,

I need help,

I need to stop the SAS code execution based on error.

I have a SAS report, when I executing code by manually I need to stop the code if any error occurs during the data step or proc step, the code should be stopped at a time without the run remaining steps and the code should not close.

Thanks & Regards

A Ganesh

Re: Stop the SAS code execution based on error

r_behata — Thu, 12 Nov 2020 17:05:36 GMT

Try :

options errorabend;

Re: Stop the SAS code execution based on error

SASKiwi — Thu, 12 Nov 2020 19:06:16 GMT

The ERRORABEND option is a good one to use but is only useful for SAS batch jobs. It will immediately close your SAS session so unless you are running a batch job you will lose your SAS log and outputs so far.

Re: Stop the SAS code execution based on error

ganeshsas764 — Thu, 12 Nov 2020 19:10:27 GMT

If I use ERRORABEND in open code .. automatically sas session will close ..but i need to stop code with out closing session

Re: Stop the SAS code execution based on error

Kurt_Bremser — Thu, 12 Nov 2020 20:21:25 GMT

Wrap the code you don't want to execute in case of errors into this:

%if &syscc. = 0 %then %do;

/* code *

%end;

It is possible to use %IF like this in open code (outside a macro) since 9.4M5 (at least).

Re: Stop the SAS code execution based on error

SASKiwi — Fri, 13 Nov 2020 02:48:55 GMT

If you are after a simple solution then try options SYNTAXCHECK. Your session will remain open but remaining code will run but not process any data (OBS is set to 0). Not quite what you want you could well find it useful.

Re: Stop the SAS code execution based on error

ChrisNZ — Fri, 13 Nov 2020 04:34:22 GMT

Sadly this simple feature has been requested for as long as I remember, and SAS never did anything.

Follow the link for a nasty workaround.

Another way is to use

%abort cancel;

data t; abort cancel; run;

You have to test manually though.