Hello all, I am quite new to SAS and is facing challenge with respect to emails sent with SAS code. I have to send an email "Good Day" , when there are no files to attach, and if there are any files, I have to attach the file in the email . All files needed to be attached are put in macro variable &all_files. I have defined a control variable &bha, which if 0, would mean that there are no files to attach, but if it is greater than 0, there are files to attach. The problem is , when I don't have any files to attach, the variable &all_files = '', and the code is giving error in attach statement. My coffee is below: Filename outbox 'abc@xyz.com'; Data _null_; If &bha =0 then do; File outbox From = my mail To = xxx Subject = 'reports'; Put 'Good Day'; End; Else if &bha ne 0 then do; File outbox From = my mail To = xxx Subject = 'reports' Attach= (&all_files); Put 'attach are reports'; End; Run; Whenever there are no files to send, the code gives me error 'invalid value for the attach option'. Can someone please help?
... View more