Date:         Fri, 12 Aug 2005 10:44:44 +0300
Reply-To:     user@DOMAIN.INVALID
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         user@DOMAIN.INVALID
Organization: KTL (Kansanterveyslaitos)
Subject:      Re: Arranging variables
Comments: To: sas-l@uga.edu
In-Reply-To:  <200508111959.j7BJxXcS013134@listserv.cc.uga.edu>
Content-Type: text/plain; charset=us-ascii; format=flowed

Venky Chakravarthy wrote:

> That is indeed true for newly created variables. However, Paolo's original
> question in part read:
>
>
>>>For example, if I want variable "revenue" to appear in my data set
>>>before variable "costs"
>
>
> It appears that he already has a data set. He only wants to rearrange
> existing variables. Existing variables from a SET, MERGE, UPDATE or MODIFY
> are automatically RETAINed. So an explicit RETAIN placed before any of the
> above has no other purpose than reordering the variables in the PDV.
>
> If you search the archives of SAS-L, you will find that this is not the
> first time that this question has been asked. You will also find that this
> is not the first time a solution involving RETAIN has been suggested.
>
> On Thu, 11 Aug 2005 22:23:58 +0300, Vladislav <vladislav.moltchanov@KTL.FI>
> wrote:
>
In fact,  good question is what could be a purpose of  re-arranging.
If for printing, the best is using macrovariable.
The "true" rearranging could be done using dataset procedure, anyway,
the  list of "properly" ordered variables is required.

--
Vladislav