How to attach multiple .pdf in SAS mail through SAS macro

Sharath_naik — Tue, 22 Dec 2020 07:05:28 GMT

proc sql noprint;
select count(file)into :cnt from new_file;
select email_id into :email_id from ack;
select cat into :cat from want;
quit;

%put &cat.;

%macro Mail_S;
%if &cnt %gt 0 %then %do;
OPTIONS EMAILSYS=SMTP EMAILHOST=intramail.cis.cat.com EMAILID="abc@com";
FILENAME BLAT EMAIL
FROM = ( "Abc@com" )
TO = ( "Abc@com" )
cc = ("Abc@com")
SUBJECT = ( "New Order Acknowledgement -(&sysdate9.)")
ATTACH = ( &cat. ct='application/octet-stream' )
TYPE = "TEXT/HTML"

;
DATA _NULL_;
FILE BLAT;
PUT '<HTML><BODY>';
put "Hi Team, ";
put "&emsp; recieved on &sysdate9.. ";
put 'If you have any questions, ';
put "Thank You, ";
put "Team ";
put '</BODY></HTML>';
run;
%end;
%mend Mail_s;

%mail_s;

When ever i send using above code, only one pdf file is able to open , remaining file will not be opened , please help me to figure out thisissue

Re: How to attach multiple .pdf in SAS mail through SAS macro

RichardDeVen — Tue, 22 Dec 2020 11:20:17 GMT

Show the data you have for tables NEW_FILE, ACK, and WANT

Re: How to attach multiple .pdf in SAS mail through SAS macro

Kurt_Bremser — Tue, 22 Dec 2020 12:02:03 GMT

Create a correct list of files to be attached:

select quote(strip(cat)) into :cat separated by " " from want;

and you'll get a list of quoted filenames as described in the documentation of FILENAME EMAIL.

topic How to attach multiple .pdf in SAS mail through SAS macro in SAS Programming

How to attach multiple .pdf in SAS mail through SAS macro

Re: How to attach multiple .pdf in SAS mail through SAS macro

Re: How to attach multiple .pdf in SAS mail through SAS macro