LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous (more recent) messageNext (less recent) messagePrevious (more recent) in topicNext (less recent) in topicPrevious (more recent) by same authorNext (less recent) by same authorPrevious page (March 2010, week 5)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Tue, 30 Mar 2010 15:57:24 -0400
Reply-To:     Jack Clark <jclark@HILLTOP.UMBC.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jack Clark <jclark@HILLTOP.UMBC.EDU>
Subject:      Re: OT: Chance to Make SAS-L History: Did You Know That...
In-Reply-To:  <A4F0DBF1F84D4F46A0E6D56405D3511989E823@HHAEXMB03.rf01.itservices.ca.gov>
Content-Type: text/plain; charset="us-ascii"

Did you know that you can build a date range format with PROC FORMAT and SAS Date Constants?

I almost wrote to SAS-L today to ask if this was possible, but decided to just try it myself. And it worked! It was news to me.

* format for fiscal year ; proc format; value fy '01JUL04'd - '30JUN05'd = 'FY05' '01JUL05'd - '30JUN06'd = 'FY06' '01JUL06'd - '30JUN07'd = 'FY07' '01JUL07'd - '30JUN08'd = 'FY08' '01JUL08'd - '30JUN09'd = 'FY09' ; run;

Jack Clark Senior Research Analyst phone: 410-455-6256 fax: 410-455-6850 jclark@hilltop.umbc.edu

University of Maryland, Baltimore County Sondheim Hall, 3rd Floor 1000 Hilltop Circle Baltimore, MD 21250

Please consider the environment before printing this email and/or any attachments.

Confidentiality Notice: This e-mail may contain information that is legally privileged and that is intended only for the use of the addressee(s) named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying of this e-mail, distribution, or action taken in reliance on the contents of this e-mail and/or documents attributed to this e-mail is strictly prohibited. If you have received this information in error, please notify the sender immediately by phone and delete this entire e-mail. Thank you.


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