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
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
> 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
> 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:
mon01 length = 4 label = 'Jan'
mon02 length = 4 label = 'Feb'
mon12 length = 4 label = 'Dec'
Ron Fehd the naming-conventions maven