Date:         Fri, 18 Oct 2002 10:48:59 -0400
Reply-To:     Howard_Schreier@ITA.DOC.GOV
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Howard_Schreier@ITA.DOC.GOV
Subject:      Re: Why won't my macro variable resolve in double quotes

Indeed you had two distinct problems, and when you first posted one was
masking the other.

Your original code:

   %let reportdate = today();

   proc tabulate data = mydata;
     class charvar;
     var numvar;
     table charvar='Territory', sum*numvar='Latex Sales'*f=dollar8.2
     /box="As of &reportdate"
     condense printmiss misstext = '0';
     keylabel sum='Total';
     title 'Table 1';
   run;

puts the following text in the box:

   As of today()

So you need the %SYSFUNC, and it ought to work Ron's way (coded in the %LET
assignment).

On Thu, 17 Oct 2002 17:51:26 -0400, Chris Smith
<vandalay-industries@WWW.COM> wrote:

>Posted to the wrong topic...again...I'm going home now.
>
>> %LET REPORTDATE = TODAY();
>> %PUT REPORTDATE <&REPORTDATE.>;
>
>> Try one of these:
>> %LET REPORTDATE = %sysfunc(date(),weekdate17.);
>> %LET REPORTTIME = %sysfunc(time(),time5.);
>
>> Ron Fehd  the macro maven  CDC Atlanta GA USA RJF2@cdc.gov
>
>Thanks Ron, that solves part of my problem, but my mox in the tabulations
>still says &reportdate.
>
>HOWEVER, as Nancy Brucken graciously suggested, sticking
>
>%sysfunc(date(),weekdate17.)
>
>in the box= solved my problem entirely.  Thanks all.
>
>Chris