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