Date:         Fri, 27 Mar 2009 08:38:41 -0400
Reply-To:     Daniel Schuster <daniel.schuster@RCI.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Daniel Schuster <daniel.schuster@RCI.COM>
Subject:      Re: ODS dyanamic date

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