using a macro in an email attacment

sivan_a — Thu, 07 May 2009 11:37:50 GMT

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

Re: using a macro in an email attacment

Bill — Thu, 07 May 2009 12:38:05 GMT

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

Re: using a macro in an email attacment

sivan_a — Thu, 07 May 2009 13:32:11 GMT

it works! thank tou very much!

topic using a macro in an email attacment in SAS Programming

using a macro in an email attacment

Re: using a macro in an email attacment

Re: using a macro in an email attacment