Date:         Mon, 15 Jul 2002 16:10:21 -0400
Reply-To:     "Braten, Michael (Exchange)" <mbraten@BEAR.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Braten, Michael (Exchange)" <mbraten@BEAR.COM>
Subject:      Re: deleting a variable
Comments: To: Kevin Auslander <kevin.auslander@CCSITEAM.COM>
Content-Type: text/plain

Might I also suggest:

 PROC SQL;
  alter table  mylib.mydata   drop unWantedvariable  ;




> -----Original Message-----
> From: Kevin Auslander [SMTP:kevin.auslander@CCSITEAM.COM]
> Sent: Monday, July 15, 2002 4:01 PM
> To:   SAS-L@LISTSERV.UGA.EDU
> Subject:      deleting a variable
>
> I want to delete a variable from a large dataset as efficiently as
> possible.  I know that
>
> Data mylib.mydata(drop=unWantedVariable);
>         Set mylib.mydata;
> Run;
>
> will drop the unwanted variable.  But, is it most efficient?  It seems
> like this program will cause a reading of the entire dataset.  Is
> reading the entire data set a necessary step for deleting a variable?
>
> TIA,
>
> Kevin


***********************************************************************
Bear Stearns is not responsible for any recommendation, solicitation,
offer or agreement or any information about any transaction, customer
account or account activity contained in this communication.
***********************************************************************