Date:         Fri, 29 Oct 2010 07:57:06 -0400
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: How can i take columns dynamically
Comments: To: "SUBSCRIBE SAS-L Joe H. Smith" <peesari.mahesh@GMAIL.COM>

Joe,

Couldn't you just use the intnx function?  See, e.g.:
http://support.sas.com/documentation/cdl/en/lrdict/63026/HTML/default/viewe
r.htm#a000212700.htm

HTH,
Art
--------
On Fri, 29 Oct 2010 05:58:59 -0400, SUBSCRIBE SAS-L Joe H. Smith
<peesari.mahesh@GMAIL.COM> wrote:

>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