Date:         Fri, 29 Oct 2010 09:46:04 -0400
Reply-To:     "Fehd, Ronald J. (CDC/OCOO/ITSO)" <rjf2@CDC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Fehd, Ronald J. (CDC/OCOO/ITSO)" <rjf2@CDC.GOV>
Subject:      Re: How can i take columns dynamically
In-Reply-To:  <BAY123-W173E6C844B91D1B4DD2674DE450@phx.gbl>
Content-Type: text/plain; charset=us-ascii

> -----Original Message-----
> From: toby dunn
> Sent: Friday, October 29, 2010 9:36 AM
> Subject: RE: How can i take columns dynamically
>
> You would be better served by having your data in a normalized form:

Toby
Yes, I aggree the solution is getting the correct data structure.

If I read the original Q accurately
the user has an Accumulating Snapshot type of table

Database Vocabulary:
Is Your Data Set a Dimension (LookUp) Table,
a Fact Table or a Report?

http://www.lexjansen.com/wuss/2008/dmw/dmw04.pdf

these tables have entity-id and sets of variables for milestones
in this case columns named months with facts
such as amount billed/used during month


Ron Fehd  the data-structure maven


>
> Date               Value
> 01Apr2010         1
> 01May2010        2
> 01Jun2010         3
>
>
> If the Date variable is a SAS Date value, you now have the full
> functionality of SAS to select the correct months with ease.
> Then use either Proc Report or Proc Tabulate to create your report.
>
> Toby Dunn
>
>
> "I'm a hell bent 100% Texan til I die"
>
> "Don't touch my Willie, I don't know you that well"
>
>
>
>
> > Date: Fri, 29 Oct 2010 08:21:05 -0500
> > From: peesari.mahesh@GMAIL.COM
> > Subject: Re: How can i take columns dynamically
> > To: SAS-L@LISTSERV.UGA.EDU
> >
> > i need to maintain a report contain information of last 6 months,
> > means i have a report apr, may,,jun, jul ,aug,sep month data, these
> months
> > are columns
> > in next month when i execute report oct month shouls add to report
> and apr
> > month should hidden.
> > i am writing code for report in proc report or datastep report ,
here
> i am
> > defining columns thru hardcode
> > when i execute report in next month how oct column will pick?
> >
> >
> >
> > On Fri, Oct 29, 2010 at 8:09 AM, Fehd, Ronald J. (CDC/OCOO/ITSO) <
> > rjf2@cdc.gov> wrote:
> >
> > > > From: Joe H. Smith
> > > > Sent: Friday, October 29, 2010 5:59 AM
> > > > Subject: How can i take columns dynamically
> > > >
> > > > Hi,
> > > > I have a report its presenting last 6 months business data for
> example
> > > >
> > > > Apr May Jun Jul Aug Sep
> > > > 1 2 3 4 5 6
> > > > 5 3 4 6 2 3
> > > >
> > > > In next month when i generate report it should add Oct month and
> data
> > > > and
> > > > hidden Apr month it means the report contains always last
6months
> from
> > > > execution date, so how can i take data like that dynamically
> > >
> > > your task will be simplified by an order of magnitude
> > > if you name your variables:
> > >
> > > attrib
> > > mon01 length = 4 label = 'Jan'
> > > mon02 length = 4 label = 'Feb'
> > > ...
> > > mon12 length = 4 label = 'Dec'
> > > ;
> > >
> > >
> > > Ron Fehd the naming-conventions maven
> > >
> >
> >
> >
> > --
> > ******
> > " The next best thing to winning is losing At least you've been in
> the
> > race."
> >
> >
> > ******
>