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
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.
On Sun, Oct 4, 2009 at 1:15 PM, dave crimkey <firstname.lastname@example.org> 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?