Date:         Fri, 20 Apr 2007 21:28:48 -0400
Reply-To:     Lou <lpogodajr292185@COMCAST.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Lou <lpogodajr292185@COMCAST.NET>
Subject:      Re: Physical deletion of obs
Comments: To: sas-l@uga.edu

"SASuser.co.kr" <chulgyu100@yahoo.co.kr> wrote in message
news:1176960172.742213.208600@y80g2000hsf.googlegroups.com...
> Hi,
>
> At SAS BASE(V9, V8 etc), the default action is logical deletion.
> But, I want to physically delete observations using DELETE clause of
> PROC SQL.
>
> anyone has good idea?

Adjust your wants.  That's not what the DELETE clause does.  To physically
remove an observation from a dataset, the dataset must be rewritten.  If the
dataset is compressed, new observations will be added where there's enough
space, overlaying the logically deleted observations provided the REUSE
option was set to YES when the dataset was created and if the observations
are added with certain procs - for instance the APPEND and FSEDIT procedures
will still add observations to the end.