Date:         Wed, 25 Mar 2009 11:44:17 -0700
Reply-To:     Daniel Nordlund <djnordlund@VERIZON.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Daniel Nordlund <djnordlund@VERIZON.NET>
Subject:      Re: ODS dyanamic date
In-Reply-To:  <200903251837.n2PFs0B0023758@malibu.cc.uga.edu>
Content-type: text/plain; charset=iso-8859-1

> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On
> Behalf Of Daniel Schuster
> Sent: Wednesday, March 25, 2009 11:37 AM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: ODS dyanamic date
>
> 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

You need to change your single quotes to double quotes.

   ods tagsets.excelxp file="/user/groups/Threshold Report &sysdate..xls"
style=sasweb;

Hope this is helpful,

Dan

Daniel Nordlund
Bothell, WA USA