Date:         Sun, 4 Oct 2009 13:29:14 -0500
Reply-To:     Joe Matise <snoopy369@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Joe Matise <snoopy369@GMAIL.COM>
Subject:      Re: Dynamic column ordering
Comments: To: dave crimkey <d_crimkey@yahoo.com>
In-Reply-To:  <690579.94326.qm@web112520.mail.gq1.yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1

You can make a dynamic retain statement, ie use proc sql to select from
dictionary.columns and/or from a proc contents output, and use that.

-Joe

On Sun, Oct 4, 2009 at 1:15 PM, dave crimkey <d_crimkey@yahoo.com> wrote:

> I've created a report that results from a transpose of year/month.  Since
> the columns look like the following:  200701 200702.....200909 they are not
> coming out in the correct order.  I don't want to hard-code a retain
> statement in because I don't want to have to update the statement every
> month.  What is a good way of correctly ording the columns?
>
> Thanks,
> Dave
>