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 (July 2002, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Wed, 10 Jul 2002 11:04:27 -0700
Reply-To:     Pete Lund <pete.lund@NWCSR.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Pete Lund <pete.lund@NWCSR.COM>
Subject:      Re: Automatic Axis Statement
In-Reply-To:  <OF955C1FD7.FE150C17-ON41256BF2.0067211C@db.com>
Content-Type: text/plain; charset="iso-8859-1"

I would add one thing to Peter's solution. Since &SYSDATE returns the date when the SAS session was started it is not always the current date. You could simply substitute the TODAY() function, in its own SYSFUNC, for &SYSDATE.

Something like:

%sysfunc( intnx( week, %sysfunc(today()) , -1, ending ) )

---------------------------------------------------------------------------- --- Pete Lund Northwest Crime and Social Research, Inc. A SAS Alliance Partner 215 Legion Way SW Olympia, WA 98501 (360) 528-8970 - voice (360) 280-4892 - cell (360) 570-7533 - fax pete.lund@nwcsr.com www.nwcsr.com ---------------------------------------------------------------------------- ---

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of Peter Crawford Sent: Wednesday, July 10, 2002 11:55 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: Automatic Axis Statement

The derivation (today()-weekday(today())) looks like you want the last day of last week

It can be done in the %sysfunc environment, like %sysfunc( intnx( week, "&sysdate"d, -1, ending ) )

It will deliver a number of days since 1960, but that seems to be what you need if '06oct01'd is appropriate

Good Luck Peter Crawford

-----Original Message----- From: E. S. [mailto:sasq98@YAHOO.COM] Sent: Wednesday, July 10, 2002 7:48 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Automatic Axis Statement

Hi all,

I have a problem that seemed trivial when I looked at it first but that now is giving me all kinds of headaches.

I have an axis statement that looks like this:

axis1 order = ('06oct01'd to '29jun02'd by 7);

It works fine but now I want to be able to change the endpoints by using a formula. Something like:

axis1 order = ('06oct01'd to (today()-weekday(today())) by 7);

I get an error when I try that, can anybody tell me how could I code it soo that I don't have to be manually updating this axis statement every week?

Thanks a lot,

Ed

--

Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.

This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.


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