Date:         Wed, 14 May 2003 15:06:41 -0400
Reply-To:     Howard Schreier <Howard_Schreier@ITA.DOC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Howard Schreier <Howard_Schreier@ITA.DOC.GOV>
Subject:      Re: Space problem

It also seems likely that you will encounter space problems when you have
to do other things with this dataset.

Have you looked at ways of reducing storage requirements? For example:
optimizing variable lengths, compression, normalization

On Wed, 14 May 2003 11:50:49 -0600, Jack Hamilton
<JackHamilton@FIRSTHEALTH.COM> wrote:

>The easiest way to do this is by using a view:
>
>=====
>proc sql;
>   create view neworder as
>      select column2,
>             column1
>      from   oldorder;
>quit;
>=====
>
>An alternative is to use a data step view.
>
>But why do you think you need to do this?
>
>
>
>
>--
>JackHamilton@FirstHealth.com
>Manager, Technical Development
>Metrics Department, First Health
>West Sacramento, California USA
>
>>>> Basem <batawfic@YAHOO.COM> 05/14/2003 10:37 AM >>>
>I have 250 Million record in dataset A
>
>I want to exchange the order of columns, this means that column 1
>appears as the second column. I do not have enough space to use
>datastep.
>
>Is there any way to do this while working on the same dataset,
>something like changing some features in dataset header for example so
>they change their columns order?