topic Re: SAS EG : stop the program in SAS Programming

SAS EG : stop the program

SASdevAnneMarie — Fri, 19 Feb 2021 11:05:20 GMT

Hello Experts,

I'm coding in SAS EG, I would like to stop the execution of my program if I have 0 rows in my data. Do you know some option to do that please ?

I mean thant in my EG projet I have 3 programs : firstly I run the pgm_1, after the pgm_2 and the pgm_3.

I would like to put the code in pgm_1, and stop the pgm_2 and pgm_3 if _n_=0 (I run the program by order list). I don't know if it's possible in EG.

My code is:

proc sql noprint;
	select count(*) into :nb from PRRT;
quit; 

%if &nb=0 %then
	%do;
        STOP ?
	%end;

Thank you very much !

Amir — Fri, 19 Feb 2021 12:24:36 GMT

Have you tried looking into the abort statement? The documentation can be found here.

Kind regards,

Amir.

LeonidBatkhan — Fri, 19 Feb 2021 12:24:40 GMT

You can do it this way, for example:

%if &nb=0 %then
%do;
   data _null_;
      abort return;
   run;
%end;

Hope this helps.