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

Sharath_naik · Posted 12-22-2020 02:05 AM

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

RichardDeVen · Posted 12-22-2020 06:20 AM

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

Kurt_Bremser · Posted 12-22-2020 07:02 AM

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.

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

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

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

2025 SAS Hackathon: There is still time!

SAS Training: Just a Click Away