DATA Step, Macro, Functions and more

using a macro in an email attacment

Reply
New Contributor
Posts: 2

using a macro in an email attacment

Hi,
I'm trying to send an email with a link attached,
the name of the link includes a macro that returns today's date,
but instead of the date, the name of the macro appears in the link.

this is the code for the macro :

data _null_;
a=intnx ('month',today(),0) + day(today())-1;
dc=put (a,date7.);
call symput ('data_date',dc);
run;
%put &data_date;


this is the code for the email message :

filename emailmsg email
to=(****)
FROM='***'
subject='***';
DATA _NULL_;
FILE emailmsg;
PUT '\\netapp01\users\Merchants_General\db_year\sasoutputs\db_report_year &data_date..xls';
run;
filename emailmsg;


this is the link taht appears in the mail :

\\netapp01\users\Merchants_General\db_year\sasoutputs\db_report_year &data_date..xls

Does anyone knows what can I do to avoid this problem?

Thanks,

sivan
Super Contributor
Posts: 291

Re: using a macro in an email attacment

for the macro variable to resolve, you need to use double quotes (instead of the single quote) on this put statement

PUT "\\netapp01\users\Merchants_General\db_year\sasoutputs\db_report_year &data_date..xls" ;
New Contributor
Posts: 2

Re: using a macro in an email attacment

it works! thank tou very much!
Ask a Question
Discussion stats
  • 2 replies
  • 113 views
  • 0 likes
  • 2 in conversation