LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (October 2009, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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 >


Back to: Top of message | Previous page | Main SAS-L page