Hello, I have the following final table (every day the table contents change): CARD Table: The code: %macro mymail(
from=freetalk@gmail.com,
to=,
acct_no=,
branch_id=,
card=,
id=
);
filename outbox email "freetalk@gmail.com" encoding="utf-8";
data _null_;
file outbox
to=( "&to")
from= ("&from")
subject= "Closing &acct_no - &branch_id";
put "Cancel any instructions in the account &acct_no - &branch_id :" ;
put /;
put " &card - &id";
put /;
run;
%mend;
data _null_;
set CARD;
length cmd $500;
cmd=cats( '%mymail(to=',Mail_to,',acct_no=',Account_Number,',branch_id=',Branch_ID,',card=',Card_No,',id=',ID,')' );
call execute(cmd);
run; According to the code, they will send 5 emails, but I would like to change that they will only send 4 emails. When the Branch_ID + Account_Number + ID + Mail_to fields are the same in the CARD table, it will send one email instead of two. The email will look like this: The line 2341245543 - 21312 was added to the existing email instead of sending 2 emails. I would appreciate your help.
... View more