Date:         Fri, 29 Oct 2010 09:09:09 -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:  <201010290958.o9SK1SwT022017@malibu.cc.uga.edu>
Content-Type: text/plain; charset=us-ascii

> 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