Error with empty attach variable

[ankit1may]

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?

[RW9 · Accepted solution]

Email from dataset is not switchable like that, you would need to wrap it in macro, something like:

%macro SendMail (bha=);

  data _null_;
    %if &bha.=0 %then %do;
      file outbox from=mymail to=xxx subject='reports';
      put 'Good Day';
    %end;
    %else %do;
      file outbox from=mymail  to=xxx subject='reports' attach=(&all_files.);
      put 'attach are reports';
    %end;
  run;

%mend SendMail;

%SendMail (bha=1);   /* For no reports, just change 1 to 0 */

[ankit1may]

It really worked. Thank you:)

[mark1221]

There are various substitutions that cannot be used as a parameter expansion. You have to map the root directory as well as you have to make sure that name will not be used in the directory name. 

For more access plugins uae