Date:         Tue, 17 Sep 2002 12:19:56 -0600
Reply-To:     Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Subject:      Re: Deleting data set in a data step
Comments: To: WHITLOI1@WESTAT.com
Content-Type: text/plain; charset=US-ASCII

Interesting.  It doesn't seem to recognize data step views.  Yet
(according to a usage note; I haven't tried it), it can be used to
delete a view of an Oracle table established through a libname.  There's
some inconsistency there.

A little birdie tells me they're considering adding PROC DELETE back to
the documentation in a future release.




--
JackHamilton@FirstHealth.com
Manager, Technical Development
METRICS Department, First Health
West Sacramento, California USA


>>> "Ian Whitlock" <WHITLOI1@WESTAT.com> 09/17/2002 5:36 AM >>>
Jack,

This is what they mean by it is "obsolete" and maybe "supported".

19   data v / view = v ;
20      x = 1 ;
21   run ;

NOTE: DATA STEP view saved on file WORK.V.
NOTE: A stored DATA STEP view cannot run under a different operating
system.
NOTE: DATA statement used:
      real time           0.16 seconds


22   proc delete data = v ;
23   run ;

WARNING: File WORK.V.DATA does not exist.
NOTE: PROCEDURE DELETE used:
      real time           0.04 seconds

IanWhitlock@westat.com

-----Original Message-----
From: Jack Hamilton [mailto:JackHamilton@FIRSTHEALTH.COM]
Sent: Monday, September 16, 2002 1:28 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Deleting data set in a data step


I wonder what they mean by "supported", if that does not include
"documented".

The tech support notes say  "The DELETE procedure was replaced by the
DELETE statement in PROC DATASETS beginning with Release 6.06."

On the other hand, there are version 8 notes which specifically
recommend PROC DELETE to work around problems in other procedures, and
there are current examples which use it.




--
JackHamilton@FirstHealth.com
Manager, Technical Development
METRICS Department, First Health
West Sacramento, California USA


>>> paul_dorfman@HOTMAIL.COM 09/13/2002 10:48 PM >>>
Brad,

It is, in fact, supported in version 9. I have no clue why it is not
documented. If redundancy is the problem, then methods of slaughtering
SAS
data sets are redundant enough without the DELETE proc...

Kind regards,
=================
Paul M. Dorfman
Jacksonville, FL
=================

From: "Goldman, Brad (AT-Atlanta)" <Brad.Goldman@AUTOTRADER.COM>

It is no longer documented, but I was told from a little birdie that
is
supported and will continue to be supported.  And great undocumented
features and tricks is what SAS-L is all about! :)

Brad

 > Yes, PROC DELETE is easier, but has been made obsolescent
 > (too quick and
 > easy to use, I suppose) and is no longer documented.




_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com