Date: Tue, 31 Aug 2004 11:31:36 -0700
Reply-To: David Fickbohm <DavidF@HOMEGAIN.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: David Fickbohm <DavidF@HOMEGAIN.COM>
Subject: Rolling twelve months
Content-Type: text/plain; charset="iso-8859-1"
Looking for your thoughts on the best way to create a monthly report based
on a rolling twelve months.
All of the calculations for this report are done and then the data is split
out by month.
My thought is to create a simple macro that that just substitutes in a
month. Each month I remove one month from the top line that executes the
macro and add a month to the bottom line that executes the macro.
I would appreciate people thoughts on this.
Data Mining Analyst
2450 45th St.
Emeryville, CA, 94608
Phone 510 655 0800 ext 4151