topic Re: How to end sas session conditionally in Batch mode (UNIX) in SAS Programming

How to end sas session conditionally in Batch mode (UNIX)

nbonda — Sat, 15 Aug 2015 04:20:48 GMT

My SAS code has mutliple data step and proc steps. I want end the sas session when certain condition met.

I am running my sas code on UNIX in batch mode. When certain dataset has 0 observations, I want to end session. I used following is example code, it's not working as I expected.

..multiple sas data, proc steps

data _null_;

set old_dataset nobs=_nobs;

if _nobs=0 then call system('endsas');

run;

..multiple data steps.

Thank you

Re: How to end sas session conditionally in Batch mode (UNIX)

Tom — Sat, 15 Aug 2015 23:22:14 GMT

You need to test NOBS before the SET statement executes. Otherwise the data step stops as soon as the SET statement tries to read past the end of the file.

data _null_;

if _nobs=0 then call system('endsas');

else stop;

set old_dataset nobs=_nobs;

run;

Re: How to end sas session conditionally in Batch mode (UNIX)

jakarman — Sun, 16 Aug 2015 06:09:43 GMT

Statements endsas and errorabend are doable in batch, developping in Eguide (and others) it is a bad approach. https://communities.sas.com/message/148347 see CH
In structures programming it is better to validate all conditions at the first steps. Than only whan all input is valid to proceed

With a bathc approach don't make the program too big. smaller pieces are easily connected. Restarting / recovering will become more easy.

Re: How to end sas session conditionally in Batch mode (UNIX)

nbonda — Sun, 16 Aug 2015 19:17:11 GMT

Than you for reply. I modified the code and ran the batch job. The sas session not terminating, still continue to process further sas steps. am I missing to add anything? endsas is not terminating session here.

Re: How to end sas session conditionally in Batch mode (UNIX)

Tom — Mon, 17 Aug 2015 01:31:21 GMT

Did you remember to include the semi-colon for the ENDSAS statement in the CALL EXECUTE() call?

Re: How to end sas session conditionally in Batch mode (UNIX)

Kurt_Bremser — Mon, 17 Aug 2015 06:34:55 GMT

call system runs a system process, in this case it will try to run the program endsas if such is found in your search path.

I guess you want to use call execute, but why go to such a hassle?

if _nobs = 0 then abort abend 4;