Date: Thu, 6 Apr 2000 13:34:39 GMT
Reply-To: Patrice Bourdages <pbourdages@IAG.QC.CA>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Patrice Bourdages <pbourdages@IAG.QC.CA>
Organization: Bell Solutions
Subject: Week of the year function ???
Is there a function, or a macro, that I could use to assign a week number in
a year from a date. Ex.:
2000-01-01 might be week # 1
2000-12-31 would be week # 52
My point is to assign a week number to transactions dates for summary (in a
"pseudo-cube"). It would be part of an hierarchy.
There are function for QTR() and some other interesting ones.
Thanks you all for your help.
--
Sincerely yours,
Patrice Bourdages
pbourdages@iag.qc.ca
IS Analyst
L'Industrielle Alliance Auto et Habitation
Quebec, Quebec, Canada
|