Date:         Sun, 9 May 2004 18:04:29 -0400
Reply-To:     Quentin McMullen <quentin_mcmullen@BROWN.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Quentin McMullen <quentin_mcmullen@BROWN.EDU>
Subject:      Re: Question about DDE

On Sun, 9 May 2004 14:49:34 -0400, Kevin Roland Viel <kviel@EMORY.EDU> wrote
in part:

>On Sun, 9 May 2004, ma015 b8234 wrote:
> <snip>
>> data _Null_;
>>    file otherway;
>>     put '[SELECT("R1C1")]';
>>     put '[SAVE.as("I:\Reports\Monthly_Report&ddmmmyyyy&_hour.xls")]';
>
>This macro variable will not resolve.
>
>Try:
>
>put
>%unquote(%str(%'[SAVE.as%(%"I:\Reports\Monthly_Report)&ddmmmyyyy&_hour%str(.xls%"%)]%';));

If you don't want to deal with macro quoting, another option is something
like (untested):

put '[SAVE.as("' "I:\Reports\Monthly_Report&ddmmmyyyy&_hour.xls" '")]';

Save.as command still gets the quote marks it wants, but SAS resolves the
macro vars in the file name because they are not inside any single quotes.

--Quentin