Date: Fri, 12 Aug 2005 10:44:44 +0300
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Organization: KTL (Kansanterveyslaitos)
Subject: Re: Arranging variables
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>
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.