I tried your suggestion and it didn't work. I'm using EG4, SAS 9.1 running on a Unix box.

ods tagsets.excelxp file='/user/OutputRpt/test_%sysfunc(today (),yymmddn8).xls';

proc print data=sashelp.class; run;

NOTE: Writing TAGSETS.EXCELXP Body file: /user/OutputRpt/Threshold_test_% sysfunc(today(),yymmddn8).xls NOTE: This is the Excel XP tagset (SAS 9.1.3, v1.28, 08/29/05). Add options (doc='help') to the ods statement for more information. 14 ods tagsets.excelxp file='/user/groups/revmgt/KIM Team/OutputRpt/Threshold_test_%sysfunc(today(),yymmddn8).xls'; 15 16 proc print data=sashelp.class; 17 run;

Dan

On Fri, 27 Mar 2009 08:01:59 -0500, ./ ADD NAME=Data _null_; <iebupdte@GMAIL.COM> wrote:

>You omitted one of the closing parenthesis. > >268 ods html file="daniel_%sysfunc(today(),yymmddn8).xls"; >NOTE: Writing HTML Body file: daniel_20090327.xls >269 proc print data=sashelp.class; >270 run; > > > >On 3/27/09, Daniel Schuster <daniel.schuster@rci.com> wrote: >> On Thu, 26 Mar 2009 08:54:57 -0700, Nordlund, Dan (DSHS/RDA) >> <NordlDJ@DSHS.WA.GOV> wrote: >> >> >> -----Original Message----- >> >> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of >> >> Daniel Schuster >> >> Sent: Thursday, March 26, 2009 5:42 AM >> >> To: SAS-L@LISTSERV.UGA.EDU >> >> Subject: Re: ODS dyanamic date >> >> >> >> This is what I ended up with: >> >> >> >> 15 data _null_; >> >> 16 call symputx("TodaysDate",left(put(today() ,yymmddn8.))); >> >> 17 run; >> >> 18 %put today is &TodaysDate ; >> >> today is 20090326 >> >> >> >> >> >Daniel, >> > >> >I am curious about why you chose to use a _null_ data step to assign the >> macro value, rather than >> > >> >%let TodaysDate = %sysfunc(today(),yymmddn8.); >> > >> >or just using %sysfunc(today(),yymmddn8.) where you need the value. >> Again, I am just curious. >> > >> >Dan >> > >> >Daniel J. Nordlund >> >Washington State Department of Social and Health Services >> >Planning, Performance, and Accountability >> >Research and Data Analysis Division >> >Olympia, WA 98504-5204 >> >> First of all, I need a spell checker here; its 'dynamic' not 'dyanamic' :-( >> >> I ended up using a _null_ data step because when I used the %sysfunc >> directly on the ODS statement if didn't resolve and I ended up with the >> name ending in _%sysfunc(today(),yymmddn8..xls which would have really >> confused the people using the spreadsheet. >> >> Dan >>