LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (March 2009, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Fri, 27 Mar 2009 08:01:59 -0500
Reply-To:   "./ ADD NAME=Data _null_;" <iebupdte@GMAIL.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   "./ ADD NAME=Data _null_;" <iebupdte@GMAIL.COM>
Subject:   Re: ODS dyanamic date
Comments:   To: Daniel Schuster <daniel.schuster@rci.com>
In-Reply-To:   <200903271238.n2RAlKMC024430@malibu.cc.uga.edu>
Content-Type:   text/plain; charset=ISO-8859-1

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 >


Back to: Top of message | Previous page | Main SAS-L page