LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous (more recent) messageNext (less recent) messagePrevious (more recent) in topicNext (less recent) in topicPrevious (more recent) by same authorNext (less recent) by same authorPrevious page (April 2007, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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.


Back to: Top of message | Previous page | Main SAS-L page