Stop SAS EG project if error is encountered

[sivastat08]

Hi All ,

i have an SAS emailer, it should not sent any mails if there is NO Data | Error- any where in a project.

i have an  4 Process flows in SAS EG and using Query Builders .

Thanks,

Siva

[andreas_lds]

I never used it, but you can add conditions to every step in process flow, the build-in help has a chapter about "conditional processing".

[sivastat08 · Accepted solution]

 have used another idea for skipping this "Stop SAS EG project if error is encountered"

Answer:

If my data set does not have any observations then it should not sent a mail alert with the message of

"No production happened on 15th MAR 2019"

By referring below links of sas.support 

Not send email if error exist

Do not send email if no data

proc sql send result count in macro

%let day=%sysfunc(putn(%eval(%sysfunc(today())-1),date9.));
%put &day;

%MACRO record_check;
%local count cnt;

proc sql;
select count(*) into :cnt from WORK.EMPData;
quit;

%if &cnt > 0 %then
%do;
filename outbox email /*"&Email."*/
to=('siva.kumar@SAShealth.com')
cc=('kumar.siva@SAShealth.com')
type='text/html'
subject='No production happened on &day'
from="sas.test@SAShealth.com";
run;

ods html body=outbox style=minimal rs=none;

data new;
set WORK.EMPData;
run;

title HEIGHT=0.5cm color=black JUSTIFY=CENTER BOLD "Test Report";
title;
ods;
%end;
%MEND record_check;

%record_check;