Date:         Sun, 16 Feb 2003 10:06:43 -0500
Reply-To:     "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Subject:      Re: Re-ordering the positions of columns

"lpogoda" <lpogodajr292185@comcast.net> wrote in message
news:b2msv8$1e2vga$2@ID-171604.news.dfncis.de...
>
snip
> destinations, and it didn't work for them either.  Digging into the guts
of
> the thing, it turned out that he was controlling the print order by
> rewriting the dataset according to the variable order parameter, and doing
> it in exactly the way you suggested at the top of this post, with a RETAIN
> statement followed by a macro variable.

If NPOS instead of VARNUM were used to order the generated variable list,
you may have been bitten by
http://support.sas.com/techsup/unotes/SN/002/002676.html

"
In Version 6 of the SAS System, the position of variables on a SAS data
   set is determined by the order in which they are encountered regardless
   of their type or length. In order to improve performance, Version 7 and
   beyond of the SAS System positions 8 byte and 4 byte numeric variables
   at 8 byte boundaries at the front of a SAS data set.
...
"

--
Richard A. DeVenezia, http://www.devenezia.com