using a macro in an email attacment

[sivan_a]

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

[Bill]

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" ;

[sivan_a]

it works! thank tou very much!