Date: Fri, 18 Oct 2002 10:48:59 -0400
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
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;
table charvar='Territory', sum*numvar='Latex Sales'*f=dollar8.2
/box="As of &reportdate"
condense printmiss misstext = '0';
title 'Table 1';
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
On Thu, 17 Oct 2002 17:51:26 -0400, Chris Smith
>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
>in the box= solved my problem entirely. Thanks all.