Date:         Wed, 25 Mar 2009 14:55:20 -0400
Reply-To:     Akshaya <akshaya.nathilvar@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Akshaya <akshaya.nathilvar@GMAIL.COM>
Subject:      Re: ODS dyanamic date
Comments: To: Daniel Schuster <daniel.schuster@rci.com>
In-Reply-To:  <67f588aa0903251145q143d9e42n81e7838e290c885a@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

There's a caveat in using &sysdate; values of &sysdate don't change across
SAS sessions. So better to use sysfunc along with date() or today()
variables.
ods tagsets.excelxp file="/user/groups/Threshold Report
%sysfunc(today(),date9.).xls"


On Wed, Mar 25, 2009 at 2:45 PM, Akshaya <akshaya.nathilvar@gmail.com>wrote:

>
> &sysdate will be resolved in double quotes.
>
> ods tagsets.excelxp file="/user/groups/Threshold Report &sysdate..xls"
>
>
> On Wed, Mar 25, 2009 at 2:37 PM, Daniel Schuster <daniel.schuster@rci.com>wrote:
>
>> I have the following ODS statement :
>>
>> ods tagsets.excelxp file='/user/groups/Threshold Report 20090325.xls'
>> style=sasweb;
>>
>> I need to change this so that the date in the file name will equal 'today
>> ()'.
>>
>> I tried using &sysdate but I cannot get it to resolve.
>>
>> Is there a way to do this?
>>
>> Thanks,
>> Dan
>>
>
>
>
> --
> AkshayA!
>



--
AkshayA!