Hello, I'm trying to solve a bug in my code where I have some if...then...do...else...do logic. The bug is that the code 'does' both tasks regardless of passing/failing condition. Specifically, the code is supposed to do nothing in a 'Success' (mkt_count > 350). In a failure, (mkt count < 350), it should spit out an email. However, an email is being generated in both cases (even though no warnings or errors are thrown). Any idea what I'm doing wrong? I'm using SAS Enterprise Guide 7 if that matters. data _null_; %let src_tbl='table a'; %let trg_tbl='table b'; if &mkt_count.>350 then do; put 'SUCCESS'; call symput('src_tbl','table a'); call symput('trg_tbl','table b'); end; else do; put 'FAILURE'; call symput('src_tbl','table a'); call symput('trg_tbl','table b'); filename getdone email from='admin@xyz.com' to=( 'analyst@xyz.com' ) subject="(Teradata &code_env) Subject line" content_type="text/html"; ods listing close; ods html style=styles.test body=getdone; TITLE1 'This email is still under testing as it is throwing false alarm.'; ODS HTML CLOSE; ODS LISTING; end; run;
... View more